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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Stephanie Nordmann Sent: Thursday, July 23, 2009 12:38 PM To: koha@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@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@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@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@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@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/>