From 7003e2d8e5279f9622bc40143a62b55d5791684b Mon Sep 17 00:00:00 2001 From: Caroline Cyr La Rose Date: Fri, 9 Feb 2024 17:17:21 -0500 Subject: [PATCH] Bug 36055: Simplify MARC21 Fast Add framework This patch removes or hides a lot of unecessary fields from the MARC21 Fast Add framework, notably subfields $6 and $8 which are used only in advanced cataloging. Fast Add is meant to add an item fast, while the patron is waiting, in order to check it out to them. There is no need to enter details, only what is necessary to identify and check out the item. To test: 1. Go to Circulation > Fast cataloging --> Notice all the fields present 2. Fill out mandatory fields (000, 008, 245$a, 942$c) 3. Click 'Save' --> Notice all the item fields present 4. Apply patch and reset 5. Redo steps 1-3 --> There should be a lot less fields Signed-off-by: David Nind --- .../marc21_sample_fastadd_framework.yml | 118 ++++++++---------- 1 file changed, 50 insertions(+), 68 deletions(-) diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.yml b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.yml index 03cb7ac36b..23862b6cbf 100644 --- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.yml +++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.yml @@ -48,71 +48,53 @@ sql_statements: # REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES - "UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA';" - - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '010' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '020' AND tagsubfield = 'c' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '020' AND tagsubfield = 'q' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '022' AND tagsubfield = '2' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '022' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '022' AND tagsubfield = 'y' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '022' AND tagsubfield = 'z' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '050' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '050' AND tagsubfield = 'b' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '082' AND tagsubfield = '2' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '082' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '082' AND tagsubfield = 'b' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '100' AND tagsubfield = 'd' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '100' AND tagsubfield = 'e' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '100' AND tagsubfield = 'q' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '245' AND tagsubfield = 'h' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '250' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '250' AND tagsubfield = 'b' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '260' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '260' AND tagsubfield = 'b' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '260' AND tagsubfield = 'c' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'b' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'c' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'e' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'f' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'g' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '500' AND tagsubfield = 'a' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'e' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'h' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'i' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'k' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'm' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = '0' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = '4' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = '5' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'e' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'f' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'g' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'i' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 't' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'u' AND frameworkcode = 'FA';" + - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'w' AND frameworkcode = 'FA';" \ No newline at end of file -- 2.30.2