The Mergician makes merging multiple records simple.

Available only to self-hosted users, it:


  • Uses Raiser’s Edge duplicate criteria, simple email deduping or a more complex IDLookup criteria set dedupe.
  • Allows you to create a merge file which can then be fed in to merge each pair of constituents
  • Cleans up any duplicate attributes, codes, gifts, after the merge too!


Please register or login to ZeidZone to download the product


Filter Merge Fields

  • You can decide which areas of the constituent you want to merge
  • Filter the records to merge so that records with a specific constituent code or attribute will not be merged
  • Add an attribute to the secondary record so you can delete it later
  • You can also add the Id of the secondary, deleted constituent as an alias on the primary constituent

Clean up

  • You can add the merged areas as a notepad on the merged record
  • Clean-up functionality enables you to delete duplicate gifts, attributes and address information during the merge

Deduping using multiple criteria

  • Dedupe Raiser’s Edge using the power of IDLookup criteria sets
  • Select from an large range of fields, There is no need to rely on Raiser’s Edge when you can apply your own logic to the deduplication process


  • You can exclude all constituents from the merge file based on a query
  • Also include constituents and their corresponding merge constituent in the merge file based on a query

Output file

  • Configure your duplicate output fields exactly as you would like them
  • You are able to add almost any field on the constituent record as well as summary fields

RE 7.94

  • Handle phones, emails and links that are no longer tied to addresses
  •  You are also able to clean up duplicate phones following a merge

IDLookup Dedupe

  •  IDLookup Dedupe means you can dedupe the whole database without exporting it
  • Using a wide range of fields, soundex of those fields, field equivalents and any combination of all of the above

Testing The Mergician

You can test The Mergician on your production database, however you are limited to merging only two records per merge. Of course, you can merge as many as you want in the sample database.