[Koha] Patron Batch Import - Help Request.

[Bob Birchall]

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