I'm looking for comments on my work so far. Here is the MySQL script I wrote to move patron data to Koha. I converted the dbf file from the Athena export to the test database in MySQL using dbf2mysql. Let me know if you see anything that should be changed or could be done a better way. insert into Koha.borrowers ( cardnumber, surname, firstname, title, streetaddress, city, phone, emailaddress, altstreetaddress, altcity, altphone, dateenrolled, borrowernotes, expiry, altnotes, zipcode) select patronid, surname, firstname, salutation, street1, concat(city,', ',provstate), phone, email, astreet1, concat(acity,', ',aprovstate), aphone, recorddate, message, expirydate, blockmsg, postalzip from test.patrons order by patronid; update Koha.borrowers set debarred = 1 where altnotes > ""; I set Debarred to 1 when the patron has a blocking message (saved as altnotes in the Athena database). _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha