[Koha] Koha - migration of history

[Galen Charlton]

Hi,

On Jan 24, 2011, at 2:03 PM, Linda Culberson wrote:
> 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?

Since you need to run reports on this, getting creation and last edit information into action_logs is the way to go for now.  If you've loaded your bibs and your staff users, inserting entries into action_log that look like this would do:

+-----------+---------------------+------+-------------+--------+--------+--------+
| action_id | timestamp           | user | module      | action | object | info   |
+-----------+---------------------+------+-------------+--------+--------+--------+
|         1 | 2007-07-14 18:13:05 |  599 | CATALOGUING | ADD    |      1 | biblio | 
|         2 | 2009-08-23 08:22:04 |    0 | CATALOGUING | MODIFY |      1 | biblio | 

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/