Manage Duplicate Records

Click the pencil icon next to the Duplicate Records item on the migration tab to open the duplicate settings.

If you don’t need to check for duplicates, don’t enable duplicates features. It slows down the import process.

Next, select how you would like to handle duplicates: Skip, Overwrite, or Allow. Then, check the box next to the columns that you would like to check for duplicates. For example, when importing contacts to a contacts list, you may choose to check the email address to determine if a record is a duplicate.

NOTE: If the target is a Picture or Document Library, users can only check for duplication based on the target column Name, which is the file name because a file with the same name cannot be imported twice to the same library.

If overwriting duplicates with attachments, toggle the Bamboo Recycle Bin Clean Up Utility with the checkbox. The Clean Up utility will move the overwritten attachments from the site recycling bin into the server recycling bin, saving valuable database space.

Learn more about installing and using the Clean Up application.

IMPORTANT: When updating items with attachments, the current attachments are removed and the files in the source file replace them.
For example, if the list item called Green title exists with an existing attachment called Sample1.docx, the import/update process will remove the existing attachment called Sample1.docx and replace it with a file called green.jpg.

Once all of the columns are selected and the duplication rule is set, click OK.