At 03:09 PM 6/5/2012 +0530, Prajeesh wrote:

Dear all

I tried to import a .csv file to my Koha installation (version 3.06.01.000) and got the following errors. I have checked the Branch code and the Category Code. It is give correct in the .csv file. Is there any bug reported in this version regarding patron import. Please help me. The .csv file is attached.

The file was not attached. Did you use the default Koha format for dates as YYYY-MM-DD? From the errors, you appear to be using DD/MM/YYYY (but this could just be your sys pref for output.) Paul

Import Patrons Import results :

- 0 imported records - 0 overwritten - 0 not imported because already in borrowers table and overwrite disabled - 2 not imported because they are not in the expected format - 2 records parsed - Back to Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl>

Feedback:

- Parsing upload file patron_import BPT2011 (copy).csv - Content-Type : text/csv - Content-Disposition : form-data; name="uploadborrowers"; filename="patron_import BPT2011 (copy).csv" - headerrow :

Error analysis:

- Header row could not be parsed - Line 2 could not be parsed! "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" - Line 3 could not be parsed! "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" - Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" - Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06"

-- With Regards

Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 http://kerala-lis.blogspot.com/. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

--- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>