Navigation:  »No topics above this level«

About Duplicates

Previous pageReturn to chapter overviewNext page

A duplicate item in the QuickPort/DataPort/MultiPort products is defined as any record that has identical values in the <Update Key Fields> defined for any import mode that requires specifying <Update Key Fields> which includes <Update>, <Add Ignore or Replace Dupes> and <Delete> import modes.

 

Duplicates can exist in both the data file being imported from (Source) and in the contact folder where items are being imported to (destination).

 

The existence of duplicate items can have a significant impact on the end results.

 

Using an example where the <Update Key Field> is defined as being the Email Address (purely for the sake of simplicity - any fields and any number of fields can be defined as <update key fields) and the following values found in both the input data file and Outlook contact folder:

 

Input Source:

 

Rec#1: <abc@def.com>

Rec#2: <abc@def.com>

Rec#3: <bcd@ccc.com>

Rec#4: <def@ddd.com>

Rec#5: <def@ddd.com>

 

Outlook contact folder (destination):

 

Rec#1: <abc@def.com>

Rec#2: <bcd@xxx.com>

Rec#3: <def@ddd.com>

Rec#4: <def@ddd.com>

Rec#5: <xcv@fdf.com>

 

The following update process will occur for each of the records in the input data file:

 

Rec#1: <abc@def.com> - will update Rec#1 in the Contact folder

Rec#2: <abc@def.com> - will update Rec#2 in the contact folder

Rec#3: <bcd@ccc.com> - will be added to the contact folder since no match is found depending on                                           the option selected.

Rec#4: <def@ddd.com> - will update Rec#3 & 4 in the contact folder

Rec#5: <def@ddd.com> - will update Rec#3 & 4 in the contact folder

 

*** in the case where the same contact item is updated multiple times within the same import run, the values in the Outlook contact item that will be checked to determine if there is a difference in field values between source and destination will be the last values that have been applied to the contact item. Specifically, when Rec#4 from the Input Data Source updates the contact items in the contact folder, the contact item will contain whatever values were applied after Rec#3 from the Input Data source was applied.