Hi! I have had customers reporting problems importing patron data from Excel into Koha (via CSV). When I have opened the file in LibreOffice and saved as CSV from there it has worked fine for me. Could you give LibreOffice a try?
I think it *might* be related to this bug: Bug 10117 - Byte Order Mark breaks Patron Import http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10117 Best regards, Magnus Enger libriotech.no On 6 April 2015 at 13:04, Riley Childs <[email protected]> wrote: > Could you please attach a copy of the file with the private fields containing > PRIVATE? > > Sent from my Windows Phone > > -- > Riley Childs > Senior > Charlotte United Christian Academy > Library Services Administrator > IT Services Administrator > (704) 537-0331x101 > (704) 497-2086 > rileychilds.net > @rowdychildren > I use Lync (select External Contact on any XMPP chat client) > > CONFIDENTIALITY NOTICE: This email and any files transmitted with it are the > property of Charlotte United Christian Academy. This e-mail, and any > attachments thereto, is intended only for use by the addressee(s) named > herein and may contain confidential information that is privileged and/or > exempt from disclosure under applicable law. If you are not one of the named > original recipients or have received this e-mail in error, please permanently > delete the original and any copy of any e-mail and any printout thereof. > Thank you for your compliance. This email is also subject to copyright. No > part of it nor any attachments may be reproduced, adapted, forwarded or > transmitted without the written consent of the copyright > [email protected] > > ________________________________ > From: ChristyThomas<mailto:[email protected]> > Sent: 4/5/2015 4:51 PM > To: [email protected]<mailto:[email protected]> > Subject: [Koha] adding patrons in a batch - getting errors > > Hi, > > We (my mom) are trying to add student patrons in batches. She made an excel > file following the Koha instructions. She is getting errors. Do you have any > suggestions or possibly do you have a template that you know works that you > can send me. Here are her emails describing what happened: > > FIRST EMAIL: > One attempt, nothing imported. Said something not expected format which > almost certainly means phone numbers or dates. I'm going to have to play > around a little to determine what is hanging it up... perhaps later tonight. > > > SECOND EMAIL: > I took it down to only names and the required codes and it still wouldn't > load. The error messages are below. It appears it doesn't like my header > row, which I copied from their instructions. Says it could not be parsed. I > searched on that error message and I appear to be not the only one who has > this problem, and they system does not think that it is a csv, but tab > separated. I'm going to work on it tomorrow on a break and try a couple > other ways to see if I can find a way for it to be a csv file that system > recognizes. xoxo Mom > > Feedback: > > Parsing upload file Library1.csv > Content-Disposition : form-data; name="uploadborrowers"; > filename="Library1.csv" > Content-Type : application/vnd.ms-excel > headerrow : > Error analysis: > Header row could not be parsed > > > Thanks, Christy > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/adding-patrons-in-a-batch-getting-errors-tp5833906.html > Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
