[Koha] Import Patron errors

[Stephanie Nordmann]

I was able to solve my problem.  The single quotes weren't necessary.  Not
to mention, I had branch codes that hadn't been defined quite yet.

 

Stephanie Nordmann

System Administration Manager

St Louis County Library

www.slcl.org

 

  _____  

From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Stephanie Nordmann
Sent: Thursday, July 23, 2009 12:38 PM
To: koha at lists.katipo.co.nz
Subject: [Koha] Import Patron errors

 

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/195bfbfc/attachment.htm