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

Hi Christy, Am 01.04.2015 um 06:47 schrieb ChristyThomas:

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.

Dates should be in your chosen date format or the database format YYYY-MM-DD to work well. Phone numbers are not checked for a special format. The error might also refer to a wrong branchcode or categorycode. They should match what you have defined in your database and you need to use the codes, not the descriptions. Sometimes an additional space that sneaked in can make the difference.

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

Make sure the header row has no quotes, but looks something like cardnumber,branchcode,surname,... Also try checking the file in a text editor instead of Excel or LibreOffice. Often it's easier to spot problems that way. Is the file really comma separated? Are strings enclosed in quotes? Does the number of header row fields match the number of values in your data? I am not sure about the error with the cardnumber as I think I haven't run into that so far. The cardnumber existing in the database should not be a problem, as it can be used as a matching point for updating patrons, but you can also create a patron whose cardnumber doesn't exist yet. Hope this helps, Katrin