function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Darshan Desai 19Darshan Desai 19 

Which tool can automatically prevent duplicate records?


Hi All ,

Which tool can automatically prevent duplicate records?
A. Import Wizard
B. Connect for Office
C. Excel Connector
D. Data Loader

Help me to choose right ans.


Regards ,
Darshan Desai

 
Best Answer chosen by Darshan Desai 19
Amit Chaudhary 8Amit Chaudhary 8
Please check below document
1) http://resources.docs.salesforce.com/200/20/en-us/sfdc/pdf/salesforce_import_cheatsheet.pdf

1. From Setup, enter Data Import Wizard in the Quick Find box, then select Data Import Wizard.
2. Click Launch Wizard!
3. Follow the instructions on the wizard screens. The import process involves these steps:
• Upload the CSV import file into the import wizard.
• Define the matching criteria that the wizard uses to avoid importing duplicate accounts or contacts.
• Map the columns in the import file to the desired Salesforce fields. When you finish the wizard, the import file is placed in a queue for processing. Import files are processed in the order in which they are received. You receive an email when the import completes.

 

All Answers

Amit Chaudhary 8Amit Chaudhary 8
Import Wizard
 
Srinivas AnnamSrinivas Annam
Import Wizard can automatically prevent duplicate records.
Darshan Desai 19Darshan Desai 19

Can you please explain the logic? I can't find the option.

Import wizard is inserting duplicate records here :(

Amit Chaudhary 8Amit Chaudhary 8
Please check below document
1) http://resources.docs.salesforce.com/200/20/en-us/sfdc/pdf/salesforce_import_cheatsheet.pdf

1. From Setup, enter Data Import Wizard in the Quick Find box, then select Data Import Wizard.
2. Click Launch Wizard!
3. Follow the instructions on the wizard screens. The import process involves these steps:
• Upload the CSV import file into the import wizard.
• Define the matching criteria that the wizard uses to avoid importing duplicate accounts or contacts.
• Map the columns in the import file to the desired Salesforce fields. When you finish the wizard, the import file is placed in a queue for processing. Import files are processed in the order in which they are received. You receive an email when the import completes.

 
This was selected as the best answer
Tejash ChauhanTejash Chauhan

Data Import Wizard Mapping

By Selecting Match Contact by "Name", and Match Account by "Name & Site". You can prevent duplication of Accounts and Contacts.