[Koha-devel] 6xx fields with no RLIN

[Bernardo Gonzalez Kriegel]

Paul,

if what you are trying to do is link biblios to authorities,
you could use misc/link_bibs_to_authorities.pl script.

First try with misc/link_bibs_to_authorities.pl -v -l -test
to do a test, then without -test.

Don't forget to reindex.

Regards,
Bernardo


-- 
Bernardo Gonzalez Kriegel
bgkriegel at gmail.com


On Sun, Sep 15, 2013 at 12:53 PM, Paul <paul.a at aandc.org> wrote:

> We have found (much too late!), several thousand instances of 6xx
> Authority fields with valid $a but missing the $9 (RLIN); I would sincerely
> appreciate assistance in correcting this.
>
> The $a fields are very repetitive, only about twenty in total; to do this
> "by hand" in the staff interface is "easy" but would be nearly three weeks
> work at say one minute per record.
>
> To do this (obviously starting in the sandbox) by manipulating the MySQL
> db (biblioitems.marc and biblioitems.marcxml might be the way to go, but I
> have no experience UPDATEing into longblobs and longtexts.
>
> So, (a) is there an easier way?  Or (b) Has anyone got a pre-built MySQL
> script for UPDATEing into long blobs and text?
>
> Many thanks for any suggestions.
>
> Best - Paul
>
> P.S.  I've tried along the lines of:
> UPDATE biblioitems (marc, '//datafield[@tag="650"]/**subfield[@code="9"]')
> = 12345
> WHERE(marc, '//datafield[@tag="650"]/**subfield[@code="a"]') = 'Authority
> in question'
> AND (marc, '//datafield[@tag="650"]/**subfield[@code="9"]') IS NULL;
>
> but UPDATE seems to fail for marc and marcxml (longtext and longblob), and
> of course INSERT will not take a WHERE argument. I can't find the field
> structures in SchemaSpy -- but even with them, I'm not certain that I'm on
> the right track.
>
> ______________________________**_________________
> Koha-devel mailing list
> Koha-devel at lists.koha-**community.org<Koha-devel at lists.koha-community.org>
> http://lists.koha-community.**org/cgi-bin/mailman/listinfo/**koha-devel<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/ <http://bugs.koha-community.org/>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130915/1a684b77/attachment.html>