Re: Load tables/loading patron records

[Steve Sowder <sowder@xxxxxxxxxx>]

We also use a "pseudotag" format. I believe it is called format 2 in the 
manual.  Each record has the following format:

00089 150       08-05-04
nBUSH, GEORGE
a123 MY STREET$BERRIEN SPRINGS, MI 49103
t(269)4716242
h92689 3RD ST$CRAWFORDVILLE, TX 76059
p
u000062395
b000062395
b62395

No conversion to marc is necessary. I believe the preprocess step in the 
load makes that conversion for you from the format above.

I think your real question is how to convert from the Excel spread sheet 
to an acceptable format (like the one above). 

If you are fluent in Perl (or just about any other language) that would be 
a simple process. 

Export the spreadsheet into a text (tab delimited) format and then 
read the file and convert to the above format. There may be some generic 
source code available to do that. 

Other readers may have suggestions that don't require programming.


Steve Sowder                          Systems Librarian
sowder@xxxxxxxxxx                   Andrews University


On Mon, 4 Aug 2003, 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
>