[Koha] Linking subject authority records to 650 via MarcEdit?
Paul A
paul.a at navalmarinearchive.com
Wed Nov 9 10:00:13 NZDT 2016
At 08:26 PM 11/8/2016 +0000, 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.
Question: how were your biblio records created? Manually? Z39.50? or some
sort of other "import"?
We have experienced, over the years, a few problems, but intrinsically can
see a "9 (RLIN)" for every 650 entry. The biggest problem is that if -- for
whatever reason, accident, stupidity, IT -- you have *two* authorities,
same text, different RLIN, and the cataloguer doesn't do a "search, choose"
for a 650, then you get yet *another* RLIN adding up to eventually hundreds
of non-cross-referenced but identical "authorities." If there's only one,
single RLIN, then Koha finds it, uses it, perfection...
I'm fairly certain that most of our "duplicate RLINs" were my fault when I
migrated ($deity forbid) Excel flat files through the 2010 version of
MarcEdit. I was wet behind the ears, knew nothing, and in a hurry -- it's
been biting me ever since ;={ And there's no (apparent) simple manner to
sort it out, except go manually through every authority...
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.
Disclaimer: Koha 3.8.24 from tarball.
Best -- Paul
>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
---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>
More information about the Koha
mailing list