[Bug 34693] New: Add 035$a as Other-control-number index in authorities search indexes
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 Bug ID: 34693 Summary: Add 035$a as Other-control-number index in authorities search indexes Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs@lists.koha-community.org Reporter: caroline.cyr-la-rose@inlibro.com The only "number" that is indexed in authority records is 001, which is Koha's auth_id. This makes it difficult to add matching rules to import new records since Koha replaces the record's actual control number with its own. I propose to add 035$a as Other-control-number index for authority records. This would help do matching checks when importing authority records. -- 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=34693 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- 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=34693 --- Comment #1 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Created attachment 155152 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=155152&action=edit Bug 34693: Add 035$a as Other-control-number index in default authorities search indexes This patch adds a new index for authorities, Other-control-number, and maps it to 035$a. This will help when trying to match authority records when importing external records. Test 1: 0. Make sure Elasticsearch is set as the search engine 1. Apply patch and restart 2. Import the attached record 2.1. Go to Cataloging > Stage records for import 2.2. Choose the file 2.3. Click Upload file 2.4. Choose Record type: Authority 2.5. Click Stage for import (wait until the job is finished...) 2.6. Click View batch 2.7. Click Import this batch into the catalog (wait until the job is finished...) 2.8. Click Manage imported batch 2.9. Click View next to the record 2.10. Note the auth id number 3. Examine the ES entry for the record (replace INDEX_NAME with the index name (found in koha-conf.xml and XX with the auth_id) curl -XGET 'http://localhost:9200/INDEX_NAME_authorities/data/XX?_source_includes=other-control-number&pretty' --> It should give you the value of 035$a Test 2 (optional): 1. Steps 1 and 2 as above 2. Add a matching rule to match on 035$a for authority records 2.1. Go to Administration > Record matching rules 2.2. Click New record matching rule 2.3. Fill out the form - Matching rule code: enter a code (for example AUTCONTROL) - Description: enter a description (for example 035$a for authorities) - Match threshold: 100 - Record type: Authority record - Search index: Other-control-number - Score: 100 - Tag: 035 - Subfields: a 2.4. Click Save 3. Import the same record again, checking for matches using the new rule 3.1. Go to Cataloging > Stage records for import 3.2. Choose the file 3.3. Click Upload file 3.4. Choose Record type: Authority 3.5. Choose Record matching rule: rule created above 2.6. Click Stage for import (wait until the job is finished...) --> It should say that 1 record was found using the rule -- 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=34693 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |caroline.cyr-la-rose@inlibr |ity.org |o.com Text to go in the| |This patch adds 035$a in release notes| |the default MARC21 | |Elasticsearch authority | |indexes. | | | |For existing | |installations, make sure | |you reindex with the option | |-r (reset mappings) to have | |this information in the | |index for existing records. --- Comment #2 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- I wrote in the release notes that for existing installations, we have to reset mappings. I'm sure it's true for existing records, but I'm not sure for records added after the upgrade. If the mappings are not reset, I'm not sure what it does. Does the new mapping just stay in limbo? -- 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=34693 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add 035$a as |Add 035$a as |Other-control-number index |Other-control-number index |in authorities search |in authorities search |indexes |indexes (MARC21, | |Elasticsearch) -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |philippe.blouin@inlibro.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 Lucas Gass <lucas@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=34693 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #155152|0 |1 is obsolete| | --- Comment #3 from Lucas Gass <lucas@bywatersolutions.com> --- Created attachment 162795 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=162795&action=edit Bug 34693: Add 035$a as Other-control-number index in default authorities search indexes This patch adds a new index for authorities, Other-control-number, and maps it to 035$a. This will help when trying to match authority records when importing external records. Test 1: 0. Make sure Elasticsearch is set as the search engine 1. Apply patch and restart 2. Import the attached record 2.1. Go to Cataloging > Stage records for import 2.2. Choose the file 2.3. Click Upload file 2.4. Choose Record type: Authority 2.5. Click Stage for import (wait until the job is finished...) 2.6. Click View batch 2.7. Click Import this batch into the catalog (wait until the job is finished...) 2.8. Click Manage imported batch 2.9. Click View next to the record 2.10. Note the auth id number 3. Examine the ES entry for the record (replace INDEX_NAME with the index name (found in koha-conf.xml and XX with the auth_id) curl -XGET 'http://localhost:9200/INDEX_NAME_authorities/data/XX?_source_includes=other-control-number&pretty' --> It should give you the value of 035$a Test 2 (optional): 1. Steps 1 and 2 as above 2. Add a matching rule to match on 035$a for authority records 2.1. Go to Administration > Record matching rules 2.2. Click New record matching rule 2.3. Fill out the form - Matching rule code: enter a code (for example AUTCONTROL) - Description: enter a description (for example 035$a for authorities) - Match threshold: 100 - Record type: Authority record - Search index: Other-control-number - Score: 100 - Tag: 035 - Subfields: a 2.4. Click Save 3. Import the same record again, checking for matches using the new rule 3.1. Go to Cataloging > Stage records for import 3.2. Choose the file 3.3. Click Upload file 3.4. Choose Record type: Authority 3.5. Choose Record matching rule: rule created above 2.6. Click Stage for import (wait until the job is finished...) --> It should say that 1 record was found using the rule Signed-off-by: Lucas Gass <lucas@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Grabbing this simple one out of the QA queue. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 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=34693 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Version(s)| |24.05.00 released in| | Status|Passed QA |Pushed to main -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Pushed for 24.05! Well done everyone, thank you! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to main |Needs documenting CC| |fridolin.somers@biblibre.co | |m --- Comment #6 from Fridolin Somers <fridolin.somers@biblibre.com> --- Not backported to 23.11.x -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34693 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Documentation| |https://gitlab.com/koha-com submission| |munity/koha-manual/-/merge_ | |requests/896 Status|Needs documenting |RESOLVED Documentation| |Caroline Cyr La Rose contact| | -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org