[OPEN-ILS-GENERAL] Record Match Set for Acquisitions

[Mary Llewellyn]

This works pretty well for us. Our libraries use "Match-only merge" when
they upload, so their records never replace any matching records already in
our catalog, so we never run the risk of a full OCLC record getting replaced
by a brief vendor record. If an occasional mismatch occurs and an order item
attaches to the wrong bib, it's usually not a big issue because most of our
libraries don't use EDI, opting to do the actual ordering on the vendor's
website instead. They discover it during cataloging and report it to us, and
we can move the item to the correct bib record. But so far, it's a very rare
event. 

 

Since our consortium does centralized cataloging, we provide OCLC records on
behalf of our members. I've developed a SQL query looking for bib records
with acq items that have TCNs that don't begin with the "oc" prefix. I grab
their ISBNs and run them through a batch search in OCLC's Connexion,
identify which records we want to use, and load them to our database using
the same Record Match set definition. I review the queue looking for
multiple matches, and if I find we have duplicate records, I open a record
bucket and merge the duplicates.  I also check for incorrect matches and fix
any mistakes. 

 

After the load has been run and cleaned up, I run another SQL based on the
bib IDs found in the earlier query. In this one, I have the contents of tag
001 (the OCLC number) copied to the TCN, so all the uploaded/matched records
now have TCNs with "oc" prefixes, so they won't come up again in my first
query if any other libraries add acq items to them later on. I also change
the bib source from our home-grown "vendor order record" which was applied
during the initial acquisitions load to "OCLC." It helps us to manage what
records are what. 

 

Mary

 

Mary Llewellyn

Database Manager

Bibliomation, Inc.

24 Wooster Ave.

Waterbury, CT 06708

mllewell at biblio.org

 

 

 

From: Open-ils-general
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Hardy, Elaine
Sent: Friday, June 05, 2015 3:54 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Record Match Set for Acquisitions

 

Thanks! 

 

I may have some questions for you about this after I have had a chance to
think about it..  We have much more stringent match sets 

 

Elaine

 

J. Elaine Hardy
PINES & Collaborative Projects Manager
Georgia Public Library Service
1800 Century Place, Ste 150
Atlanta, Ga. 30345-4304

 

404.235.7128
404.235.7201, fax
ehardy at georgialibraries.org
www.georgialibraries.org
www.georgialibraries.org/pines

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150608/ab820724/attachment.html>