Identifier

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Moderators: Moderators, Tech Support

Post Reply
Faith Community Church
Posts: 2
Joined: Wed Jun 20, 2007 1:45 pm
Location: Delaware
Contact:

Identifier

Post by Faith Community Church »

I am running windows xp and powerchurch 9
my question is .... I need to export data into excel to transfer to another database for the library.
My problem is that I need for each person to have a single identifier so that when i go to do updates for the library it will update each person individually. Thank you, Nancy
Nancy Saba
Faith Community Church
PO Box 1
2240 South DuPont Highway
Camden, DE 19934
302-697-1673

Zorak
Tech Support
Tech Support
Posts: 3100
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Post by Zorak »

Internally, the program uses a combination of two fields for the unique identifier for each person. In the export field list, choose "Mail_No", which is an internal family number and "Directory Sequence", which is the person number within the family.

There will be no two people that have the same combination of these two fields.

Excel will allow you to use a formula to concatenate these two fields together into one if you need them to be identified in a single field.

Faith Community Church
Posts: 2
Joined: Wed Jun 20, 2007 1:45 pm
Location: Delaware
Contact:

Unique identifyer

Post by Faith Community Church »

Thank you this worked. I finally got what i needed. :D
Nancy Saba
Faith Community Church
PO Box 1
2240 South DuPont Highway
Camden, DE 19934
302-697-1673

Post Reply