[Koha-devel] 6xx fields with no RLIN

[Bernardo Gonzalez Kriegel]

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 at gmail.com


On Sun, Sep 15, 2013 at 2:42 PM, Paul <paul.a at 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 at gmail.com
>
>
> On Sun, Sep 15, 2013 at 12:53 PM, Paul <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
> Koha-devel at 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 at 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130915/d6e04d51/attachment.html>