Customer experience | Sales, Customer Insights,...

Uploading updates to contacts

(0) Share

Report

Posted on by jmancini77

Does anyone have any recent guidance on the "Upsert" question? -- I'm trying to bulk update a few fields in existing records in Dynamics any avoid creating duplicates.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

ankit_singhal 560 on at

Like (1)

Report

First you need to export all the data from the crm in Excel then update same Excel file and re import it in crm. It will upsert the records

or you can use Kingswaysoft tool to upsert the records

Was this reply helpful? Yes No
Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi jmancini77,

I recommend using the Upsert action in the CDS/CRM Destination Component found in the KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365.

Was this reply helpful? Yes No
Inogic 703 on at

Like (0)

Report
Hi,

Follow the below steps to update the data without creating duplicates.

By using “EXPORT to EXCEL” option Export the data from the CRM.

Once exported, make the required changes in the file.

Upload the Excel file in the CRM back, while uploading you need to keep Allow Duplicates file OFF (as per below screen short)

This will update the existing records without creating duplicates of the record.

Hope this helps.

Thanks!

Was this reply helpful? Yes No