[Koha] Linking subject authority records to 650 via MarcEdit?

Tue Nov 22 11:09:31 NZDT 2016

Hi Katrin,

Thanks for responding. I have looked at the script, but -- and please correct me if I am wrong -- it looks like it requires an extant, populated authorities database from which to link bib records prior to running. Our problem here is that we do not have an auth db sufficiently populated. We migrated from our legacy system with no authority db. :( With Koha, we now have to manually populate our authorities db from scratch. We're up to about 350 authority files at present. A long way go. In an ideal world, I'd love to just dump the entire LC Name Authority file into our instance if I could, run the script, and delete authorities that remain unused, but I don't think that can be done at present. So, the misc/link_bibs_to_authorities.pl script will not work for us.

Hence the inspiration for the MarcEdit method, a sort of middle-of-the-road automation solution to link authorities to bibs. With it, we can  link extant bibs as we add authorities, making it part of cataloguing workflow when necessary.

-
As a side note: this MarcEdit method does work; however, we are running into very weird character encoding issues when working from within Marc Edit - this is most likely independent of authority linking and probably with the data we imported into Koha during migration (which I thought was UTF-8 - apparently not). Embarrassingly, I did not catch this in time, and now some of our records have rather unfortunate character encoding anomalies - but at least they all linked to their respective authority!

A word of caution: If one imports a bib record into MarcEdit which is already linked to an authority ($9), the record will include additional instances of the controlled variable field  linked to the auth db (1xx/7xx for names, 6xx for subjects, etc.). These additional fields are coming right from the authority record. For instance, in the MarcEdit editor, record 28577 is:

=LDR  01004nam a2200277Ia 4500
=001  39174
=003  OTRCM
=005  20161121110746.0
=008  160713s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=028  32$aG. H. 2971 G. Hug
=035  \\$aOTRCM
=040  \\$cOTRCM
=050  \4$aM221 .S48 B6 1900
=100  1\$9398$aŠevčík, O.$q(Otakar),$d1852-1934
=240  10$aBöhmische Tänze und Weisen. Selections
=245  10$aBöhmische Tänze und Weisen, op. 10 :$bfür Violine mit begleiung des Pianoforte /$cO. Sevcik.
=260  \\$aLeipzig :$bG. Hug,$c[19--].
=300  \\$a1 score (15 p.) + 1 part (7 p.) ;$c32 cm.
=650  \0$aViolin and piano music$xScores and parts.
=942  \\$cPM$2lcc
=999  \\$c28577$d28577
=952  \\$00$10$2lcc$40$6M0221 S48 B6  01900$70$8IM2$930318$aREL$bREL$cREL$d2007-12-15$oM221 .S48 B6 1900$p33175000152151$r2007-12-15$w2016-07-13$yPM
=100  z\$wnna$aŠevčík, Otakar Josef,$d1852-1934
=100  z\$aŠevčík, Ottakar,$d1852-1934

The last two fields after Field 952  which have Subfield Indicator 1 set to "z" are actually coming from the auth file. If you upload this record back into Koha without removing these two fields, they will display as additional 100s in staff/opac display! Yikes. However, a simple regex-based delete takes care of this before re-upload though (i.e., =\d{3}\s\sz.* )

All best,

Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICES MANAGER
THE ROYAL CONSERVATORY
TELUS Centre for Performance and Learning
273 Bloor Street West
Toronto, ON M5S 1W2
416.408.2824 x338
www.rcmusic.ca

-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Katrin
Sent: November-21-16 3:45 PM
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Linking subject authority records to 650 via MarcEdit?

Hi Craig,

have you experimented with the misc/link_bibs_to_authorities.pl script for linking the bibliographic records with the authorities?

That said, what you want to do should work. We are importing 'prelinked'
bibliographic records with the auth_header.authid in $9 regularly.

Hope this helps,

Katrin

On 08.11.2016 21:26, Craig Butosi wrote:
> Hi Brain Trust,
>
> Koha 16.05.03 on Ubuntu 14.04 (package install)
>
> I am seeking advice for the following:
>
> Problem: 650 field text in bib records are not linked to Koha authorities database (via $9), but the text itself has been validated against LCSH (using OpenRefine). In other words, the text is in its authorized form, just not linked to its auth record.
>
> Solution: Link 650 field data with its extant authority using MarcEdit
>
> Process:
>
>
> 1.       Run a Koha report to extract biblionumbers from records based on some Subject  (i.e., "Symphonies")
>
> 2.       Import these records from Koha into MarcEdit using the batch search function on "Record Number" (upload a plain-text file with biblionumbers only)
>
> 3.       Check that 650 data is in its authorized form.
>
> 4.       Append a $9 subfield with the appropriate RLIN number to the batch (i.e., 650  //$aSymphonies --> 650  //$aSymphonies $917)
>
> 5.       Upload batch back into Koha db.
>
> Questions:
>
>
> 1.       Have any of you linked authority records to controlled variable fields using this method?
>
> 2.       Is there anything I am missing?
>
> 3.       Is this an utterly dangerous and careless way to be linking controlled fields to the Koha authorities db?
>
> Thank you!
>
> C
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> the royal conservatory
> TELUS Centre for Performance and Learning
> 273 Bloor Street West
> Toronto, ON M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca<http://www.rcmusic.ca/>
>
>
>
> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.
> _______________________________________________
> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.