[Koha] Problem in importing Patron Records

[Paul]

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 at 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>