[Koha-devel] 6xx fields with no RLIN

[Paul]

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/<http://link_bibs_to_authorities.pl>link_bibs_to_authorities.pl script.
>
>First try with 
>misc/<http://link_bibs_to_authorities.pl>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
><mailto:bgkriegel at gmail.com>bgkriegel at gmail.com
>
>
>On Sun, Sep 15, 2013 at 12:53 PM, Paul 
><<mailto:paul.a at aandc.org>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
><mailto: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
>website : <http://www.koha-community.org/>http://www.koha-community.org/
>git : <http://git.koha-community.org/>http://git.koha-community.org/
>bugs : <http://bugs.koha-community.org/>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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130915/14642f37/attachment-0001.html>