Attachment 147768 Details for Bug 33138 – Bug 33138: Don't copy tag 147 to authority MARC frameworks

[patch] Bug 33138: Don't copy tag 147 to authority MARC frameworks

Bug-33138-Dont-copy-tag-147-to-authority-MARC-fram.patch (text/plain), 9.51 KB, created by Phil Ringnalda on 2023-03-05 03:38:35 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Phil Ringnalda

Created: 2023-03-05 03:38:35 UTC

Size: 9.51 KB

patch

obsolete

>From 34d03cca64bcf2d8627ef96de7c6e7cf41a476e8 Mon Sep 17 00:00:00 2001
>From: Phil Ringnalda <phil@chetcolibrary.org>
>Date: Sat, 4 Mar 2023 19:26:22 -0800
>Subject: [PATCH] Bug 33138: Don't copy tag 147 to authority MARC frameworks
>
>We shouldn't be including tag 147 in every authority MARC framework we
>install, since like all 1xx authority tags there should only be
>one per record. It only belongs in a NAME_EVENT framework, which we
>don't install.
>
>Test plan:
>
>1. Apply patch, kd && ku or however you like to restart
>2. Administration - Authority types - Actions button for Default
>   - MARC structure
>3. In the search box below the text "Select an authority framework"
>   enter 147 and click OK
>4. Once you see that it exists in Default, switch the dropdown to
>   each of the other frameworks and verify it doesn't appear in
>   any.
>---
> .../mandatory/authorities_normal_marc21.yml   | 32 +++++++++----------
> 1 file changed, 16 insertions(+), 16 deletions(-)
>
>diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml
>index 8e9178ee77..1015243e90 100644
>--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml
>+++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml
>@@ -32748,7 +32748,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ('110','111','130','148','150','151','155','162',
>+     tagfield NOT IN ('110','111','130','147','148','150','151','155','162',
>                       '180','181','182','185','034','640','641','642',
>                       '643','644','645','646');"
> 
>@@ -32762,7 +32762,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ('110','111','130','148','150','151','155','162',
>+     tagfield NOT IN ('110','111','130','147','148','150','151','155','162',
>                      '180','181','182','185','034','640','641','642',
>                      '643','644','645','646');"
> 
>@@ -32775,7 +32775,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','111','130','148','150','151','155','162',
>+     tagfield NOT IN ( '100','111','130','147','148','150','151','155','162',
>                        '180','181','182','185','034','640','641','642',
>                        '643','644','645','646');"
> 
>@@ -32789,7 +32789,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','111','130','148','150','151','155','162',
>+     tagfield NOT IN ( '100','111','130','147','148','150','151','155','162',
>                        '180','181','182','185','034','640','641','642',
>                        '643','644','645','646');"
> 
>@@ -32802,7 +32802,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','130','148','150','151','155','162',
>+     tagfield NOT IN ( '100','110','130','147','148','150','151','155','162',
>                        '180','181','182','185','640','641','642','643',
>                        '644','645','646');"
> 
>@@ -32816,7 +32816,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','130','148','150','151','155','162',
>+     tagfield NOT IN ( '100','110','130','147','148','150','151','155','162',
>                        '180','181','182','185','640','641','642','643',
>                        '644','645','646');"
> 
>@@ -32829,7 +32829,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','148','150','151','155','162',
>+     tagfield NOT IN ( '100','110','111','147','148','150','151','155','162',
>                        '180','181','182','185');"
> 
>   - "INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
>@@ -32842,7 +32842,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','148','150','151','155','162',
>+     tagfield NOT IN ( '100','110','111','147','148','150','151','155','162',
>                        '180','181','182','185');"
> 
>   # CHRONOLOGICAL TERMS AUTHORITY FIELDS/SUBFIELDS. X48
>@@ -32854,7 +32854,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','150','151','155','162',
>+     tagfield NOT IN ( '100','110','111','130','147','150','151','155','162',
>                        '180','181','185','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
> 
>@@ -32868,7 +32868,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','150','151','155','162',
>+     tagfield NOT IN ( '100','110','111','130','147','150','151','155','162',
>                        '180','181','185','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
> 
>@@ -32881,7 +32881,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','148','151','155','162',
>+     tagfield NOT IN ( '100','110','111','130','147','148','151','155','162',
>                        '181','182','185','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
> 
>@@ -32895,7 +32895,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','148','151','155','162',
>+     tagfield NOT IN ( '100','110','111','130','147','148','151','155','162',
>                        '181','182','185','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
> 
>@@ -32908,7 +32908,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','148','150','155','162',
>+     tagfield NOT IN ( '100','110','111','130','147','148','150','155','162',
>                        '180','182','185','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
> 
>@@ -32922,7 +32922,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','148','150','155','162',
>+     tagfield NOT IN ( '100','110','111','130','147','148','150','155','162',
>                        '180','182','185','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
> 
>@@ -32935,7 +32935,7 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','148','150','151','162',
>+     tagfield NOT IN ( '100','110','111','130','147','148','150','151','162',
>                        '180','181','182','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
> 
>@@ -32949,6 +32949,6 @@ sql_statements:
>                        '154','253','353','453','553','668','671','676',
>                        '684','685','686','687','753','754',
>                        '761','763','764','765','766','768') AND
>-     tagfield NOT IN ( '100','110','111','130','148','150','151','162',
>+     tagfield NOT IN ( '100','110','111','130','147','148','150','151','162',
>                        '180','181','182','014','020','022','031','640',
>                        '641','642','643','644','645','646');"
>-- 
>2.26.1

Actions: View | Diff | Splinter Review

Attachments on bug 33138: 147768 | 149706 | 150364