Log of changes - who deleted a contact, registration, or changed data
Is there a way to find out which admin deleted or changed a contact registration or details.
For example we have an event which a company registered their attendees and paid online. One of the admins deleted the registration. Is there a way to find out which admin deleted that contact?
If this is not available could is possibly be added in the future? I like the fact that the 4.0 service will allow read only admin access which will help with this issue but I am still curious which of my admins deleted that contact.
Becky, thank you, your ideas are much appreciated.
Becky Parsons commented
I'm thinking of abbreviated history info, not too much detail. For example, a listing that can be searched by date range, admin name, account name, webpage name, and a short 2 or 3 words about the action taken, such as:
Date Admin Account/Web Page Action Taken
6/14/2013 Sue Jones Sam Smith, contact #101234 Email changed
6/15/2013 Bob Taff Issues, web page #96878 Revised
6/16/2013 Sue Jones Pete Green, member #68445 New membership
6/16/2013 Sue Jones Pete Green, member #68445 Pmt posted
6/16/2013 Sue Jones Grace Sims, contact #32198 Donation deleted
6/17/2013 Bob Taff About Us, web page #36721 Revised
6/17/2013 Sue Jones Rose Miller, member #50922 Mbr Renewal, invoice
6/17/2013 Sue Jones Rose Miller, member #50922 Pmt posted
6/17/2013 Tom Davis Ben Brown, member #99622 Mbr Renewal, no invoice
6/17/2013 Sue Jones Mary Adams, contact #101675 New contact
With a list like this it would be easy to scan and identify areas to investigate. In this case, the assumption is that Bob Taff can make web page changes. The areas to check would be the actions on Grace Sims' account (why was a donation deleted?) and Ben Brown's account (why was a membership renewed without payment?).
Or, simply a static list that can be exported to Excel for sorting.
Becky, there are different ways to track database history depending on the intended usage. What would really help us is a a detailed example of a couple of situations of how this might be used in your organization.
Becky Parsons commented
I'm adding to a thread that is 2 years old. But this triggers a question I've had in my mind for a long time.
Wild Apricot is the only software system I've experienced that has no history of database changes. When there are several people who can access the database, or just to identify a mistake, it is valuable to have such a history.
We should be able to search the database history by: admin name, change date range, contact/member name, contact account number.
Evgeny Zaritovskiy commented
You're right - we have been talking about for a long time but without any practical results. Too many other thing we focused on.
I think that it is not enough to just know who deleted something and when but also there should be a way restore this information somehow. Or you think it's enough to start from just logging admins activity and do not focus on restoring?
James Kerich commented
I remember this issue coming up years ago. I thought you built the backbone for this, but never implemented it? For instance, I use or maybe still do get a pop up when I delete a registration asking why the registration was deleted. Can't remember if that pop up still shows up now or not. Not sure why you didn't move forward with that.
I also remember about a year ago a discussion thread regarding implementing an audit trail or an activity log report that could be viewed to show what is going on and happening on the application. Not sure what ever came of that. The audit log or activity log would be very useful as I know we have wondered what happened at times when funky stuff happens on the WA site. Hope to see that come back up on the to do list.
This is not currently possible - good point, I can see why this might be useful.
Goldmine jody commented
It would be useful to be able to know when notes are added in the contact database and by whom if there is with more than one person adding data. e.g. "Called her and l/m re: missed payment" More useful if entered as: "2014-05-12-JH-Called and l/m re....."