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-bounces@lists.katipo.co.nz [mailto:koha- bounces@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