[Koha] Problem with patrons import

[Sonia P.]

Hello
Thanks all for your help.
I use a Mac too, but I don't know that Numbers application (I am not good with Mac, but somehow it is the only thing I am allowed to use here... >.<).  Maybe this is a Mac problem?  I will have to reinstall a spreadsheet application on my PC to try again.  It worked very well the previous times I tried to import patrons, but then I was on my PC...
Anyway, back on that Mac, I opened my .csv file and it reads:
borrowernumber,cardnumber,surname,firstname,title,address,address2,city,state,zipcode,email,phone,fax,branchcode,categorycode,gonenoaddressT1,T1,TARTAMPION,Philip,Mr & Mrs,Po BOX xxx,,Birdcity,,2608,email at email.com.au,6123 4567,6987 6543,CANB,A,T2,T2,MACHINTRUC,Bidule,"Ms",Pink House,,City,,2600,,,,CANB,A,13,13,PATATRUC,Philip,Mr,Po Box xxx,,Fishcity,,2604,email at email.com.au,0412 1234 5678,02 6123 4567,CANB,A,
ETC ETC
Aman, thanks for your help, but it has been done as mentioned again and again... :)
Cheers,
Sonia.

Date: Wed, 17 Apr 2013 14:38:18 +1200
Subject: Re: [Koha] Problem with patrons import
From: amurphy at katikaticollege.school.nz
To: sossolapro at hotmail.com

Hi Sonia
I too had this problem. I have a work around; it's not pretty but it works.I open the .csv file in Excel, cut/copy the patrons and paste them into a template spreadsheet with the correct headings. I work out the information for attributes, library code and patron categories then save and close. I open the file in Numbers (I use a Mac — I'm not sure of the PC equivalent) then export (in the file menu) the file using .csv and text encoding Unicode (UTF-8). Then I delete the .csv from the file_name (the message asks if I am sure I want to do this — yes). It then uploads just fine. I don't know why this works but it does. Every now and then I try the direct way, but so far no go. 

Good Luck
-- 
Ann Murphy
Librarian
Katikati College
Beach Road, Katikati, 3129
New Zealand

0064 7 5492647

amurphy at katikaticollege.school.nz