On Wed, Oct 28, 2015 at 6:03 PM, Terry Reese <[log in to unmask]> wrote:

> 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.
>

I favor the method Terry suggests. I haven't messed with a load table in
longer than I should admit but unless I'm forgetting something (and someone
with more recent knowledge should correct me), the addition of the note
can't be done with a "match and attach" table. This means you'd need to do
funky things with field protection to use load tables to handle the
matching.

You have to create MARC records from the spreadsheet anyway. Much easier to
merge them with a MARC dump from your system, add the notes, and overlay.
If you're worried, you can manually check the file before loading it. BTW,
I've overlayed hundreds of thousands of records in a single operation and
the process is quite safe. This will tweak the mod dates, so you'll want to
separate out records that didn't match if that's an issue.

kyle


>
>
>
> -----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
>