User Support Forum

Zorak, Got it, thanks. We haven't been using events (though I see the ones I set up in 2009), and mail_no/pers_no is 0 on all EVENTS records, so I feel better about having skipped that. These queries returns 0 records: Select * from EVEVENTS where mail_no = 2410 and pers_no = 1 Select * from EVOCC I...

Okay I think this is fixed. Before starting, I reassigned the Envelope Number (for which the financial secretary had re-added contributions) to number 9901, and added "DO NOT USE" to the new family and profile he created. I remembered that DBF files don't actually delete records until you pack the d...

Now that I've restored a backup to a temporary location, I thought I'd correct my previous statement now that I see what actually happened. The two household members did in fact have different envelope numbers, so a statement was generated for each. The issue was that when the second profile was mov...

Great, thanks Neil. I've removed Delete profile and family from all users.

Zorak, Thanks for your prompt and detailed reply. Point taken about Delete privileges. And you're right, "accidental" was the wrong word. The issue was that a member contacted our financial secretary asking for a contribution statement separate from her spouse. I thought the finsec knew about just a...

Hi, We're using PCPlus 15. A volunteer accidentally deleted an individual from a family, not realizing this wiped out not only her donation history but also 2+ years of attendance history. Unfortunately, too much time has passed to restore the entire database. I assume I can restore a backup to a te...

In case anyone is following this thread: I realized that the SELECTs were including profiles whose attendance was expected (active in the 1002 activity) whether they were Present or not. I updated the three scripts to add "and atdata.status = 'P'", which confirms that the person was Present at the a...

Yeah .. you really don't need to have a personal profile in these cases at all. I suspect that you've been using the "Add Family Assistant" to enter these exceptions as it will create the personal profiles records. What you should do to add these types of records is UNCHECK the use add family assis...

Thanks Neil. Any reason to keep Personal Profile records at all when there is no contribution history to maintain and no people to track? Say if they want a way to keep the phone number and address of restaurants, appliance repair shops, etc. It looks like it is possible to delete the last Personal ...

Our church uses PowerChurch 11.55 to track members and donations, but not for full accounting. I'm working on cleaning up records created over the years with no Personal Status. I'm seeing that many are not related to church members or visitors: Facilities users, bake sale (fees/proceeds tracked as ...

Neil, thanks for the suggestions. You can setup in the Family Mailing list preferences, a default mailing category, and you can do the same with the personal profiles under preferences. I always feel that its a training issue; anyone who has permission to add to the membership database should know h...

Hi, We're working on cleaning up PowerChurch data. With multiple people working in the database over the years, and not all of them highly skilled at data management, it's quite a mess. Our big push has been to deactivate people who are no longer involved, which we mostly do with the Personal Profil...

Thanks, I'll look into v. 12!

Eleven years later, I'm looking for the same feature in PC 11.55. Or at a minimum, an indication of Last Update By and Last Update At (timestamp) for the Family and Personal records. I'd make these fields visible on all tabs but not editable, probably left justified in the bottom margin, at the same...

I do like a challenge . Looks like GETENV will do it.