On 05/02/15 19:20, SATISH wrote:
Hi,
Koha (3.16) has been installed from packages method on ubuntu 12.4 LTS.
Now I am trying to batch import of patron with the help of CSV template
given in Koha. I just did copy and paste 1 patron related information to
CSV for testing.
I do not have any borrowernumber information.
That's OK. Koha will assign the borrowernumber.
For me only, card number is
primarily required.All other mandatory fields, such as Branch Code and
Category Code has been cross verified and inserted in to CSV.
After upload, finally thrown with following errors.
- Line 2 Critical field "surname" missing (borrowernumber: UNDEF;
surname: UNDEF).
4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016
- Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
surname: UNDEF).
4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016
- Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF).
4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016
- Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF).
4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016
- Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
surname: UNDEF).
4GH13CV001 Satish 01/01/95 GECHLIB UG 01/08/2012 30/06/2016
Is all the fields in CSV file are mandatory?
No. You seem to have identified the ones that are. However, you must
follow the Notes on the Import Patrons page exactly. Exactly! I prefer
to use the 'starter csv file' offered on that page.
or partially I can fill
whatever is mandated. What is the reason for getting above said error ?
I believe, this is repetitive question but, I did not get solution from
other answers in forum or video tutorials. Therefore posted a fresh
question. Please advice to proceed further for batch import of patrons.
Did you use MS Excel to prepare you spreadsheet? If so, try again using
LibreOffice.
I hope this helps.
Bob Birchall
Calyx
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
