Track who inputs or changes data

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Moderators: Moderators, Tech Support

Post Reply
FBCMoyock
Posts: 74
Joined: Fri Nov 06, 2009 9:28 am

Track who inputs or changes data

Post by FBCMoyock »

Is there a way to track which user inputs or changes data?

NeilZ
Posts: 10464
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Track who inputs or changes data

Post by NeilZ »

FBCMoyock wrote:Is there a way to track which user inputs or changes data?
There is no audit trail for membership, you do have some audit trails in Contributions. Was there a specific area you were looking for ??
Neil Zampella

Using PC+ since 1999.

FBCMoyock
Posts: 74
Joined: Fri Nov 06, 2009 9:28 am

Re: Track who inputs or changes data

Post by FBCMoyock »

I've found double entries, people in the wrong family, misspelled names, etc. I would like to know who entered the record, or who was the last person to modify the record so I could speak to that person individually instead of having to make general sweeping statements about being more careful with your data entry. Since there is a date last modified field and a date entered, why can't it capture the users login and store that also?

Zorak
Tech Support
Tech Support
Posts: 3112
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Track who inputs or changes data

Post by Zorak »

The system does not track who makes changes or adds new people in the Membership side.

NeilZ
Posts: 10464
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Track who inputs or changes data

Post by NeilZ »

We had to basically make sure that only people who really NEEDED add/update/delete permissions were given them, and made sure that they knew how to search for names.

I can understand why there isn't such an audit trail. There can be so many updates made over a week, that sort of table would quickly become unwieldy.

It does boil down to a training issue.
Neil Zampella

Using PC+ since 1999.

debbieg
Posts: 206
Joined: Mon Jun 29, 2009 9:40 pm

Re: Track who inputs or changes data

Post by debbieg »

I feel your pain. I have gone through the effort several times of getting all the households/profiles straightened out and then when i look again....chaos.

It doesn't have to be a full blown audit trail...just the addition of an "update by" field. Usually goes hand in hand with the "update date" field in a database.
debbie

NeilZ
Posts: 10464
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Track who inputs or changes data

Post by NeilZ »

debbieg wrote:I feel your pain. I have gone through the effort several times of getting all the households/profiles straightened out and then when i look again....chaos.

It doesn't have to be a full blown audit trail...just the addition of an "update by" field. Usually goes hand in hand with the "update date" field in a database.
debbie
Problem is an update field would not help you to discover who deleted a record. If the record is gone, there's no trail. It would tell you who updated Mary's record, but that's about all, not what was changed.
Neil Zampella

Using PC+ since 1999.

dparker
Posts: 3
Joined: Thu Jul 28, 2011 9:20 am

Re: Track who inputs or changes data

Post by dparker »

Is there an "Audit Trail" report available; one that would show a list of all "personal records" that have been altered and would identify the alteration(s).

NeilZ
Posts: 10464
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Track who inputs or changes data

Post by NeilZ »

dparker wrote:Is there an "Audit Trail" report available; one that would show a list of all "personal records" that have been altered and would identify the alteration(s).
No .. as mentioned above, there can be so many updates made weekly that such a table would grow unwielding in a few months.

The easiest way to take care of the problem is to make sure only those people who REALLY need update or delete permissions have that permission.
Neil Zampella

Using PC+ since 1999.

Post Reply