Hello Mates, I am trying to import a csv which contains 20,000 records into one of the modules in SuiteCRM. Imports works out in a batch of 100 records and it is consuming a huge time to import all my 20K records .
Attached is the snapshot below. As you can see in the attached snapshot the import executes in a batch of 100 records. Is there a way to upgrade the batch to higher values say 1000 or 10,000 ?
The best option is to split your CSV files into smaller ones. That way you make sure that batches are properly imported. You have to remember that, depending on the type or records you are importing, there is a lot going on the back end and multiple tables are been affected at the same time: Standard and custom fields, Relationships, …
The other option is to assign more server resources to your application but again 20000 is a big number and might take some time.
Thanks,
AlxGr
You will surely profit from reading this excellent post by Jim Mackin: