Important Note: It is not recommended that the below steps be taken for records that are linked via EE/RE Integration.  Doing so will break the link between the Education Edge record and the Raiser's Edge record for the relationships that are being added as Constituents. 
 
  1. Create a static, query of the relationship records
    Create a static, relationship query to pull the relationships to add as constituents. The query filters will vary based on the relationships you want to select. For example, if you want to query on all non-constituent relationships, query on Relationships, Individuals, This Individual Is a Constituent equals No.
     
  2. Export information from the relationship record
    1. Create an individual relationship export.
    2. In the Export format field, select Comma-Separated Values.
    3. Unmark Include Header.
    4. Click Create Now.
    5. On the General tab, click Include, Selected Records and select the query created in Step 1.
    6. On the Output tab, export the following fields in order:
      • Title 1
      • First Name
      • Last Name
      • Suffix 1
      • Spouse?
      • Is head of household
      • Reciprocal
      • Relationship
      • Constituent, Constituent Information, Import ID
Note: You may export additional fields as needed such as address and phone numbers. These are the minimum fields required to create the Constituent record. 
 
  1. Create a Constituent Import file
View a sample data file (GlobalAddConst.CSV), which imports new constituent records for Wendy Hernandez, wife of Robert Hernandez, and Patrick Nelson, son of Porter Nelson, and reciprocates the relationships. You may need to widen the columns to view all of the information in a column. The sample file was tested in version 7.80.1122. Other versions may vary slightly in the available fields.
 
  1. Open Excel.
  2. Open the file created in Part II.
  3. Insert two blank columns in columns A and B.
  4. Add the following headers in order starting with column A:
    • ImportID
    • KeyInd
    • Titl1
    • FirstName
    • LastName
    • Suff1
    • IRIsSpouse
    • IRIsHH
    • IRRelat
    • IRRecip
    • IRLink
  5. In the ImportID column, assign constituent import IDs.
  6. In the KeyInd column, enter I (for individual) in the first row and copy it down for all records.
  7. When importing nonconstituent spouses (for example, Wendy Hernandez), assign Yes to the IRIsHH field to have the existing constituent (Robert) be the head of household. Assign No if you want the relationship (Wendy) that is being added as a constituent to be the head of household. Refer to BB520345 for information on how head of household processes.
  8. Move the IRLink field before all of the other IR fields in your import file.  The IRLink field must precede all other Individual Relationship fields, or an exception will occur when importing.
  9. Click File, Save from the menu bar.
  10. Click Save.
  11. When prompted that the file already exists, say Yes to replace the file.
  12. When prompted that the file may contain some features that are not compatible with this format, click Yes to save anyway.
  13. Close the file.
  14. When prompted to save changes, click No.
Note: For information on what each of these fields mean and the value needed for each, refer to the Import User Guide. If you have address and phone number information you will be importing as well, please refer to How to import Constituent name, address, and phone numbers including multiple phone numbers and email addresses.
  1. Import the Constituent Import file.
    1. Click Admin, Import
    2. Highlight Constituent in the Constituent node.
    3. Click New Import.
    4. On the General Tab, select or mark the following:
      What do you want to do? Import new records
      Mark the checkbox: Automatically Reciprocate Relationships What file do you wish to use? Browse for the file created in Step III
      Note: Set Files of type to All Files(*.*) to show all file types
      How do you want the system to identify existing constituents? Use the Import ID
      What is the format of this import file? Delimited - Characters separate the fields
    5. On the File Layout tab, leave everything set to the defaults.
    6. On the Fields tab, the mapping should automatically fill in.
    7. On the Summary tab, mark the Create Control Report option and select Preview
    8. Click Import Now.
       
  2. Delete the duplicate relationships
    1. Click Admin, Globally Delete Records.
    2. On the General tab, select Relationships as the Record Type.
    3. Click Include, Selected Records and select the query created in Step 1.
    4. Select or mark the following:
      • What do you want to do? Delete records
      • How do you want to see the results? Create a control report (Preview)
    5. On the Delete Options tab, highlight one entry on the left-hand side, and click the double arrows moving all entries to the right-hand side.
    6. Click Delete Now.
Note: This process will cause the deleted spouse to no longer be linked between Education Edge and Raiser's Edge.

Note: If you need to soft credit the new constituent records for the existing gifts made by the relationship, refer to How to import soft credits