[Koha-devel] SQL statements for RDA (MARC21)

[Stefano Bargioni]

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 at 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 at lists.koha-community.org [mailto:koha-devel-
>> bounces at lists.koha-community.org] On Behalf Of Stefano Bargioni
>> Sent: Thursday, 9 April 2015 8:13 PM
>> To: koha-devel at 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 at 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/
> 
> 
>