CompanionLink Support Center

Remove Duplicates With CompanionLink

CompanionLink 8.0 added a new duplicate removal feature for Google, Custom Exchange, DejaCloud, Outlook, and ACT!.

How to Remove Duplicates on your PC with CompanionLink 8

NOTE: Remember to backup your database before attempting a dedupe!

1. Download CompanionLink 8.0 Here and install.
2. Open CompanionLink and configure for your Database and sync method
3. Select Settings on the left.
4. Select Dedupe [Database] (ie, ACT!, Outlook, etc) on the left.
5. Check the conduits to dedupe > Select OK
Dedupelist.PNG


NOTE: After the deduplicating process is complete, perform a wipe and reload from your PIM database. This will clear the target database and reload the PIM data that has just been cleaned.

Deduplicate Advanced Options


DeDupeAdvanced.PNG
Sometimes duplicated data is messy and you require advanced help to clean it all up.

Ignore times on date comparisons

  • Enabling this feature will remove calendar duplicates that occur at different times of the day. (Often caused by an incorrect timezone setting)
  • Enabling this feature will remove duplicates that contain varying special characters

Keep First Retrieved" vs "Keep Oldest Modified

  • Both these options attempt to the earliest record available in the database, they just do so in different ways.
  • "Keep First Retrieved" refers to keeping a record with the lowest record ID
  • "Keep Oldest Modified" refers to keeping a record that has the oldest modified date/time

Limits

  • In cases where dedupe fails or times out due to a large number of duplicates (100k+ dupes), this feature will limit the number of records deduped each attempt.

Delete DAT Files

  • Enabling this will delete the files that have recorded your previous syncs and trigger CompanionLink to read over all the data again. Generally, you want to leave this feature enabled.




How to Remove Duplicates on your PC with CompanionLink 7

1. Download CompanionLink 7.0 (7038 or above) Here and install.
2. Open CompanionLink and configure for your Database and sync method
3. Select Options
4. Select Dedupe [Database] (ie, ACT!, Outlook, etc)
Main Menu Dedupe.PNG
5. Check the conduits to dedupe > Select OK


Dedupelist.PNG


NOTE: After the deduplicating process is complete, perform a wipe and reload from your PIM database. This will clear the target database and reload the PIM data that has just been cleaned.

Deduplicate Advanced Options


DeDupeAdvanced.PNG
Sometimes duplicated data is messy and you require advanced help to clean it all up.

Ignore times on date comparisons

  • Enabling this feature will remove calendar duplicates that occur at different times of the day. (Often caused by an incorrect timezone setting)
  • Enabling this feature will remove duplicates that contain varying special characters

Keep First Retrieved" vs "Keep Oldest Modified

  • Both these options attempt to the earliest record available in the database, they just do so in different ways.
  • "Keep First Retrieved" refers to keeping a record with the lowest record ID
  • "Keep Oldest Modified" refers to keeping a record that has the oldest modified date/time

Limits

  • In cases where dedupe fails or times out due to a large number of duplicates (100k+ dupes), this feature will limit the number of records deduped each attempt.

Delete DAT Files

  • Enabling this will delete the files that have recorded your previous syncs and trigger CompanionLink to read over all the data again. Generally, you want to leave this feature enabled.