[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:



"borrowernumber","cardnumber","surname","firstname","title","othernames","initials","streetnumber","streettype","address","address2","city","zipcode","country","email","phone","mobile","fax","emailpro","phonepro","B_streetnumber","B_streettype","B_address","B_address2","B_city","B_zipcode","B_country","B_email","B_phone","dateofbirth","branchcode","categorycode","dateenrolled","dateexpiry","gonenoaddress","lost","debarred","contactname","contactfirstname","contacttitle","guarantorid","borrowernotes","relationship","ethnicity","ethnotes","sex","password","flags","userid","opacnote","contactnote","sort1","sort2","altcontactfirstname","altcontactsurname","altcontactaddress1","altcontactaddress2","altcontactaddres3","altcontactzipcode","altcontactcountry","altcontactphone","smsalertnumber","privacy"
1 ... cut .... cut ... cut ....
2,"V10000019","Bucknell","David","Mr",,"DB",,,"55/27 Chaengwattana  
Road,  
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,

David
----- 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 -----



-- 
*http://iteachnet.org
*http://flossed.org
*http://ischoolnet.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
overseas.)

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



More information about the Koha mailing list