User Support Forum

New user with a question.

I want to be able to run a automatic scheduled script that queries the Power Church members' email list and pulls out emails based on member groupings (such as committee membership or personal interests or ...). The resulting file would ideally be a simple text file with one email address per line of the emails selected via the query.

An alternative approach could be using Power Church as an email generator (listserv) to member groups. I don't think it can do that presently. Am I right?

I have done this kind of thing using MySQL and PHP and Smartlist on Linux for community groups. That you are using phpBB for this forum suggests maybe you can relate to what I am trying to do.

Thanks for any guidance.

Sincerely, Allen Wilkinson

aw wrote:New user with a question.

I want to be able to run a automatic scheduled script that queries the Power Church members' email list and pulls out emails based on member groupings (such as committee membership or personal interests or ...). The resulting file would ideally be a simple text file with one email address per line of the emails selected via the query.

An alternative approach could be using Power Church as an email generator (listserv) to member groups. I don't think it can do that presently. Am I right?

I have done this kind of thing using MySQL and PHP and Smartlist on Linux for community groups. That you are using phpBB for this forum suggests maybe you can relate to what I am trying to do.

Thanks for any guidance.

Sincerely, Allen Wilkinson

As answered in your question in another forum, Powerchurch uses Foxpro as its database engine. If you have an ODBC driver that can access Foxpro databases you can do what you would like to do.

However, the alternative is to use Powerchurch to generate the email lists, and that you would have to have the church secretary do on a weekly or monthly basis.

I have found how I can execute a Database Manager query to create a .csv file with emails in it and NeilZ confirmed PC+ 10 can have arbitrary sub-groups, like a committee, selectable.

Can I set up PC+ 10 to create such a .csv file as a scheduled task, either using windoze task scheduler or a built in PC+ 10 feature?

aw wrote:I have found how I can execute a Database Manager query to create a .csv file with emails in it and NeilZ confirmed PC+ 10 can have arbitrary sub-groups, like a committee, selectable.

Can I set up PC+ 10 to create such a .csv file as a scheduled task, either using windoze task scheduler or a built in PC+ 10 feature?

Sorry ... no. However, you can create a macro of the keystrokes within the program to create such a file, that someone can call from within the program.