Galen, Some of the records do have the creator of the record in a 9XX field, but it is a very small percentage. I was thinking of the database approach because we need to be able to generate reports on the data by date, collection and cataloger . My other thought was to save the information I need at the time of the migration in a separate database, and then use the action_logs for data after the migration. Then I just would need to merge the two when needed. Do you think that be the better approach? On 1/24/2011 12:26 PM, Galen Charlton wrote:
Hi Linda,
On Jan 24, 2011, at 10:56 AM, Linda Culberson wrote:
So far I've figured out how to migrate the records, the patrons, and the circulation history from our current records into Koha. Now I'm looking into if/how to migrate a least part of the cataloging history. After discussions here, it sounds as if what we would most like to maintain, if possible, is the name of the original cataloger who added the record (most of our records are original cataloging) and the cataloger who last modified the record, with dates. Before I get too deep into this, I was wondering if anyone else has attempted this or something similar and/or what insights the someone might could give me on the feasibility of doing such a thing. I've looked at the action_logs table and it appears doable to me, I just don't know if it's advisable. While you could backfill historical bib record changes into action_logs, since it sounds like you don't need to retain full history, sticking the creator and last updater information into 9XX fields might be the simplest thing to do.
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/
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824