Re: [Koha-devel] 6xx fields with no RLIN
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@gmail.com>bgkriegel@gmail.com
On Sun, Sep 15, 2013 at 12:53 PM, Paul <<mailto:paul.a@aandc.org>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 <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>
Paul, documentation of that script is a little bit sparse, so I really don't know. Another tool you could try is koha-auth from http://search.cpan.org/dist/Koha-Contrib-Tamil/ (install using: cpan -i MARC::Moose Koha::Contrib::Tamil) Write a configuration file auth.conf, for example for 650 <-> TOPIC_TERM BEGIN --- authcode: TOPIC_TERM authtag: 150 authletters: a bibliotags: - 650 END only the text between BEGIN..END Then run koha-auth link_biblio_to auth.conf that will show you what can be done, or koha-auth link_biblio_to --doit auth.conf to do it. But no tool is completely reliable. Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkriegel@gmail.com On Sun, Sep 15, 2013 at 2:42 PM, Paul <paul.a@aandc.org> wrote:
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 <http://navalmarinearchive.com/>> and < http://UltraMarine.ca <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/
participants (2)
-
Bernardo Gonzalez Kriegel -
Paul