Hello folks, We're migrating from a home-grown Library Management System (using MySQL for the DB) to Koha. The current DB has the following fields in the "circulation" table, and I'm wondering if anyone could provide me with the SQL commands for me to be able to successfully get the existing data into the old_items table in Koha's MySQL DB? I think I can get the MySQL dump that contains only those records in my current DB that have been returned, but don't know the MySQL statement(s) to "import" it and exactly what fields in Koha's 'old_items' table that are required. Any comments/tips/thoughts on doing this are greatly appreciated.
Current DB Circulation table: book_id patron_id trans_date trans_time due_date Also, I'm assuming that if I accomplish this successfully I should also be able to do pretty much the same thing to get the currently checked-out items imported into the 'items' table as well.does that sound like a reasonable assumption/expectation? THANKS! Steve _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
