https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=29627 -- 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=21705 --- Comment #1 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Created attachment 128186 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=128186&action=edit Bug 21705: Map copryrightdate to both 260/264c by default for new MARC21 installations This patch adds a mapping from 264 to biblio.copyrightdate. To test: 1) Apply patch 2) Delete existing frameworks - In the database delete from marc_tag_structure; delete from marc_subfield_structure; delete from biblio_framework; 3) Load default framework - In a terminal, run ./misc/load_yaml.pl -f installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml --load 4) In the staff interface, go to Administration > MARC bibliographic framework - Make sure the default framework is there 5) In Administration > Koha to MARC mapping, check the mappings for biblio.copyrightdate - biblioitems.publishercode should be mapped to 260 as well as 264 6) Create a bibliographic record with a value in 264 - In the database, check the biblio entry for this record, the value from 264 should be in copyrightdate 7) Create a bibliographic record with a value un 260 - In the database, check the biblio entry for this record, the value from 264 should be in copyrightdate I hope I didn't forget anything! :) Caroline -- 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=21705 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |caroline.cyr-la-rose@inlibr |ity.org |o.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=21705 --- Comment #4 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Hi David, I think you were misled by my test plan. I copy-pasted from another one and forgot to change everything I should have... I'm rewriting the test plan and hopefully I won't make any more mistakes... Caroline -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #128186|0 |1 is obsolete| | --- Comment #5 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Created attachment 141394 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=141394&action=edit Bug 21705: Map copryrightdate to both 260/264c by default for new MARC21 installations This patch adds a mapping from 264 to biblio.copyrightdate. To test: 1. Apply patch 2. Delete existing frameworks 2.1. In the database, run the following commands delete from marc_tag_structure; delete from marc_subfield_structure; delete from biblio_framework; 3. Load default framework 3.1. In a terminal, run ./misc/load_yaml.pl -f installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml --load 4. In the staff interface, go to Administration > MARC bibliographic framework --> The default framework should be there 5. Make 264c appear in the editor 5.1. In Administration > MARC bibliographic framework, click on Actions > MARC structure next to the default framework 5.2. Search for 264 5.3. Click on Actions > Edit subfields 5.4. Click on tab c 5.5. Check the 'Editor' box 5.6. Click 'Save changes' 6. In Administration > Koha to MARC mapping, check the mappings for biblio.copyrightdate 6.1. Go to Administration > Koha to MARC mapping 6.2. Search for copyrightdate --> biblio.copyrightdate should be mapped to 260c as well as 264c 7. Create a bibliographic record with a value in 264c 7.1. Go to Cataloging 7.2. Click 'New record' 7.3. Fill in mandatory fields (000, 003, 005, 008, 040c, 245a, 942c) 7.4. Enter a date in 264c 7.5. Click 'Save' 7.6. Note the record number (no need to add an item) 8. Create a bibliographic record with a value in 260c 8.1. Go to Cataloging 8.2. Click 'New record' 8.3. Fill in mandatory fields (000, 003, 005, 008, 040c, 245a, 942c) 8.4. Enter a date in 260c 8.5. Click 'Save' 8.6. Note the record number (no need to add an item) 9. Check the database biblio entry for both records, they should both have a value for copyrightdate 9.1. In the database, enter the following query, replacing AA with your biblionumber from step 7.6 and BB with the biblionumber from 8.6 select biblionumber, copyrightdate from biblio where biblionumber in (AA, BB) --> Both biblios should have a date in copyrightdate I hope I didn't forget anything! :) Caroline -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #141394|0 |1 is obsolete| | --- Comment #6 from David Nind <david@davidnind.com> --- Created attachment 141400 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=141400&action=edit Bug 21705: Map copryrightdate to both 260/264c by default for new MARC21 installations This patch adds a mapping from 264 to biblio.copyrightdate. To test: 1) Apply patch 2) Delete existing frameworks - In the database delete from marc_tag_structure; delete from marc_subfield_structure; delete from biblio_framework; 3) Load default framework - In a terminal, run ./misc/load_yaml.pl -f installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml --load 4) In the staff interface, go to Administration > MARC bibliographic framework - Make sure the default framework is there 5) In Administration > Koha to MARC mapping, check the mappings for biblio.copyrightdate - biblioitems.publishercode should be mapped to 260 as well as 264 6) Create a bibliographic record with a value in 264 - In the database, check the biblio entry for this record, the value from 264 should be in copyrightdate 7) Create a bibliographic record with a value un 260 - In the database, check the biblio entry for this record, the value from 264 should be in copyrightdate I hope I didn't forget anything! :) Caroline Signed-off-by: David Nind <david@davidnind.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Map copryrightdate to both |Map copyrightdate to both |260/264c by default for new |260/264c by default for new |MARC21 installations |MARC21 installations -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 --- Comment #9 from David Nind <david@davidnind.com> --- (In reply to Caroline Cyr La Rose from comment #8)

Yes, that is normal, it has to do with indicators. Since 264 can be used for more than publication (it can be used for production information, manufacture information, etc.) it needs to know what you are cataloguing in there exactly. If you want 'Publication', you need to write 1 in the second indicator https://www.loc.gov/marc/bibliographic/bd264.html

Thanks Caroline! There is always something to learn with MARC21 and cataloguing... -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> 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=21705 --- Comment #11 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Please inform users of existing installations more explicitly via release notes about adding 264 too. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Text to go in the| |This enhancement adds a release notes| |default mapping from 264c | |to biblio.copyrightdate for | |MARC21. Previously, it was | |only mapped to 260c. Now it | |is mapped to both. | |**This | |only affects new | |installations. For current | |installations, you need to | |add it manually through | |Administration > Koha to | |MARC mapping. Keywords|release-notes-needed | -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 --- Comment #13 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Caroline Cyr La Rose from comment #12)

Hi Marcel, I added release notes specifying it is only for new installations and where to add it for current installations. Do you want me to also add a dbrev like in bug 30850? Thanks! Caroline

Let's see if our RM should insist.. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 --- Comment #15 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Katrin Fischer from comment #14)

Historically we haven't changed mappings on update and it's not enough anyway, as you would create an inconsistent state of the data: the mappings only work for the new records. So this could lead more to confusion than being actually helpful. If people want this, they also need to run the script to update existing data or be aware of the change. (

True, but please read the context. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Version(s)| |22.11.00 released in| | Status|Passed QA |Pushed to master -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21705 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |RESOLVED CC| |lucas@bywatersolutions.com Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.