1. Once you have been notified that the files are completed, download the files from FTP (BB45967) into a location you can easily remember, such as your desktop, and unzip the files (BB546). The zip file contains a summary report and a data file (peoplefinderimportfile.txt). Do NOT open the TXT file.  Opening the file may cause changes within the values of the file and prevent the import from being completed successfully.
  2. Create Constituent Attributes (BB515) with the following descriptions and data types.
    Note: When prompted for a Table Name, you can scroll to the bottom of the drop-down menu and select [Add New Table].
    DescriptionData Type
    Other Last NameText
    PeopleFinder Birth YearFuzzy Date
  3. Create Address Attributes (BB515) with the following descriptions and data types.
    Note: When prompted for a Table Name, you can scroll to the bottom of the drop-down menu and select [Add New Table].:
    Description                 Data Type
    Address YearText

Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.

  1. Import the updated information:
    1. Click Administration, Import
    2. Under Constituent, select Constituent and click New
    3. On the General tab, select:
      • What do you want to do?: Update existing records
      • Options: Validate Data Only, Create new table entries
      • What file do you wish to import: Browse to and select the TXT file downloaded in step one
      • How do you want the system to identify existing constituents?: Use the Import ID
      • What is the format of this import file?: Delimited
    4. Leave the File Layout tab set to the defaults
    5. On the Fields tab, ensure all fields and extensions are mapped correctly (BB258884)

      Note: It is important to ensure the extensions for the attribute fields are mapped correctly. If they are not, exceptions will occur when importing the data file.

    6. On the Summary tab, select:
      • Create exception file of records not updated/imported: Name the file C:\Exceptions.txt
      • Create control report: Preview
      • Click Validate Now to validate the import
      • If there are no exceptions, unmark 'Validate data Only' on the General tab and click 'Update Now' to import the updated information.  If you marked to create one, the Control Report will appear on the screen when the import is completed.