User Support Forum

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.

Ah, of course. On the computer where I got the error, the name of the user's folder includes the domain name. I just tried
but that gives the same error--maybe FoxPro won't expand environment variables?

Hard-coding the full path works.

I had a situation where going from a Personal Profile record to the Family record brought up an unrelated family. I used this script from Utilities > Database Manager to confirm that the Personal Profile was not linked to a Family (its mail_no field is empty). In this case, the Personal Profile was ...

Hi Zorak, We've finished our initial cleanup and I went back in to re-run the SELECT and see if we got everyone. However, the COPY TO command is now returning Error :OLE error code 0x80030003: Unknown COM status code. We just updated to the 04/16/2020 release of PowerChurch 11.55, which also updated...

Great, thanks. Will try it next time.

Here's what I tried: 1. Opened Notepad++. Pasted in a command. Edit > EOL Conversion > Unix. Save as C:\Users\<username>\Desktop\test.prg. 2. In PowerChurch DB Administrator, cd \Users\<username>\Desktop\. Use dir *.prg to confirm file is there. 3. do test returns "Error: File 'test.prg' does not ex...

After you run a select and view the query results, you can run one of the following to save the result COPY TO "C:\TEST.XLS" TYPE XL5 This is extremely helpful, thank you! With this, I can export a list of people to discuss with others before we make changes. We might even do the changes manually. ...