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,em...@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,em...@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: amur...@katikaticollege.school.nz
To: sossola...@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
amur...@katikaticollege.school.nz
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
