[Koha] How to export patrons from 2.2.9?

David M. Bucknell dbucknell at iteachnet.org
Thu Sep 16 01:38:57 NZST 2010

Thank you, Scott and Owen.

We have exported successfully and following the link to the  
documentation you sent, have rearranged a bit ....  But we're getting  
this error when we try to import:

"categorycode" has unrecognized value "A"

We don't know what to make of this.  Does anyone know?

Here's a sample of the file:

1 ... cut .... cut ... cut ....
2,"V10000019","Bucknell","David","Mr",,"DB",,,"55/27 Chaengwattana  
Pakkret",,"Nonthaburi",,,"david at myaddress.com",70472211,,,,,,,,,,,,,,05/10/58,"RMA","A",17/07/03,17/07/04,0,0,0,,,,,,"neighbour",,,"M","iLjokCX7QrwwmDPBNCwgdQ",2047,"david",,,,,,,,,,,,,,

Thank you,

----- Message from oleonard at myacpl.org ---------
     Date: Tue, 14 Sep 2010 08:39:50 -0400
     From: Owen Leonard <oleonard at myacpl.org>
Reply-To: Owen Leonard <oleonard at myacpl.org>
  Subject: Re: [Koha] How to export patrons from 2.2.9?
       To: koha at lists.katipo.co.nz

>> SELECT * FROM koha229.borrowers;
> The structure of the borrowers table has changed in 3.2, so a plain
> "SELECT *" won't give you something you can work with directly. 3.2
> does let you import patrons via a CSV file, so if you can dump your
> koha229.borrowers table as a CSV you can use that. You'll have to
> massage the CSV to get it to match the columns in 3.2.
> Here's the relevant section of the manual:
> http://koha-community.org/documentation/3-2-manual/?ch=x5218
>   -- Owen
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

----- End message from oleonard at myacpl.org -----

*Web Ideas, Tools and Sites for Teachers, Schools, and You.
*Cell: +66(0*)84 329 1183; Office: +66(0*)2 980 9464 (*No "0" if calling from

This message was sent using IMP, the Internet Messaging Program.

More information about the Koha mailing list