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>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha