Importing data
Moderators: Moderators, Tech Support
Importing data
I suspect my church will soon be moving to PowerChurch Online. I've found the .csv option for importing family data. Is there anything comparable for person data, or does all of that need to be added by hand?
If we supplied a spreadsheet, could the PC team do the import, and do you have an approximate cost for that?
thanks,
Julianna
If we supplied a spreadsheet, could the PC team do the import, and do you have an approximate cost for that?
thanks,
Julianna
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Importing data
When we receive your order for PowerChurch Online, we will have you send us a backup of the existing PowerChurch Plus data. All of your existing information will move over to the online service as-is.
Re: Importing data
Yes... but if, by some terrible accident, a backup was not available and we were starting from scratch, with a few spreadsheets?
Re: Importing data
Specifically, I have a Person export I'd like to use, but I'm not sure there's an interface for uploading that data.
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Importing data
There is the import families utility, import contributions from file, and some various other file imports added in Version 12.
Unfortunately, there still isn't an import people utility.
Unfortunately, there still isn't an import people utility.
Re: Importing data
OK, as I suspected (I'm sure there's a good reason, but it would be useful!). Is that kind of upload a service the PC team offers?
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Importing data
The problem is people in the database are linked to families by an ID number assigned by the software behind the scenes. To import people, you would either need to know the family ID numbers and have them listed in your import file, or be importing families and people at the same time, with a much more complicated file format.
There is a data conversion service, which ranges from $250 to $400 depending on which areas of the database you're wanting to have imported:
https://www.powerchurch.com/conversion
There is a data conversion service, which ranges from $250 to $400 depending on which areas of the database you're wanting to have imported:
https://www.powerchurch.com/conversion
Re: Importing data
Are you currently using Powerchurch? If so, are you not doing regular backups of the database? That's the only thing that you need to move to Powerchurch Online.
Or is there a reason you don't want to move the entire membership database?
Or is there a reason you don't want to move the entire membership database?
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Importing data
Hi, Zorak, thanks. My 'person' spreadsheet does include what I believe is that number, listed as mail_no in the export.
Re: Importing data
That's not the number that is assigned by the system. It is an internal index not usually visible to the user.jbuck wrote:Hi, Zorak, thanks. My 'person' spreadsheet does include what I believe is that number, listed as mail_no in the export.
As I asked previously, is there a reason you don't want to migrate the current database (if you're already using Powerchurch locally) to PCPlus Online? Do you need to clean the database or something like that?
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Importing data
NeilZ wrote:That's not the number that is assigned by the system. It is an internal index not usually visible to the user.jbuck wrote:Hi, Zorak, thanks. My 'person' spreadsheet does include what I believe is that number, listed as mail_no in the export.
As I asked previously, is there a reason you don't want to migrate the current database (if you're already using Powerchurch locally) to PCPlus Online? Do you need to clean the database or something like that?
Hi, Neal. Upthread I mentioned that we've had a database catastrophe, & we have no backups. I'm hoping to avoid reentering more than a thousand people manually.
Re: Importing data
You said " but say if someone " that usually means a hypothetical. Not having any backups whatsoever is going to cause you to have to manually enter all that data.jbuck wrote:NeilZ wrote:That's not the number that is assigned by the system. It is an internal index not usually visible to the user.jbuck wrote:Hi, Zorak, thanks. My 'person' spreadsheet does include what I believe is that number, listed as mail_no in the export.
As I asked previously, is there a reason you don't want to migrate the current database (if you're already using Powerchurch locally) to PCPlus Online? Do you need to clean the database or something like that?
Hi, Neal. Upthread I mentioned that we've had a database catastrophe, & we have no backups. I'm hoping to avoid reentering more than a thousand people manually.
There isn't ONE backup available?
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Importing data
I don't want to go into details here, but let's just say we aren't happy. At the moment, I'm planning to use the household CSV upload to do some of it, but the individual people will be a job and a half, not to mention whatever our bookkeeper's going to have to do.NeilZ wrote: You said " but say if someone " that usually means a hypothetical. Not having any backups whatsoever is going to cause you to have to manually enter all that data.
There isn't ONE backup available?
Any recommendations would be deeply appreciated.
Re: Importing data
FWIW .. if you have a backup from a previous version of Powerchurch, that would help. Other than than, set aside a bunch of time to enter the data. The good news is that with Powerchurch Online, you don't have to do this at the church, you can do it at home.jbuck wrote:I don't want to go into details here, but let's just say we aren't happy. At the moment, I'm planning to use the household CSV upload to do some of it, but the individual people will be a job and a half, not to mention whatever our bookkeeper's going to have to do.NeilZ wrote: You said " but say if someone " that usually means a hypothetical. Not having any backups whatsoever is going to cause you to have to manually enter all that data.
There isn't ONE backup available?
Any recommendations would be deeply appreciated.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.