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. Create a constituent query and filter on Relationships, Individual, This Individual is a Spouse = Yes
  2. Create an constituent export in Comma-Separated Values using the query created in step 1
  3. Export the following fields:
    • Biographical, Import ID
    • Biographical, Last Name
    • Spouse, Biographical, Relationship Import ID
    • Spouse, Biographical, Last Name
    • Spouse, Biographical, Gender
  4. Open the file in Excel and add the correct gender information.
  5. Click Import
  6. Highlight Constituent and click New
  7. Pick the file above and select the option to Update Existing Records
  8. Select the Fields Tab and map the fields
  9. Click Update Now