Hi Sonia, the import complained about ### and also the lines you copied into the file had those ###, so I assumed it was what is in the file. Sorry, I missed the text at the end of your mail.
CSV should be comma separated by name, but often you can pick the separator in the software on export. I normally use LibreOffice as that allows me to make sure the data is UTF-8 and properly separated. Maybe best is you open the file in an editor and check there? It's likely something about the header, because else I think it would be reporting a different error. Hope you can figure it out. Once the format is right, it's really a good tool and works nicely. Katrin > -----Original Message----- > From: koha-boun...@lists.katipo.co.nz [mailto:koha- > boun...@lists.katipo.co.nz] On Behalf Of Sonia P. > Sent: Tuesday, April 16, 2013 1:19 PM > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Problem with patrons import > > Dear Katrin > > Thanks for your quick reply. > When I open my cvs file, it's opened as a spreadsheet in a Excel-like > software. I guess if you open it with notepad, you would see comas. I > didn't, I trusted my software when it saved the file as a csv file. (I > can't double-check now, my file is on another computer in another location) > Should I really check that a cvs file is coma-separated? O_o And as > mentioned in my original email, I have already downloaded the starter file > and copy-paste all the headers. It is all in one row, the very first one, > all in lowercase, all at the right place, etc etc. Well it is just copy- > paste -- what could have gone wrong with a simple copy-paste? Plus, I have > double-checked the header row, two thousands times, there is not the > slightest unusual thing. > If the Patrons import says it's a problem with the header row, is it really > the header row? can it be that there is a problem somewhere else? > > Thanks a lot for your help! > > Sonia. > > _______________________________________________ > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha