[Koha] Problem with patrons import

[Fischer, Katrin]

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 at lists.katipo.co.nz [mailto:koha-
> bounces at lists.katipo.co.nz] On Behalf Of Sonia P.
> Sent: Tuesday, April 16, 2013 1:19 PM
> To: koha at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>