[Koha] Problem in importing Patron Records

Prajeesh prajeeshb77 at gmail.com
Tue Jun 5 21:39:19 NZST 2012


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.

 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/.


More information about the Koha mailing list