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.