At 01:14 PM 9/15/2013 -0300, Bernardo Gonzalez Kriegel wrote:

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.

Many thanks Bernardo,

It will take a fair amount of "double checking" (and I'm short of cataloguers over the week-end), but it's certainly doing something in the sandbox. But what does "fuzzily linked" mean, please?

Running a "SELECT ... WHERE length(650$a) != 0 and length(650$9)= 0 gives me:
5210 rows in set (1.06 sec) so ~5000 auths without RLINs (they're all 650s as far as I can tell, no 610s etc)

and perl ./usr/share/koha/bin/link_bibs_to_authorities.pl -v -l -test gives me a summary:

Bib authority heading linking report
=======================================================
Linker module:                          C4::Linker::Default
Run started at:                         09/15/13 17:25:22
Run ended at:                           09/15/13 17:29:22
Total run time:                         239255 ms
Number of bibs checked:                 31163
Number of bibs modified:                0
Number of bibs with errors:             0
Number of headings linked:              48310
Number of headings unlinked:            0
Number of headings fuzzily linked:      27818

**** Ran in test mode only ****

Many thanks - Paul

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

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/

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>