[Bug 28337] New: Add System-control-number index for authorities to MARC21 indexes
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Bug ID: 28337 Summary: Add System-control-number index for authorities to MARC21 indexes Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Zebra Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com https://www.loc.gov/marc/authority/ad035.html The 035 field in authorities can contain a system control number, this is useful for authority cleanup work as it can contain a non-Koha id for the record When importing, however, we cannot use this field for matching as it is not indexed -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Patch complexity|--- |Trivial patch -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 --- Comment #1 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 120894 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120894&action=edit Bug 28337: Add System-control-number index to Zebra MARC21 files To test: 1 - Apply patch 2 - Copy zebra files to destination: cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml /etc/koha/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl /etc/koha/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl 3 - Reindex authorities 4 - Edit an authority and add 035$aExpialodocious 5 - Export the authority 6 - Create a new record matchign rule: Matching rule code: SCN Description: System control number Match threshhold: 1000 Record type: Authority record Search-index: System-control-number Score: 1000 Tag: 035 Subfields: a 7 - Stage the record and use the new matchign rule 8 - Match found! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |nick@bywatersolutions.com |ity.org | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=18540 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #120894|0 |1 is obsolete| | --- Comment #2 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- Created attachment 120946 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120946&action=edit Bug 28337: Add System-control-number index to Zebra MARC21 files To test: 1 - Apply patch 2 - Copy zebra files to destination: cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml /etc/koha/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl /etc/koha/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl 3 - Reindex authorities 4 - Edit an authority and add 035$aExpialodocious 5 - Export the authority 6 - Create a new record matchign rule: Matching rule code: SCN Description: System control number Match threshhold: 1000 Record type: Authority record Search-index: System-control-number Score: 1000 Tag: 035 Subfields: a 7 - Stage the record and use the new matchign rule 8 - Match found! Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi :) Some small things: 1) Patch includes an unrelated change to koha-tmpl/intranet-tmpl/prog/en/includes/tools-item-action.inc. 2) Index name: We already have an index on 035 for bibliographic records. My suggestion is to have the index names match, to make them a little easier to work with. It's Other-control-number or ocn. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #120946|0 |1 is obsolete| | --- Comment #4 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 123184 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=123184&action=edit Bug 28337: Add System-control-number index to Zebra MARC21 files To test: 1 - Apply patch 2 - Copy zebra files to destination: cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml /etc/koha/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl /etc/koha/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl 3 - Reindex authorities 4 - Edit an authority and add 035$aExpialodocious 5 - Export the authority 6 - Create a new record matchign rule: Matching rule code: OCN Description: Other control number Match threshhold: 1000 Record type: Authority record Search-index: Other-control-number Score: 1000 Tag: 035 Subfields: a 7 - Stage the record and use the new matchign rule 8 - Match found! Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au, | |fridolin.somers@biblibre.co | |m --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Nick, sorry, I might have confused myself a bit here: In ccl.properties we now have doubled up lines Other-control-number It looks like there is only one file for both bibliographic and authority indexes? I am not sure about the consequences of this. We now have:
From before (bibliogrpahic): #Other-control-number 1211 Other control number MARC21 035 Other-control-number 1=1211
New (auhority): Other-control-number 1=Other-control-number I wonder if these line will be in conflict - we have different use attributes for bibliographic and authority. But only the attribute 1211 is even mentioned in the file, 9052 is not. Can index names not overlap or should we start using the same attribute for both? Can you help unravel? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 --- Comment #6 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 124240 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=124240&action=edit Bug 28337: Use existing definition in ccl.properties and bib1.att As the field is already dfined, we don't need to add anything here. Bib1.att can use the existing number as well To test, enable zebra debugging in koha-conf, adding 'request' to the list: <zebra_loglevels>none,fatal,warn,request</zebra_loglevels> Restart all the things Repeat matching (redo matching with no rule, then with OCN rule) Tail the zebra-output.log and note 1=Ohter-control-number is searched and match is found Perform a search in the staff client for: other-control-number:expialodocious Note in logs that 1=1211 is searched Previous test plan did not mention copying ccl.properties and bib1.att to the package install, so highlighted that things work without these changes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #124240|0 |1 is obsolete| | --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 126024 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=126024&action=edit Bug 28337: Use existing definition in ccl.properties and bib1.att As the field is already dfined, we don't need to add anything here. Bib1.att can use the existing number as well To test, enable zebra debugging in koha-conf, adding 'request' to the list: <zebra_loglevels>none,fatal,warn,request</zebra_loglevels> Restart all the things Repeat matching (redo matching with no rule, then with OCN rule) Tail the zebra-output.log and note 1=Ohter-control-number is searched and match is found Perform a search in the staff client for: other-control-number:expialodocious Note in logs that 1=1211 is searched Previous test plan did not mention copying ccl.properties and bib1.att to the package install, so highlighted that things work without these changes Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #123184|0 |1 is obsolete| | --- Comment #8 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 126025 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=126025&action=edit Bug 28337: Add System-control-number index to Zebra MARC21 files To test: 1 - Apply patch 2 - Copy zebra files to destination: cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml /etc/koha/zebradb/marc_defs/marc21/authorities/authority-koha-indexdefs.xml cp /kohadevbox/koha/etc/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl /etc/koha/zebradb/marc_defs/marc21/authorities/authority-zebra-indexdefs.xsl 3 - Reindex authorities 4 - Edit an authority and add 035$aExpialodocious 5 - Export the authority 6 - Create a new record matchign rule: Matching rule code: OCN Description: Other control number Match threshhold: 1000 Record type: Authority record Search-index: Other-control-number Score: 1000 Tag: 035 Subfields: a 7 - Stage the record and use the new matchign rule 8 - Match found! Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #126024|0 |1 is obsolete| | --- Comment #9 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 126026 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=126026&action=edit Bug 28337: Use existing definition in ccl.properties and bib1.att As the field is already dfined, we don't need to add anything here. Bib1.att can use the existing number as well To test, enable zebra debugging in koha-conf, adding 'request' to the list: <zebra_loglevels>none,fatal,warn,request</zebra_loglevels> Restart all the things Repeat matching (redo matching with no rule, then with OCN rule) Tail the zebra-output.log and note 1=Ohter-control-number is searched and match is found Perform a search in the staff client for: other-control-number:expialodocious Note in logs that 1=1211 is searched Previous test plan did not mention copying ccl.properties and bib1.att to the package install, so highlighted that things work without these changes Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to master Version(s)| |21.11.00 released in| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 --- Comment #10 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Pushed to master for 21.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 --- Comment #11 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- *** Bug 12736 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|Pushed to master |RESOLVED CC| |kyle@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28337 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add System-control-number |Add other-control-number |index for authorities to |index for authorities to |MARC21 indexes |MARC21 indexes -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org