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