What is the most efficient way to export all my contact data from PowerChurch into an excel or CSV file?
I've been trying to figure it out, but have had no luck getting all my data in one file.
Exporting All Contact Data
Moderators: Moderators, Tech Support
-
mpritchard
- Posts: 1
- Joined: Wed Apr 09, 2008 4:17 pm
- Location: Alexandria, VA
- Contact:
Re: Exporting All Contact Data
Exactly what are you trying to export ??? Mailing LIst or Personal Profiles ??mpritchard wrote:What is the most efficient way to export all my contact data from PowerChurch into an excel or CSV file?
I've been trying to figure it out, but have had no luck getting all my data in one file.
Have you looked at the 'Export Data' feature located under each area ??
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Exporting All Contact Data
I am also trying to export both personal profile and family profile into excel format. But am having no luck.
I want it in column format, so I am doing it under Custom reports, and choosing my output fields, I run query and get results, but when I go to export it from the Utilities menu, it emerges as a zip file. when I open that it is a DBF or frt file that I cannot open.
I want it in column format, so I am doing it under Custom reports, and choosing my output fields, I run query and get results, but when I go to export it from the Utilities menu, it emerges as a zip file. when I open that it is a DBF or frt file that I cannot open.
-
Zorak
- Tech Support
- Posts: 3105
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Exporting All Contact Data
The import/export function you are using is to move your custom reports to another installation of PowerChurch Plus.
To create an excel file from a custom report, select the report, then click the Pick Output Type button. You can then tell it that you want the report to be generated as an excel file. This will be saved in the PowerChurch Plus program directory.
For what it's worth, the Export Data option under the Personal Profiles menu will do exactly what you need. It gives you the same list of fields from Family Mailing List and Personal Profiles that the custom reports in Personal Profiles do. And, you have the benefit of getting to name the export file and choosing where to save it.
To create an excel file from a custom report, select the report, then click the Pick Output Type button. You can then tell it that you want the report to be generated as an excel file. This will be saved in the PowerChurch Plus program directory.
For what it's worth, the Export Data option under the Personal Profiles menu will do exactly what you need. It gives you the same list of fields from Family Mailing List and Personal Profiles that the custom reports in Personal Profiles do. And, you have the benefit of getting to name the export file and choosing where to save it.