Follow the instructions below to add Legislative districts using LegislativeDistrictFinder:


    • Create a query of the constituents to include in the screening

      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:

      First Name

      Middle Name

      Last Name

      Organization Name

      Constituent Import ID

      Address Import ID

      Preferred Address Line 1

      Preferred Address Line 2

      Preferred City

      Preferred State

      Preferred Zip Code 

    • Transfer the file to our FTP site
       
    • Email addressfinder@blackbaud.com when the file has been successfully transferred. Allow up to 10 business days for processing.
       
    • Once you have been notified that the files are completed, download the files from FTP into a location you can easily remember, such as to your desktop, and unzip the files. The ZIP file contains a summary report and an import file called Districts.csv
       
    • Create constituent attributes called Congressional District, State House, and State Senate with data types of Table
    • 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 solution.

      1. Import the updated data file

        1. Click Administration, Import
           
        2. Under Constituent, select Constituent Attribute and click New
           
        3. On the General tab, select:
           
          • What do you want to do?: Import new records
             
          • Options: Create new table entries
             
          • Import file: Click the ellipses (...) to browse to the location of the Districts.csv file unzipped in step 5
             
          • How do you want the system to identify existing constituents?: Import ID
             
          • What is the Format of the import file?: Delimited - Characters separate the fields
              
             
        4. Leave the File Layout tab set to the defaults
           
        5. On the Fields tab, ensure all fields are mapped
           
        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 Import Now to import the Legislative District attributes