Replacing Constituent IDs When Switching CRMs

Overview

When your institution migrates to a new CRM, the constituent IDs in GiveCampus remain linked to your previous system. Simply importing new IDs on top of existing records creates duplicate constituent records. This article explains the correct process for replacing constituent IDs during a CRM transition.

Why the Constituent ID Backfill Tool is not Suitable

The Constituent ID Backfill Tool links past gift records to constituent IDs by matching on email address. It works on a separate email-to-ID mapping table and does not update the constituent record directly. This makes it unsuitable for a CRM migration because:

• It updates gift-to-ID links, not the constituent record. The tool maps email addresses to external IDs to associate gifts, but it does not replace the constituent ID on the record.
• Email matching is unreliable. Multiple emails or shared email addresses can cause incorrect matching.

The Correct Approach: Constituent ID Replacement

Replace constituent IDs with a direct ID-to-ID swap using a two-column CSV file. This approach does not rely on email matching and preserves all associated giving history.

What the replacement does

• Replaces the old constituent ID with the new one in constituent records, relationships, and gift history.
• Maintains all giving history linked to each constituent.
• Avoids data loss that would occur if constituent records were deleted and reimported.

Validation before applying changes

Before the swap, the system validates your CSV file. It will:

• Reject the file if any new constituent ID appears more than once.
• Abort the process if the mapping would result in duplicate IDs in GiveCampus.

No changes are made until the file passes all validation checks.

Preparing Your File

Create a CSV file with exactly two columns:

Include one row per constituent whose ID is changing. Do not repeat any constituent or new IDs within the file.

Step-by-Step Process

1. Prepare your CSV. Create a two-column file of old-to-new constituent ID mappings.
2. Submit the file to GiveCampus. This process must be performed by GiveCampus staff. Send your CSV to your GiveCampus contact to begin the procedure.
3. The system validates and executes the swap. GiveCampus verifies the file and replaces all old IDs with the new IDs across constituent records, relationships, and gift history if validation is successful.
4. Update your Data Importer configuration. After the swap, adjust your Data Importer to map the constituent ID column from your new CRM's file to the Constituents ID field in GiveCampus.
5. Upload your updated constituent file. Complete the migration by importing the full constituent file with new IDs.

Frequently Asked Questions

Will giving history be lost? No. The swap is performed in place, so all giving history remains attached to each record.

What if I delete and reimport constituent records instead? Deleting and reimporting results in the permanent loss of giving history. The replacement process is preferred to maintain data integrity.

What happens if the file fails validation? No changes are made. Correct the file errors (such as duplicate new IDs) and resubmit.

Does this work if constituents share an email address? Yes. The process matches on constituent ID rather than email address, so shared emails do not affect the outcome.