Re: Load tables/loading patron records

[Hilary Caws-Elwitt <sctylibrary@xxxxxxxxxx>]

We did essentially what you're describing--from comma-delimited to 
MARC--with our patron records. I mostly used File Express (an 
oldie-but-goodie flat database program that is very easy & intuitive to 
use) to insert MARC text tags (so the name field went from "Doe, John" 
to "=100  \\$aDoe, John", then exported & used MarcEdit or MarcMaker to 
translate. (There may have been a little extra tweaking involved that 
I'm not remembering...) Presumably there's other software that could do 
similar things. If you have any kind of field indicator already, even 
global search & replace might do the trick?

Feel free to contact me off list if you want more details--we also did 
this with our bibs & items, which was much more complicated but really 
paid off in getting exactly the fields we wanted.

-- 
Hilary Caws-Elwitt, Systems & Public Services Librarian
Susquehanna County Library, 2 Monument Sq, Montrose PA 18801
Phone 570-278-1881 -- Fax 570-278-9336
sctylibrary@xxxxxxxxxx -- http://www.susqcolibrary.org


Eric Rhee wrote:
 > This is a re-phrase of a question I posed to the IUG on 8/1/03 regarding
 > loading patron records in 2002 phase 1.  My system has MARC load 
tables for
 > patron records. (This is  pseudo-MARC where tags are assigned to 
patron data
 > fields). I have a disk in Excel format containing patron information. 
  The
 > challenge is how can I tag the patron information in a batch process 
so it
 > can be loading into  the  Millenium system? Page 101687 in CSDirect 
covers
 > the actual loading.   Has anyone ever used the free MARCedit programs for
 > this type of file conversion?  Any other ideas?
 >
 > Eric Rhee
 > Automation and Circulation Manager
 > Chula Vista Public Library
 > 365 F Street
 > Chula Vista CA 91910
 > Office:  619 691-5138
 > FAX              427-4246
 > erhee@xxxxxxxxxx
 >
 > --
 > This message was distributed through the Innovative Users Group 
INNOPAC list
 > Public replies:  INNOPAC@xxxxxxxxxx
 > Update your subscription options: 
http://innopacusers.org/list/listinfo/innopac
 >