Finding and merging duplicates

In bpm’online sales, you can search for duplicates and eliminate them in order to better manage your customer database. This functionality is available in the [Accounts] and [Activities] sections.

When creating new records, the system automatically checks for duplicates. You can also schedule periodic duplicates searches for contacts and accounts.

For the [Accounts] section, the search is done by values in the [Account name] and [Also known as] fields, as well as in the fields from the [Communication options] detail. For the [Contacts] section the duplicates search is done by values in the following fields: [Contact name], [Mobile phone], [Home phone], [Skype], and [Email]. The record is considered to be a duplicate in case the value at least in one of the mentioned fields is completely identical to the corresponding value in another record.

On the duplicates page, you can perform the following actions for accounts and contacts:

   Launch a duplicate search and join or delete any of the resulting duplicate records if found.

   Set up the parameters of a duplicates search.

Contents

   Starting the duplicates search

   Handling the duplicates

   Merging the duplicated records

Starting the duplicates search

1.   Open the [Accounts]/[Contacts] section.

2.   Select the [Find duplicates] option from the [Actions] menu (Fig. 87).

Fig. 87 Opening the duplicates search page

chapter_finding_duplicate_act_finding_duplicate.png 

3.   Click the [Start searching] button on the accounts/contacts duplicates page.

As a result, the system will start searching for duplicates. The information string will display the percentage of the processed records.

Handling the duplicates

Once the duplicates search is completed, the accounts/contacts duplicates page will display all the duplicates found. Process these records: distinguish unique records from duplicates and remove the duplicates.

To analyze the records found:

1.   Open the [Accounts]/[Contacts] section.

2.   Select the [Find duplicates] option from the [Actions] menu.

3.   On the duplicates page for accounts/contacts, find the record that should be processed.

4.   Click btn_com_expand.png to open the list of possible duplicates for this record.

5.   Analyze whether these records duplicate the information in the root record (Fig. 88).

Fig. 88 Possible duplicates of the selected record

chapter_finding_duplicate_supposed_doubles.png 

6.   Process the possible duplicates of the root record:

Option 1. The subordinate record is not a duplicate

a.   Select the root record and the subordinate one.

b.   Click the [Not duplicates] button (Fig. 89).

Fig. 89 Indicating records as unique

chapter_finding_duplicate_set_different_record.png 

As a result, the selected subordinate record will be removed from the duplicates list and will no longer be used in searching for duplicates of the root record.

Option 2. The subordinate record is a duplicate

a.   Select the root record and the subordinate one.

b.   Click the [Merge duplicates] button.

c.   Perform the duplicates merging.

As a result, the system will contain only one record. All objects that have been connected to the merged records will now be connected to this record. For example, if you are merging two accounts and there are a few tasks connected to the first account and some contacts connected to the second one. After you merge these two accounts, the tasks from the first record and the contacts from the second one will be combined in the resulting merged record.

Merging the duplicated records

1.   Open the [Accounts]/[Contacts] section.

2.   Select the [Find duplicates] option from the [Actions] menu.

3.   On the duplicates page of the accounts/contacts, select the records that should be merged.

4.   Click the [Merge duplicates] button.

5.   The duplicates merging page of the accounts/contacts will open. Select the data display mode, for example, “Only fields with different values” (Fig. 90).

Fig. 90 Selecting the data display mode

chapter_finding_duplicate_display_different_values.png 

6.   Choose the corresponding radio button btn_radiobutton.png to select the values that should remain in the system after merging (Fig. 91).

Fig. 91 Selecting the resulting values

chapter_finding_duplicate_merge_similar_records.png 

7.   If necessary, edit the information in the [Communication options] and [Addresses] details.

8.   Click the [Save] button to complete the merging of duplicates.