Update Information from Spreadsheet

Family Mailing List, Personal Profiles, Activities and Skills, Attendance, Visitations

Update Information from Spreadsheet

Postby pjones » Tue Sep 25, 2018 8:59 am

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?
pjones
 
Posts: 2
Joined: Tue Sep 25, 2018 8:52 am

Re: Update Information from Spreadsheet

Postby pjones » Tue Sep 25, 2018 1:28 pm

There is not an update import feature in Power Church.
pjones
 
Posts: 2
Joined: Tue Sep 25, 2018 8:52 am

Re: Update Information from Spreadsheet

Postby NeilZ » Tue Sep 25, 2018 3:44 pm

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.

Neil Zampella

Using PC+ since 1999.
NeilZ
 
Posts: 9011
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA