[Koha] Koha - migration of history

[Linda Culberson]

  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 at esilibrary.com
> direct: +1 352-215-7548
> skype:  gmcharlt
> web:    http://www.esilibrary.com/
>
>
>

-- 
Linda Culberson			lculber at 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