Re: [Koha] How to export patrons from 2.2.9?
SELECT * FROM koha229.borrowers;
David M. Bucknell<dbucknell@iteachnet.org> 9/14/2010 6:50 AM >>> Hello,
We're setting up another instance of 3.2 and have imported records into it from 2.2.9. However, we haven't found a way to export the patrons from 2.2.9. Does anyone remember how to do this? Many thanks, David -- *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. _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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
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@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@myacpl.org --------- Date: Tue, 14 Sep 2010 08:39:50 -0400 From: Owen Leonard <oleonard@myacpl.org> Reply-To: Owen Leonard <oleonard@myacpl.org> Subject: Re: [Koha] How to export patrons from 2.2.9? To: koha@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
----- End message from oleonard@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.
Hi, On Sep 15, 2010, at 9:38 AM, David M. Bucknell wrote:
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?
It sounds like that you need to add a patron category whose code is 'A' first, then retry the patron import. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/
Thank you for interpreting the message. That got us going, and we were able to do follow the same process when we encountered further errors. Best wishes, David ----- Message from gmc@esilibrary.com --------- Date: Wed, 15 Sep 2010 09:52:17 -0400 From: Galen Charlton <gmc@esilibrary.com> Reply-To: Galen Charlton <gmc@esilibrary.com> Subject: Re: [Koha] How to export patrons from 2.2.9? To: david@intknowledge.com Cc: koha@lists.katipo.co.nz
Hi,
On Sep 15, 2010, at 9:38 AM, David M. Bucknell wrote:
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?
It sounds like that you need to add a patron category whose code is 'A' first, then retry the patron import.
Regards,
Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
----- End message from gmc@esilibrary.com ----- -- *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.
"categorycode" has unrecognized value "A"
From the "Notes" on the patron import page:
"The fields 'branchcode' and 'categorycode' are required and must match valid entries in your database." So I'm guessing your installation doesn't have a patron category set up with categorycode "A" ? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
participants (4)
-
David M. Bucknell -
Galen Charlton -
Owen Leonard -
Scott Owen