I just took over for our church and our membership data is not up to date in our system. several years worth of items are not updated. Also, things like phone numbers have no area code in over half of our members. I exported the data to a spreadsheet. Can I update the data on the spreadsheet and then import to update? Otherwise I have to touch each record in the database to make corrections.
Is that the only way to update records?
Update Information from Spreadsheet
Moderators: Moderators, Tech Support
Re: Update Information from Spreadsheet
There is not an update import feature in Power Church.
Re: Update Information from Spreadsheet
Second message:pjones wrote:I just took over for our church and our membership data is not up to date in our system. several years worth of items are not updated. Also, things like phone numbers have no area code in over half of our members. I exported the data to a spreadsheet. Can I update the data on the spreadsheet and then import to update? Otherwise I have to touch each record in the database to make corrections.
Is that the only way to update records?
No, there is no import feature for Personal Profile updates, the only import is for Mailing List profiles as that is a primary record, all the others are child records off of the primary records. Each has an internal index, and that index is normally not known by the user.pjones wrote:There is not an update import feature in Power Church.
It may take some time to update, but in the end you can make any other correct or addition to each record as needed.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.