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:[log in to unmask]] On Behalf Of
Stephen Grasso
Sent: Wednesday, October 28, 2015 8:16 PM
To: [log in to unmask]
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
[log in to unmask]<mailto:[log in to unmask]>

CRICOS No 00213J