Search found 77 matches

by pbumc
Fri Jan 29, 2021 1:21 pm
Forum: General Questions and Discussion
Topic: Conditional, global search and replace?
Replies: 19
Views: 3628

Re: Conditional, global search and replace?

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...
by pbumc
Fri Jan 29, 2021 11:38 am
Forum: Membership
Topic: How to categorize non-church contacts?
Replies: 4
Views: 125

Re: How to categorize non-church contacts?

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...
by pbumc
Thu Jan 28, 2021 12:04 pm
Forum: Membership
Topic: How to categorize non-church contacts?
Replies: 4
Views: 125

Re: How to categorize non-church contacts?

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 ...
by pbumc
Wed Jan 27, 2021 2:16 pm
Forum: Membership
Topic: How to categorize non-church contacts?
Replies: 4
Views: 125

How to categorize non-church contacts?

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 ...
by pbumc
Wed Aug 26, 2020 11:40 am
Forum: Membership
Topic: Membership audit log, required fields
Replies: 2
Views: 91

Re: Membership audit log, required fields

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...
by pbumc
Tue Aug 25, 2020 6:23 pm
Forum: Membership
Topic: Membership audit log, required fields
Replies: 2
Views: 91

Membership audit log, required fields

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...
by pbumc
Wed Aug 12, 2020 10:20 pm
Forum: General Questions and Discussion
Topic: database changes report or audit log?
Replies: 4
Views: 1076

Re: database changes report or audit log?

Thanks, I'll look into v. 12!
by pbumc
Wed Aug 12, 2020 4:47 pm
Forum: General Questions and Discussion
Topic: database changes report or audit log?
Replies: 4
Views: 1076

Re: database changes report or audit log?

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...
by pbumc
Wed Jun 03, 2020 12:09 pm
Forum: General Questions and Discussion
Topic: Conditional, global search and replace?
Replies: 19
Views: 3628

Re: Conditional, global search and replace?

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

Code: Select all

COPY TO GETENV("USERPROFILE") + "\DESKTOP\TEMP.XLS" TYPE XL5
by pbumc
Wed Jun 03, 2020 11:27 am
Forum: General Questions and Discussion
Topic: Conditional, global search and replace?
Replies: 19
Views: 3628

Re: Conditional, global search and replace?

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

Code: Select all

COPY TO "%USERPROFILE%\DESKTOP\TEMP.XLS" TYPE XL5
but that gives the same error--maybe FoxPro won't expand environment variables?

Hard-coding the full path works.
by pbumc
Tue Jun 02, 2020 5:22 pm
Forum: General Questions and Discussion
Topic: Here's how to find orphaned Personal Profile records
Replies: 0
Views: 373

Here's how to find orphaned Personal Profile records

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 ...
by pbumc
Tue Jun 02, 2020 2:30 pm
Forum: General Questions and Discussion
Topic: Conditional, global search and replace?
Replies: 19
Views: 3628

Re: Conditional, global search and replace?

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...
by pbumc
Tue May 12, 2020 5:33 pm
Forum: General Questions and Discussion
Topic: Conditional, global search and replace?
Replies: 19
Views: 3628

Re: Conditional, global search and replace?

Great, thanks. Will try it next time.
by pbumc
Thu Apr 30, 2020 5:59 pm
Forum: General Questions and Discussion
Topic: Conditional, global search and replace?
Replies: 19
Views: 3628

Re: Conditional, global search and replace?

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...
by pbumc
Mon Apr 27, 2020 6:52 pm
Forum: General Questions and Discussion
Topic: Conditional, global search and replace?
Replies: 19
Views: 3628

Re: Conditional, global search and replace?

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. ...