Duplicate Detection on Data Import (.csv file) not working

(0) Share

Report

Posted on by Joe Woltering

12,159

I am trying to import a list of Contacts with email addresses. I have a Duplicate Detection rule set on the Email field which works when trying to add a new Contact manually. However, when I perform the import from the .csv file, detection does not work and a duplicate is created.

*This post is locked for comments

All responses (6)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Duplicate Detection on Data Import (.csv file) not working

Hello, did you ever get this issue resolved, as I seem to be having the same problem? Thanks.
Joe Woltering 12,159 on at

Like (0)

Report

RE: Duplicate Detection on Data Import (.csv file) not working

Hi all,

Yes, I have enabled both of these options (both under Data Management and during the Import process). As I mentioned, duplicate detection does work on create or update of existing records, just not during an import.
LuHao 40,872 on at

Like (0)

Report

RE: Duplicate Detection on Data Import (.csv file) not working

Hi Joe,

You need to confirm two things.

1, Please go to Setting > Data Management > Duplicate Detection Settings, check Enable duplicate detection.

2, During the process of uploading your file, please select No under Allow Duplicates.

Hope this helps.

Best Regards,

Lu Hao
Suggested answer

Rawish Kumar 13,756 on at

Like (0)

Report

RE: Duplicate Detection on Data Import (.csv file) not working

might be a silly question but i want to just check -- did you enable the option once you import CSV as "Allow duplicates" on the last preview page before you click on submit?
Joe Woltering 12,159 on at

Like (0)

Report

RE: Duplicate Detection on Data Import (.csv file) not working

Yes, I have checked this. It is enabled.
gdas 50,085 on at

Like (0)

Report

RE: Duplicate Detection on Data Import (.csv file) not working

Hi Joe,

Please check whether you enable Duplicate Detection During Data Import by navigating Settings-> Data Management-> Duplicate Detection Settings and ensure that the Enable Duplicate Detection During Data Import option is selected.