Combine Contacts Tool
With the Combine Contacts Tool, you can combine separate Contact records into a single record. You can also add a similar-to relationship to Contact records.
- The Tool is available on the Contacts page and any filtered version of the Contacts page. You can launch it from an open record or the Grid Layout, with or without a selection of records.
- SPoCs should regularly use the Combine Contacts Tool to keep data clean.
- The drop-down list shows potential duplicate Contacts that you can choose from.
- If you launch it for an open record, that record displays at the top of the list. Additional potential duplicates display after the open record.
- If you launch it from a selection of at least two records, the selected records display at the top of the list. Additional potential duplicates are listed after the selected records.
- If you launch the tool from the grid without making a selection, you can make a selection from the list of potential duplicates. These are only potential duplicates, so don't be surprised if the list is long. Be sure to check the Duplicates view on the Contacts Relationships page to see actual duplicate Contact records.
- Each column displays data fields from the Contact record, as well as from any associated Household, Participant, Donor, and User records. Each field is listed as its own row, but only fields that are populated on at least one of the loaded records will display. This means the Tool may show different lists of fields depending on the records you compare and how much data they contain.
- The Donor, Household, and User records you select in the grid are kept and associated with the newly-merged Contact record. Those that are not selected are merged or eliminated.
- If you select a different Address and/or Congregation in the merge process, these changes reflect in the Household selected in the Tool.
- If any unselected Household(s) become empty as a result of the elimination of a Contact record through the merge process, the newly-empty Household(s) is eliminated.
- The Audit Log records any changes made to the kept record as a result of combining.
- Need to find more duplicates? Check the Duplicates view on the Contacts Relationships page to see actual duplicate Contact records.
- The Tool combines Contact, Participant, Donor, and User records. It does not combine Household or Sacrament records. Need to combine Households? Check out the Combine Households Tool for more information. If the contacts have conflicting Sacrament records, you'll see a warning that lets you know which Sacrament record(s) need to be cleaned up later.
Combine Contacts
- One of the email addresses is invalid and/or has a comma in it.
- The Users are part of the same User Group.
- The Users are in the same Security Role.
- The Users have an Identity record with the same Provider Name.
- The Contact has a comma in the Suffix or Last Name fields.
- If Contacts both have attached images, the default file displays twice and the Record displays twice.
Before combining contacts, edit the records so the above scenarios are no longer true, then run the tool again.
As a part of this process, any Participant and Donor Notes combine into the surviving record. The tool automatically shortens values that exceed the default field length.
Handle Contacts that Aren't Duplicates
Occasionally the system or a user may incorrectly identify records as duplicates, such as a father and adult son who have the same name. When you indicate the records as "similar records", it tells the system and other users to ignore these as possible duplicates.
- Clear the selected records.
- Select Mark un-selected records as similar to merged record.
- Click Combine Contacts.
- Open one of the Contact records.
- Go to the Relationships sub-page.
- Click New.
- Choose the Similar Records relationship.
- Indicate the appropriate Related Contact.
- Click Save.
Accidentally Combined Contacts
Deleted data is not stored anywhere. If you accidentally combine contacts, the only way to retrieve the information is for a SPoC or Professional Services to restore a database backup from before the merge took place. You should act on this quickly since backups may be limited to a recent time frame. Depending on your backup strategy, this could be as little as two weeks. Admins, it may be helpful to review the Delete Record Research Report (accessible from ) to identify any records deleted in error.
Handle Contacts with "APIUser (Do Not Edit)" in the Audit Log
Sometimes records duplicate as a result of someone creating a Portal account. Any record created by the Portal will indicate the user "APIUser (Do Not Edit)" in the Audit Log. You can use the Combine Contacts Tool on these duplicate records. The "Do Not Edit" notation lets you know that you shouldn't edit the APIUser record itself, but you can edit records created by the APIUser.