Creating 50000 records of entity

(0) Share

Report

Posted on by Nishkarsh Vaish

335

Hello
I have a requirement to create 50000 records in an entity by passing some fields value.
I had used C# plugin for that but the plugin only execute for 2 minutes.

Please give me some ideas for the above task.
Thanks in Advance

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Thomas David Dayman 11,323 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nishkarsh,

I would recommend using SSIS and KingswaySoft adaptor. www.kingswaysoft.com/.../download

You can put your values in SQL Server and import them into CRM using the adaptor

Let me know if you want me to expand on anything.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

If this is a one off operation I would suggest that you create a console application and creates the entities via SDK calls or do an Excel import.

Was this reply helpful? Yes No
Suggested answer

Macoy 275 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You can use KingswaySoft SSIS for this job. Create records with SQL or Extract the records from your source Instance(if you have source environment) to a file then load it to a staging DB in SQL before loading to target CRM instance.

Hope this gives you an idea.

Was this reply helpful? Yes No
CU27040925-8 2 on at

Like
a
(0)

Report
Copy link

Link copied!

/ Create Bulk Record in MS Dynamics 365 CRM CRM through c#

public static void BulkCreate(IOrganizationService service, List<Entity> EntityList)
{
// Batch size
int batchSize = 100; // Adjust the batch size as needed

for (int i = 0; i < EntityList.Count; i += batchSize)
{
var batchRecords = EntityList.Skip(i).Take(batchSize).ToList();
ExecuteMultipleRequest Request = new ExecuteMultipleRequest();
Request.Settings = new ExecuteMultipleSettings();
Request.Settings.ContinueOnError = true;
Request.Settings.ReturnResponses = true;
Request.Requests = new OrganizationRequestCollection();

foreach (var record in batchRecords)
{
var CreateRequest = new CreateRequest();
CreateRequest.Target = record;
Request.Requests.Add(CreateRequest);
}

ExecuteMultipleResponse response = (ExecuteMultipleResponse)service.Execute(Request);
foreach (var responseItem in response.Responses)
{
if (responseItem.Fault != null)
{
Console.WriteLine($"Error creating record: {responseItem.Fault.Message}");
}
else
{
Console.WriteLine($"Record created successfully. ID: {((CreateResponse)responseItem.Response).id}");
}
}
}
}

You can use this code to create 50k record in MS Dynamics CRM 365 in 5 minutes

Was this reply helpful? Yes No