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@gmail.com On Sun, Sep 15, 2013 at 12:53 PM, Paul <paul.a@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@lists.koha-**community.org<Koha-devel@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/>