Tracking record changes from an import.

[jdu98a]

I came up with a really handy way to document any and all changes that a user makes manually to any field. Basically, any field that I need to be tracked has an [color:gray]OnObjectSave script trigger assigned to it with the script parameter set to [color:gray]Get ( ActiveFieldName ). From here my script simply sets a field named ChangeHistory to:

Get ( CurrentTimeStamp ) & " - " & TextStyleAdd ( Get ( ScriptParameter ); Bold ) & " modified to: " & TextStyleAdd ( GetField ( Get ( ScriptParameter ) ); Bold ) & " - " & Get ( AccountName ) & ¶ &

TableName::ChangeHistory

This results in a neat and tidy documentation of the record change that looks like this:

4/21/2010 10:04:04 AM - PhoneNumber modified to: 555-555-5555 - Admin

This all works fine. However, my trouble starts when changes are made to multiple records (as often happens) via a file import. The import most often matches up one or more fields and then modifies any number of other field values as needed. I would like to be able to track any and all changes made by these imports as accurately and in the detail that I am able to track manual changes. Any ideas?

[comment]

Use auto-enter instead of script trigger. Do a search for "audit log" for more.