Customer experience | Sales, Customer Insights,...

What is the best way to Bulk Update 15-20 Lakh contact records

(0) Share

Report

Posted on by dxshyam

230

Greetings!

I have around 15 Lakh Contact records in my D365 CRM online.

I want to do the following for all the records

Update emailaddress2 of each contact with the value of emailaddress1 where emailaddress1 is Not NULL
Set NULL to emailaddress1

What is the best way to get this done without using SSIS?

Thanks

Shyam

I have the same question (0)

All responses (3)

Answers (0)

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi Shyam,

You can use Bulk Data Updater plugin in xrmtoolbox.

You can also create your own console application and use SDK to update contact records

Was this reply helpful? Yes No
dxshyam 230 on at

Like (0)

Report

Hi Bipin,

I think Bulk Data Updater does not have provisions to update field2 with field1's value, I believe it lets us set null or default value. Also, wanted to know if it could handle 15L records and any idea about what would be the ball park time required for it?

We wrote a console application and tested it in a trial environment with 100,000 contact records

The batch size is the default 1000 records, in the initial run the application stopped performing after 2000 records were updated. On re-running the console application again - it executed another 49,000 records and stopped.

On an average it took about 10 mins for 10,000 records, that translates to about 25 hours assuming the console app did not stop in middle.

Do we have an option to execute multiple console jobs at the same time (clones of the same console job) - will this work like parallel processing and reduce the overall time significantly or would it increase the load on the server and result in higher time?

Thank you

Shyam

Was this reply helpful? Yes No
Suggested answer

Ray 1,537 on at

Like (0)

Report

For one-time task, I think the best way is to use the Export function. You can export the contacts(Click the "Dynamics WorkSheet" ribbon) and change the data then Import back.

If this may need to repeat, I think creating a flow is a good choice. This flow is created to handle a single record and you can batch it in Advanced Find.

Was this reply helpful? Yes No

Join the conversation

Community site session details

What is the best way to Bulk Update 15-20 Lakh contact records

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

What is the best way to Bulk Update 15-20 Lakh contact records

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates