How to insert/update data in bulk in CRM Entity

(0) Share

Report

Posted on by Community Member

Hi,

I have an entity named "product" and I am trying to insert/update records in this entity. The entity is updated via interface and it has a lot of records (around 350000). Can anyone please let me know how can I upsert records in bulk.

Thanks,

NKJ

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Shantnu Sharma 655 on at

Like (0)

Report
Copy link

Link copied!

Hello Nikhil,

Please use the OOTB bulk update method for the same. Use export functionality from the advanced find and mark the records for re import. Change in the exported file and re-import.This will update the records for you. Please let me know if you need more details.

Was this reply helpful? Yes No
Suggested answer

Surmeet Singh 3,075 on at

Like (0)

Report
Copy link

Link copied!

Hi Nikhil,

You can use a .net console application, it will be best approach for this case. Other things that you can use are workflows and Import/export but for this large count, console will work best.

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

You have multiple options:

> Using out of the box import.

> Using SSIS toolkit (www.concurrency.com/.../using-ssis-import-data-dynamics-crm)

> Using Scribe (www.powerobjects.com/.../performing-bulk-operations-scribe-insight-adapter-dynamics-crm-2011)

> Using Configuration Migration comes with SDK

> Developing custom .net utility

Was this reply helpful? Yes No
Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report
Copy link

Link copied!

Nikhil,

Refer this:

www.powerobjects.com/.../performing-bulk-operations-scribe-insight-adapter-dynamics-crm-2011

Hope this helps.

Regards,

R.Rajkumar

Was this reply helpful? Yes No