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