[Koha] Convering patrons from Sagebrush Athena

[Tim McMahon - West Liberty Public Library]

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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha