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 [email protected] From: Open-ils-general [mailto:[email protected]] 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 [email protected] www.georgialibraries.org www.georgialibraries.org/pines
