Search found 77 matches
- Fri Jan 29, 2021 1:21 pm
- Forum: General Questions and Discussion
- Topic: Conditional, global search and replace?
- Replies: 19
- Views: 52718
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...
- Fri Jan 29, 2021 11:38 am
- Forum: Membership
- Topic: How to categorize non-church contacts?
- Replies: 4
- Views: 4204
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...
- Thu Jan 28, 2021 12:04 pm
- Forum: Membership
- Topic: How to categorize non-church contacts?
- Replies: 4
- Views: 4204
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 ...
- Wed Jan 27, 2021 2:16 pm
- Forum: Membership
- Topic: How to categorize non-church contacts?
- Replies: 4
- Views: 4204
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 ...
- Wed Aug 26, 2020 12:40 pm
- Forum: Membership
- Topic: Membership audit log, required fields
- Replies: 2
- Views: 2856
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...
- Tue Aug 25, 2020 7:23 pm
- Forum: Membership
- Topic: Membership audit log, required fields
- Replies: 2
- Views: 2856
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...
- Wed Aug 12, 2020 11:20 pm
- Forum: General Questions and Discussion
- Topic: database changes report or audit log?
- Replies: 4
- Views: 2536
Re: database changes report or audit log?
Thanks, I'll look into v. 12!
- Wed Aug 12, 2020 5:47 pm
- Forum: General Questions and Discussion
- Topic: database changes report or audit log?
- Replies: 4
- Views: 2536
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...
- Wed Jun 03, 2020 1:09 pm
- Forum: General Questions and Discussion
- Topic: Conditional, global search and replace?
- Replies: 19
- Views: 52718
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
- Wed Jun 03, 2020 12:27 pm
- Forum: General Questions and Discussion
- Topic: Conditional, global search and replace?
- Replies: 19
- Views: 52718
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
but that gives the same error--maybe FoxPro won't expand environment variables?
Hard-coding the full path works.
Code: Select all
COPY TO "%USERPROFILE%\DESKTOP\TEMP.XLS" TYPE XL5
Hard-coding the full path works.
- Tue Jun 02, 2020 6:22 pm
- Forum: General Questions and Discussion
- Topic: Here's how to find orphaned Personal Profile records
- Replies: 0
- Views: 2147
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 ...
- Tue Jun 02, 2020 3:30 pm
- Forum: General Questions and Discussion
- Topic: Conditional, global search and replace?
- Replies: 19
- Views: 52718
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...
- Tue May 12, 2020 6:33 pm
- Forum: General Questions and Discussion
- Topic: Conditional, global search and replace?
- Replies: 19
- Views: 52718
Re: Conditional, global search and replace?
Great, thanks. Will try it next time.
- Thu Apr 30, 2020 6:59 pm
- Forum: General Questions and Discussion
- Topic: Conditional, global search and replace?
- Replies: 19
- Views: 52718
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...
- Mon Apr 27, 2020 7:52 pm
- Forum: General Questions and Discussion
- Topic: Conditional, global search and replace?
- Replies: 19
- Views: 52718
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. ...