So, I'll start by saying that I haven't worked with Millennium in almost 6 years, but to do the overlay protection in Millennium -- you need to have access to the III load tables. This requires special training or asking III (at cost) to create one for you. The load table can be made to match on a specific field (you could set it to ISBN though you'd need to be really sure that this is a good match -- it's not generally). The remaining parts are pretty easy. Using a tool like MARC::RECORD (perl) or PyMarc -- you could write a quick script that parses the file, and generates MARC records for you. If you don't want to script it -- you can download a tool like MarcEdit (http://marcedit.reeset.net) that has a delimited text translator that can translate excel spreadsheets into MARC.
Honestly -- if this was me and I didn't have load table training (even if I did) -- I would export the MARC records from my III system that I wanted to overlay. I would create MARC records from the Excel sheets -- then I would use a tool to merge the data between the generated records and the source records. You can again, do this via a script -- or likely with MarcEdit's Merge Records tool. Then, I would reload the records back into III using the 949 -- overlaying on the bib number. This of course overwrites the records in your catalog -- but that should be ok since you are using the records from your catalog as your source. -----Original Message----- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Stephen Grasso Sent: Wednesday, October 28, 2015 8:16 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] Marc record creation and matching Greetings all, My colleague and I want to create MARC records from a spreadsheet and then import those MARC records into our library system (Millennium) . We want those records we have imported to match on ISBN. We want to keep the integrity of the data in the catalogue (we don't want the newly created records to overlay material currently in the catalogue) and we want, in the same process to be able to insert a note in the records in the catalogue that have been matched with our records created from the spreadsheet. All ideas will be gratefully received, Kind regards, Steve Grasso Resource Librarian Library Resource Services Queensland University of Technology Library Kelvin Grove Campus | Level 1, D Block | Victoria Park Road | Kelvin Grove QLD 4059 AUSTRALIA t: + 61 7 3138 5574 |f: +61 7 3138 3994 |e s.gra...@qut.edu.au<mailto:s.gra...@qut.edu.au> CRICOS No 00213J
