Simple Family Example

Here is a simple family example with two files to import:
  • FamilyBasicInfo.csv contains envelope number, name, and address information.
  • FamilyHomePhones.csv contains the primary home phone number for each family.
Figure 1. FamilyBasicInfo.csv
Example file showing the headers Fam Key, Env Num, Last, First, Title, Street Address, City, State, and Zip with data in the cells below
Figure 2. FamilyHomePhones.csv
Example file showing the headers Fam Key, Number, and Unlisted with data in the cells below

Matching the Data

Notice how every row in the FamilyHomePhones file contains a FamKey that corresponds to the matching family (with the same FamKey) in the FamilyBasicInfo file.

Both of your files must contain a column that has a unique identifier like FamKey. This identifier matches the phone number from the second file with the appropriate family in the first file. This is a much more reliable method than trying to match rows based on name. For example, there can be multiple families with the same name in your file, or the names might not be entered exactly the same in both files.

Identifying the Import Key

When you process the first file, identify the identifier column as the "Import Key". This stores the Import Key as a hidden field in the database that's used when you process the second file. When processing the second file, you are updating existing family records rather than creating new families. In the Import Family Information process, check the Advanced Options dialog box to enable the features for updating existing records.

Tip:

After reviewing this section, if you don’t feel confident about how these apply to your file(s), contact PDS Support at 1-877-737-4457. Fees may apply.