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

Tue Nov 29 09:40:49 NZDT 2016

We had to create our authority files from scratch.  It was done by sucking
the data out of the relevant fields, deduplicating, standardizing,
correcting a lot of records (I was impressed with the number of different
ways A. L. Lloyd's name was used in our databases), etc. and then creating
a set of MARC authority records from the final list. The authority files
were uploaded into Koha first and then the biblio records. In that case the
link bibs to authorities works just fine.

In answer to Paul's question - "But I'm at a loss to understand how you can
"save" a biblio without the 650 creating its own (proper or
duplicate/erroneous) RLIN."
That depends on your system settings.  We started out with it set to
automatically create/link authorities when saving records, and this
resulted in erroneous duplicates that were a bother to weed out.  So now,
if the cataloguer doesn't chose to link to an authority, it won't link to
one or create on its own.

On Mon, Nov 21, 2016 at 10:09 PM, Craig Butosi <craig.butosi at rcmusic.ca>
wrote:

> 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.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>

-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)