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:bgkrie...@gmail.com>bgkrie...@gmail.com
On Sun, Sep 15, 2013 at 12:53 PM, Paul
<<mailto:pau...@aandc.org>pau...@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@lists.koha-community.org>Koha-devel@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>
_______________________________________________
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/
