Attachment 116492 Details for Bug 23675 – Bug 23675: Add leader and default value for ACQ

[patch] Bug 23675: Add leader and default value for ACQ

Bug-23675-Add-leader-and-default-value-for-ACQ.patch (text/plain), 2.98 KB, created by Jonathan Druart on 2021-02-08 10:56:39 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-02-08 10:56:39 UTC

Size: 2.98 KB

patch

obsolete

>From b8afda6c4cfc62e01b84848315734af3b925e774 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>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=UTF-8
>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 000 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
>---
> .../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 a7b2f89db3..1c1e557228 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
>@@ -78077,7 +78077,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.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 23675: 93884 | 116492 | 116520 | 117164