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:[email protected]] On Behalf Of Katrin
Sent: November-21-16 3:45 PM
To: [email protected]
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 [email protected]
> https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org [email protected]
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
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
