In the past our church has manually maintained a membership directory in an Excel spreadsheet. Since migrating our directory online, the information is kept much more up-to-date... but only when pulling up our directory page. Many members still wish to download a current spreadsheet for offline use.
I understand how to export a current copy of the member database using the button on the members & contacts page. However, my account is an admin on our site but does not have access to the page the button is on, so I haven't been able to give it in-depth study. Furthermore, I wish to automate reporting to update the downloadable spreadsheet weekly and offer a download link on our directory page. So far I have not found the names of the variables to retrieve, or how best to retrieve them.
I would prefer to automatically delete all but a few fields, such as name, address, phone number and email after the report is generated.
Has anyone heard of a script to do this? Also, where on the site should I upload it to run periodically?
RedEye
In the past our church has manually maintained a membership directory in an Excel spreadsheet. Since migrating our directory online, the information is kept much more up-to-date... but only when pulling up our directory page. Many members still wish to download a current spreadsheet for offline use.
I understand how to export a current copy of the member database using the button on the members & contacts page. However, my account is an admin on our site but does not have access to the page the button is on, so I haven't been able to give it in-depth study. Furthermore, I wish to automate reporting to update the downloadable spreadsheet weekly and offer a download link on our directory page. So far I have not found the names of the variables to retrieve, or how best to retrieve them.
I would prefer to automatically delete all but a few fields, such as name, address, phone number and email after the report is generated.
Has anyone heard of a script to do this? Also, where on the site should I upload it to run periodically?