http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 --- Comment #1 from Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> --- Created attachment 16174 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=16174&action=edit Bug 9826 - Missing fields in MARC21 authority framework This patch updates MARC21 authority framework adding missing tags/subtags up to Update No. 15 (September 2012) Missing tags and corresponding subtags only added to default authority framework. For present authtypes only missing subtags are added. Also updates a few legends to match those from LOC. No deletions except for a few not relevant tags in present authtypes without subfields. Only to new installs. To test: 1) Delete present authority frameworks 2) Load new frameworks. On default there are many new tags/subtags. On present authtypes only a few new/renamed subtags. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |String patch -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #2 from David Cook <dcook@prosentient.com.au> --- (In reply to comment #1)

Created attachment 16174 [details] [review] Bug 9826 - Missing fields in MARC21 authority framework

This patch updates MARC21 authority framework adding missing tags/subtags up to Update No. 15 (September 2012)

Missing tags and corresponding subtags only added to default authority framework.

For present authtypes only missing subtags are added.

Also updates a few legends to match those from LOC.

No deletions except for a few not relevant tags in present authtypes without subfields.

Only to new installs.

To test: 1) Delete present authority frameworks 2) Load new frameworks. On default there are many new tags/subtags. On present authtypes only a few new/renamed subtags.

Could you give some more detailed instructions on how to go about deleting and loading authority frameworks? Am I clearing out "auth_types", "auth_tag_structure" and "auth_subfield_structure" and then running ".../marc21/mandatory/authorities_normal_marc21.sql"? Also, what are some new tags/subtags that I should be looking for? -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 --- Comment #4 from David Cook <dcook@prosentient.com.au> --- (In reply to comment #3)

This patch only touch 'default' framework, perhaps I can do another bug that updates example frameworks. For bib frameworks there are 2 files, for auth there is only one.

To delete present auth framework:

mysql -ukohauser -pkohapass kohadb -e "delete from auth_subfield_structure; delete from auth_tag_structure; delete from auth_types;"

To add the new ones:

mysql -ukohauser -pkohapass kohadb < $PATH/authorities_normal_marc21.sql

What's new: Look in diff view, http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=16174&action=diff

All green is new + subtags for 368~384 All lightBlue is modification

Thanks for the additional info, Bernardo! Where did you get the list of tags to add? I know it would involve more work, but would you be able to add the appropriate tags to the other frameworks as well, since they're included in this same SQL file and you already know which tags need to be added overall? -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off CC| |mtj@kohaaloha.com -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gmcharlt@gmail.com --- Comment #8 from Galen Charlton <gmcharlt@gmail.com> --- (In reply to comment #4)

I know it would involve more work, but would you be able to add the appropriate tags to the other frameworks as well, since they're included in this same SQL file and you already know which tags need to be added overall?

I think this would be a good idea. The non-default authority frameworks, at least for MARC21, are special in that they correspond to authtypecode. I think it would be unusual for catalogers to use the default authority framework unless they're creating subdivision records; more common would be to immediately start with the framework corresponding to the type of authority record they want to create. I think there might be a way to restructure the installer SQL so that the non-default frameworks are created by copying the default framework, then applying the necessary tweaks. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master --- Comment #9 from Galen Charlton <gmcharlt@gmail.com> --- I've pushed this patch to master. Thanks, Bernardo! I've also created bug 10488 for necessary follow-ups to this work. -- You are receiving this mail because: You are watching all bug changes.

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9826 --- Comment #11 from Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> --- Pushed to 3.10.x, will be in 3.10.8 -- You are receiving this mail because: You are watching all bug changes.