From 427a7cc555c7337c68a54acdf8684fb1f7993260 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 8 Feb 2021 11:52:17 +0100 Subject: [PATCH] Bug 23675: Add leader and default value for ACQ MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit When UseACQFrameworkForBiblioRecords is set, the ACQ framework will be use when ordering. But the leader is not defined for this framework and then we will face encoding issues (I haven't go far investigating this as the suggested solution worked correctly). The idea is to define a 000 and default to ' nam a22 7a 4500' (which is what returns the marc21_leader.pl plugin) for ACQ. Test plan: 0. Apply this patch and reset_all 1. Create a new basket and place a new order 2. Note that the leader is now displayed on top of the other ACQ subfields 3. Fill in 245 with "❤️", "ö" or other UTF-8 characters you like 4. Save 5. Notice that 245$a in biblio_metadata is correctly filled with the title you entered Signed-off-by: Katrin Fischer Signed-off-by: Martin Renvoize Signed-off-by: Jonathan Druart (cherry picked from commit a6527b105897e4611dd702ffbe627ca579baff77) Signed-off-by: Fridolin Somers (cherry picked from commit abe0f0360cce1535a52bc5981cd1ac02397b816a) Signed-off-by: Andrew Fuerste-Henry --- .../marc21/mandatory/marc21_framework_DEFAULT.yml | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml index 3bc8411bc7..7e73c245a3 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml @@ -78185,7 +78185,13 @@ sql_statements: - "UPDATE marc_subfield_structure SET maxlength=24 WHERE tagfield='000';" - "UPDATE marc_subfield_structure SET maxlength=40 WHERE tagfield='008';" - # Create the ACQ framework based on the default framework, fields 952 only + # Create the ACQ framework based on the default framework, fields 000 and 952 only + - "INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) + SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' FROM marc_tag_structure WHERE tagfield='000' AND frameworkcode='';" + + - "INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) + SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, ' nam a22 7a 4500', maxlength FROM marc_subfield_structure WHERE tagfield='000' AND frameworkcode='';" + - "INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' FROM marc_tag_structure WHERE tagfield='952' AND frameworkcode='';" -- 2.39.5