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. Export the import ID, constituent ID, last name, and key indicator
  2. Edit the file in Excel and renumber the constituent IDs as needed
  3. Save the file in CSV format
  4. In The Raiser's Edge, navigate to Admin, Import
  5. Import the file back into The Raiser's Edge selecting the following options on the General tab:
    • What do you want to do? - Update existing records
    • What file do you wish to import? - Select the file from step 3
    • How do you want the system to identify existing constituents Import ID
    • What is the format of this import file? - Delimited