[Koha] Koha - migration of history

[Linda Culberson]

  Thanks, Galen.  I especially appreciate the example.
Linda

On 1/24/2011 2:09 PM, Galen Charlton wrote:
> 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/
>
>
>

-- 
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