[Koha] Import Patron errors

[Stephanie Nordmann]

Hello,

   I have on installed Koha 3.00.02.012 on a test/training server.  My
current task is to export test patrons from our existing Millennium system
into Koha.  I created a program using c# to generate a csv file into the
appropriate format for import into Koha.  Looking at the output file, it
seems to me that the format is how Koha wants it.  Unfortunately, I get many
errors upon import:

 

#  Line 2  Critical field "surname" missing (borrowernumber: UNDEF; surname:
UNDEF).

'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH
BLVD','ST LOUIS MO
63131'','','','nonotice at slcl.org','##314-555-0232','','','','','','','','','
','','','01/01/1986','h
','ARES','06/11/99','10/31/2009','','','','','','','','Record contains
system default
birthdate','','','','','','','','','','','','','','','','','','','','MONEY:'
$0.60','GEO:'1',

# Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
surname: UNDEF).

'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH
BLVD','ST LOUIS MO
63131'','','','nonotice at slcl.org','##314-555-0232','','','','','','','','','
','','','01/01/1986','h
','ARES','06/11/99','10/31/2009','','','','','','','','Record contains
system default
birthdate','','','','','','','','','','','','','','','','','','','','MONEY:'
$0.60','GEO:'1',

# Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF).

'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH
BLVD','ST LOUIS MO
63131'','','','nonotice at slcl.org','##314-555-0232','','','','','','','','','
','','','01/01/1986','h
','ARES','06/11/99','10/31/2009','','','','','','','','Record contains
system default
birthdate','','','','','','','','','','','','','','','','','','','','MONEY:'
$0.60','GEO:'1',

# Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF).

'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH
BLVD','ST LOUIS MO
63131'','','','nonotice at slcl.org','##314-555-0232','','','','','','','','','
','','','01/01/1986','h
','ARES','06/11/99','10/31/2009','','','','','','','','Record contains
system default
birthdate','','','','','','','','','','','','','','','','','','','','MONEY:'
$0.60','GEO:'1',

# Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
surname: UNDEF).

'p14614479','0014437362','THAW','SPRING'','','',,'','','1640 LINDBERGH
BLVD','ST LOUIS MO
63131'','','','nonotice at slcl.org','##314-555-0232','','','','','','','','','
','','','01/01/1986','h
','ARES','06/11/99','10/31/2009','','','','','','','','Record contains
system default
birthdate','','','','','','','','','','','','','','','','','','','','MONEY:'
$0.60','GEO:'1',

 

All of the categorycodes and branchcodes match the system entries.  

All of these "patrons" aren't real people, in case anyone was wondering
:-).

 

I've attached my output.csv file.  Does anyone know what I am doing wrong?
Let me know if there's any additional information that would help.

 

Thanks!!

 

Stephanie Nordmann

System Administration Manager

St Louis County Library

www.slcl.org <http://www.slcl.org/> 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090723/38b6fe55/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Output.csv
Type: application/vnd.ms-excel
Size: 10725 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20090723/38b6fe55/attachment-0001.xlb