Collapse AllExpand All

9.3.  Contact Merge

If you are importing Contact information—either through the xTuple web Portal or xTuple Email Integration or some other feature—it's likely you will encounter duplicate Contact records. The Contact Merge utility is designed to help you resolve this scenario. Using the Contact Merge utility, you can easily locate duplicate records and merge them into one single Contact record. In this way you can also preserve multiple email addresses for your Contacts.

Tip

How-to information about using the Contact Merge utility is available on our community website here: www.xtuple.org/contactmerge.

To begin using the Contact Merge utility, select the "Contact Merge" option. The following screen will appear:

Contact Merge Utility

When using the Contact Merge utility, you are presented with the following options:

Mode

Select one of the following modes to expedite processing:

Merge

Allows the user to query Contacts using the specified search criteria. Merges all source Contact selections when "Merge" is clicked.

Purge

Displays all merged Contacts. Purges all merged Contacts at once when "Purge" is clicked.

Merge and Purge

Allows the user to query Contacts using the specified search criteria. Merges and purges source Contacts in one step when "Merge and Purge" is clicked.

Restore

Displays all merged Contacts. Restores all merged Contacts at once when "Restore" is clicked.

Search for:

Enter search terms or patterns to locate the Contact records you are looking for.

Search Through

Specify which of the search filters you want to be included when you are searching for Contact records.

Find duplicates with matching criteria

Select if you want the Contact Merge utility to automatically locate duplicate records using search criteria you specify with your selections.

Contacts

Display lists Contact records matching the search criteria you specified. In this display you mark Contacts you want to merge as either "source" or "target" Contacts. When merging Contact records, source Contacts are merged into target Contacts—leaving behind only the target Contact record.

In addition to the basic Contact references, specific data elements of a source Contact may also be carried over to the merged target Contact—information such as the notes, phone numbers, or the email address. To select these specific data elements for merging, go to the "Selections" tab":

Selected Contacts

When merging specific data elements for selected Contacts, you are presented with the following options:

Source Contacts

Displays any Contact records you specified as source Contacts on the "Contacts" tab. If you right-click on any of the cells of the Source Contacts list, you can choose to merge that cell to the target Contact. The cell's contents will turn blue when selected.

Target Contact

Displays the target Contact record. When you merge Contacts, the target Contact record will receive the specified data elements selected in the source Contact(s) records.