Hi, David: you are right: this is an activity, not simply a patch. More, introducing RDA in Koha is a project... Anyway, let's speak about tags and subfields, leaving other tasks, like authorized values and plugins, to the future. We at PUSC can prepare a set of INSERT and UPDATE sql statements for both auth and bib existing frameworks. Note that we will use INSERT IGNORE to avoid duplication of tags or subfields. If I'm not wrong this will ensure the persistence of any existing modification. On 10/apr/2015, at 03:19, David Cook <dcook@prosentient.com.au> wrote:
Hey Stefano:
I think this activity can be really hit or miss. While RDA has spurred many of us to update our frameworks, there have actually been a lot of other changes to MARC that have happened over the past few decades, which might not be as obvious or well described.
Honestly, I'd suggest downloading the latest marc21_framework_DEFAULT.sql from the master branch, deleting the default framework in the database, and then repopulating using marc21_framework_DEFAULT.sql as it should be the most up-to-date framework available.
I wrote a tool a while ago that would update other frameworks off of this master default framework, but... I haven't maintained it as there wasn't much call for updated frameworks.
Running marc21_framework_DEFAULT.sql overtop of an existing default framework is OK in that it will add any missing fields and subfields, but it won't make changes to existing fields/subfields.
David Cook Systems Librarian Prosentient Systems 72/330 Wattle St, Ultimo, NSW 2007
-----Original Message----- From: koha-devel-bounces@lists.koha-community.org [mailto:koha-devel- bounces@lists.koha-community.org] On Behalf Of Stefano Bargioni Sent: Thursday, 9 April 2015 8:13 PM To: koha-devel@lists.koha-community.org Subject: [Koha-devel] SQL statements for RDA (MARC21)
Hi, I'm writing SQL statements for adding RDA tags and subfields to frameworks, both auth and bib. Did somebody do the same, or something similar? Is it useful for [1]? Some important caveats? I'm following [2], with suggestions of PUSC cataloguers. Thank you. Stefano
[1] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10344 [2] http://www.itsmarc.com/crs/mergedprojects/helpauth/helpauth/contents. htm _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha- community.org/ bugs : http://bugs.koha-community.org/