Page 1 of 1

Update Information from Spreadsheet

Posted: Tue Sep 25, 2018 9:59 am
by pjones
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?

Re: Update Information from Spreadsheet

Posted: Tue Sep 25, 2018 2:28 pm
by pjones
There is not an update import feature in Power Church.

Re: Update Information from Spreadsheet

Posted: Tue Sep 25, 2018 4:44 pm
by NeilZ
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?
Second message:
pjones wrote:There is not an update import feature in Power Church.
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.

It may take some time to update, but in the end you can make any other correct or addition to each record as needed.