VBA/API

Re: Logging Database changes

David Zeidman — Tue, 03 Mar 2009 21:07:41 GMT

This is something that I have done for a client. They did have the VBA module so each time the a record was opened a values were recorded and then on closing the values were compared and stored in a database table. There was also a plug-in that allowed the user to see the changes that were made.

I have also been told about an organization that put triggers on some of the database tables so that the changes were copied to another table. I am not sure if this is allowed or whether it breaks the maintenance contract but I am told it worked well and of course did not require the VBA or API module.

David

Re: Logging Database changes

Drew Allen — Tue, 03 Mar 2009 19:52:05 GMT

In order for this to be effective, it would need to run automatically every time a record was changed. Plug-ins do not run automatically.

You could set up VBA scripts to run whenever a record was changed, assuming that you have the VBA module.

Drew

Re: Logging Database changes

Tesa Vonburg — Tue, 03 Mar 2009 19:39:22 GMT

Please let me know if there is a plugin to use to track these events. I do not have API access. The only other way to do it would be to setup audit files on SQL Server Admin.

Re: Logging Database changes

JoAnn Strommen — Tue, 03 Mar 2009 18:01:12 GMT

To give you a partial answer until one of the many experts have a chance to reply...

You can run a query on changed constituent, action and gift records etc. You can query on date changed, changed by ____. I don't believe it will give exactly what field was changed but some sections of constituent record such as changes to solicitor relationships can also be queried on.

Good luck.

Logging Database changes

Joshua Holden — Mon, 02 Mar 2009 16:08:37 GMT

Hello,

I've recently started to review RE and am curious is it's possible to record / access record change events. I would like to know who modified what record and what time. I would also be nice to have a real-time event logger. Any code examples I could use for testing purposes would be appreciated. Or even pointing me to the correct api method would suffice.

Thanks,