function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jeff TalbotJeff Talbot 

Systematically insert records one at a time?

Import Wizards, Data Loader, and Excel Connector -- Each of these tools inserts new records in batches.

 

I need a way to insert a spreadsheet of records one at a time.

 

Reason: Parent record has workflow that runs field updates based on data in the most recent child record. If insertion of child records is done in batches, parent record workflow only runs one time for each batch of child records inserted, rather than one time for EACH child record inserted.

 

When I load the records one at a time in Excel Connector, all is perfect.

 

Any help, tips, or suggestions are greatly appreciated.

Best Answer chosen by Admin (Salesforce Developers) 
KevinLaurenceKevinLaurence
Have you tried changing the batch size in the data loader from 200 (the default) to 1? You can access the batch size via the Settings command.

All Answers

KevinLaurenceKevinLaurence
Have you tried changing the batch size in the data loader from 200 (the default) to 1? You can access the batch size via the Settings command.
This was selected as the best answer
Jeff TalbotJeff Talbot
Thank you! My oversight. I checked for a batch size setting in Excel Connector, but forgot to check for that in Data Loader. I made the change you mentioned and the problem is solved.