[Bug 21469] New: Add useControlNumberIdentifier preference to allow (003)001 constructions in $w links.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Bug ID: 21469 Summary: Add useControlNumberIdentifier preference to allow (003)001 constructions in $w links. Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl Whilst working through bug 11175 I was reminded of our inconsistent use of useControlNumber and it's lack of accounting for 003 fields. -- 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=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=11175 -- 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=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- URL| |https://wiki.koha-community | |.org/wiki/Multipart_Bibliog | |raphics -- 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=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add |Account for 'MarcOrgCode' |useControlNumberIdentifier |preference in 'Enhanced |preference to allow |Analytics Workflow' |(003)001 constructions in | |$w links. | -- 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=21469 --- Comment #1 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- With the introduction of the ability to search using 003 as part of the query for analytics, we should account for this in the cataloguing workflow. We should check for the presence of 'MarcOrgCode' being defined (at library or system level) and if it is being used we should copy the value of the 003 of the parent record into the constructed 773. -- 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=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |martin.renvoize@ptfs-europe |ity.org |.com -- 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=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=27507 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |28823 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28823 [Bug 28823] Set LDR position 7 correctly for serial analytics using ''Enhanced Analytics Workflow' -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|28823 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28823 [Bug 28823] Set LDR position 7 correctly for serial analytics using ''Enhanced Analytics Workflow' -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=15851 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=28823 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |11175 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- This makes sense, but I think we need a depends on for the bug adding the 003 index? Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11175 [Bug 11175] Show the parent record's component parts in the detailed views -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |27507 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27507 [Bug 27507] Search host record using control number identifier / organization code -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|27507 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27507 [Bug 27507] Search host record using control number identifier / organization code -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|11175 |28830 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11175 [Bug 11175] Show the parent record's component parts in the detailed views https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28830 [Bug 28830] Add CNI (Control Number Identifier) search index -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #3 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Created attachment 124426 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=124426&action=edit Bug 21469: Add 003 into 773$w when required This patch looks at the MarcOrgCode preference and if present it will prepend the host 003 data in brackets to the 773$w link field in the child record. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #124426|0 |1 is obsolete| | --- Comment #4 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Created attachment 124427 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=124427&action=edit Bug 21469: Add 003 into 773$w when required This patch looks at the MarcOrgCode preference and if present it will prepend the host 003 data in brackets to the 773$w link field in the child record. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #5 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- I'd love your help with writing a test plan for this Katrin.. I think it should work as expected, but I'm not even actually sure if we need to bind it on the presence of MARCOrgCodes being defined.. we might actually be OK just always prepending 003 if/when it's present in the host record. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |joonas.kylmala@iki.fi -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nugged@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Bug 21469 depends on bug 28830, which changed state. Bug 28830 Summary: Add CNI (Control Number Identifier) search index (MARC21) https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28830 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=30793 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Phil Ringnalda <phil@chetcolibrary.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |phil@chetcolibrary.org Status|Needs Signoff |Patch doesn't apply -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #124427|0 |1 is obsolete| | --- Comment #6 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Created attachment 168272 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=168272&action=edit Bug 21469: Add 003 into 773$w when required This patch looks at the MarcOrgCode preference and if present it will prepend the host 003 data in brackets to the 773$w link field in the child record. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Patch doesn't apply |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |michaela.sieber@kit.edu -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Is this to add the MARCOrgCode to 773 when using the "Add analytics" button in the cataloguing editor? Sorry, slightly confused right now again by our analytics :) Not related to this, but wondering from looking at the patch: Shouldn't the 11 here not be 111? if ( $field = $host->field('100') || $host->field('110') || $host->field('11') ) { -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #8 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Haha, that 11 instead of 111 may well have been you in bug 6831. I didn't change it here. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #9 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- This is around the 'UseControlNumber' and 'Enhanced workflow' stuff. It's all related to the work we were doing around the time in 2018 and 2021 to try and clarify and improve the 003 + 001 MARC linking stuff. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #10 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I just couldn't wrap my mind around it first time, I will try again a little later. Thanks for the patch! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #11 from Martin Renvoize (ashimema) <martin.renvoize@ptfs-europe.com> --- Another 5 months on... -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Heather <flyingendpaper@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |flyingendpaper@gmail.com --- Comment #12 from Heather <flyingendpaper@gmail.com> --- I just found out about this bug thanks to ashimema on Mattermost!! It's great! I think this bug should refer to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34482 , " Improve MARC21 7xx linking fields in bibliographic records [Omnibus]." And the formatting could be corrected, c.f. the correctly formatted examples in the MARC21 format for the 773 field, https://www.loc.gov/marc/bibliographic/bd773.html So rather than prepending the data from the 003 in brackets, it should be in parentheses. And depending on the source code in the 003, there are differences, e.g.: OCLC records (yes, tons of libraries don't use OCLC, but as the largest source of bibliographic records in the world, there are a lot of OCLC records out there!): A child record such as this one: https://keys.bywatersolutions.com/cgi-bin/koha/opac-MARCdetail.pl?biblionumb... Generated from a parent record such as this one: https://keys.bywatersolutions.com/cgi-bin/koha/opac-MARCdetail.pl?biblionumb... Needs the alphabetic characters preceeding the OCLC number in from the 001 field stripped if they are present. More information on OCLC number formatting in 001 fields over time is here: https://help.oclc.org/Metadata_Services/WorldShare_Collection_Manager/Data_s... DLC records would need spacing respected (corrected?), c.f. the examples in the MARC21 format. I would like to be able to sign off on this bug when it's ready, but I'm not really seeing a test plan yet--are y'all still working on it, ashimema & Katrin? Tx! h2 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Laura Escamilla <Laura.escamilla@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA CC| |Laura.escamilla@bywatersolu | |tions.com --- Comment #13 from Laura Escamilla <Laura.escamilla@bywatersolutions.com> --- Please add a test plan! Moving this one over to Failed QA for now. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |34482 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34482 [Bug 34482] Improve MARC21 7xx linking fields in bibliographic records [Omnibus] -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=39545 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #14 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- The test plan is really just about reading the code and agreeing to the construction of the 773$w subfield from the parent record based on the preferences passed. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff --- Comment #15 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Test plan 1) Set UseControlNumber system preference 2) Ensure you have set both 001 and 003 on a host record 3) Attempt to add a child record via 'New > New Child Record' 4) Navigate to the 7xx tab on the resulting catalog editor and confirm the 773$w looks as you would expect given the host records 001 and 003 content. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 --- Comment #16 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Worth noting, bug 39545 also adds 003 handling in it's mix of additions (without explicitly mentioning it as part of the scope there). It does not however, take account of the MarcOrgCode preference and instead opts to always add 003 content if present in the parent record.. The approach here will NOT add prepend 003 to the 001 if the MarcOrgCode preference is not set (at either global or library level) -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Lin Wei <lin-wei.li@inLibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lin-wei.li@inLibro.com See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=37061 Status|Needs Signoff |Failed QA --- Comment #17 from Lin Wei <lin-wei.li@inLibro.com> --- # Test Execution 1. Apply patch. 2. Apache server crashes with error 500. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Lin Wei <lin-wei.li@inLibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff --- Comment #18 from Lin Wei <lin-wei.li@inLibro.com> --- # Test Results I could not get this to work. # Test Execution 1. Apply patch. 2. Apache crashes for both OPAC and Intranet: 500 Internal Server Error. See [Logs] below. # Additional Notes - I am keeping the status as "Needs Signoff." - This patch might be a duplicate of Bug 37061. # Logs [...] Fri May 09 15:15:45.927753 2025] [cgid:error] [pid 53913] [client 127.0.0.1:55214] End of script output before headers: opac-search.pl, referer: http://master/cgi-bin/koha/opac-readingrecord.pl [Fri May 09 15:15:46.752727 2025] [cgid:error] [pid 53913] [client 127.0.0.1:55214] End of script output before headers: 500.pl, referer: http://master/cgi-bin/koha/opac-readingrecord.pl [Mon May 12 13:55:23.963501 2025] [cgid:error] [pid 43434] [client 127.0.0.1:54222] End of script output before headers: opac-main.pl, referer: http://master/cgi-bin/koha/opac-user.pl [Mon May 12 13:55:24.608587 2025] [cgid:error] [pid 43434] [client 127.0.0.1:54222] End of script output before headers: 500.pl, referer: http://master/cgi-bin/koha/opac-user.pl [Mon May 12 13:55:25.269379 2025] [cgid:error] [pid 43437] [client 127.0.0.1:54232] End of script output before headers: 404.pl, referer: http://master/cgi-bin/koha/opac-main.pl -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21469 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |RESOLVED Resolution|--- |DUPLICATE --- Comment #19 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- *** This bug has been marked as a duplicate of bug 39545 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org