Create and submit a data file to Blackbaud containing the records to be screened:
     
    • Create a query of the constituents to include in the screening. If you wish to only include Constituent's with Non-constituent Spouses, follow BB729958.

      Note: All records need to have a name and at least one address line. We recommend running an AddressFinder screening prior to this service so that all addresses are current and in a standardized format.
       
    • Using the selected records from your query, export the following fields in CSV (comma-separated values) format:
      • Spouse First name
      • Spouse Middle Name
      • Spouse Last name
      • Spouse Address Line 1
      • Spouse Address Line 2
      • Spouse City
      • Spouse State
      • Spouse Zip Code
      • Constituent Import ID
        Retrieve the file:
         
        Use the import file to update constituent records:
           
          1. Add the attribute to be entered in configuration
            1. In Configuration, click Attributes
            2. Create a new constituent attribute
            3. Enter AgeFinder_Spouse as the attribute description
            4. Enter Fuzzy Date as the Data Type
               
            • Import the attributes to the constituent records:

              Note: For complete instructions, refer to How to import constituent attributes (BB8670)
               
              1. In Administration, click Import Records and create a new Constituent Attribute import
              2. Browse out to the location of the unzipped import file in the What file to you wish to import? field
              3. Leave the File Layout tab set to the defaults
              4. On the Fields tab, ensure all fields are mapped
              5. On the Summary tab, mark the Create exception file of records not updated/imported checkbox and name the file C:\Exceptions.txt and mark the Create control report checkbox and select Preview
              6. Click Import Now to import the age information

            Export out Spouse Birthdates:
             
            1. Create a Constituent export in CSV format with the following fields:
              • Biographical, ImportID
              • Spouse, Biographical, Relationship ImportID
              • Attributes, AgeFinder_Spouse, Description 
               
              • Save this file locally to you workstation
                 
              • Change the headers in this CSV file to read as follows
                • Import ID = ImportID
                • Spouse Relationship Import ID = SRImpID
                • Description (Birthday) = SRBday
                   
                Import the birthdates into the spouse record:
                  1. In Administration, click Import Records and create a new Constituent Spouse import
                     
                  2. Browse out to the location of the unzipped import file in the What file to you wish to import? field
                     
                  3. Leave the File Layout tab set to the defaults
                     
                  4. On the Fields tab, ensure all fields are mapped
                     
                  5. On the Summary tab, mark the Create exception file of records not updated/imported checkbox and name the file C:\ExceptionsSpouse.txt and mark the Create control report checkbox and select Preview
                     
                  6. Click Import Now to import the age information