[Koha] adding patrons in a batch - getting errors

[Magnus Enger]

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 <rchilds at cucawarriors.com> 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 owner at cucawarriors.com
>
> ________________________________
> From: ChristyThomas<mailto:christy_thomas at yahoo.com>
> Sent: ‎4/‎5/‎2015 4:51 PM
> To: koha at lists.katipo.co.nz<mailto:koha at lists.katipo.co.nz>
> 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
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha