0

I'm using Civi 5.35 and Drupal 7. We've installed the API CSV Import extension. At ~/civicrm/index.php?q=civicrm/csvimporter/import , I see a place to enter "Number Of Items To Process For Each Queue Item" followed by "This is the number of rows to process in each queue item. (Eg. 10)"

What is a "queue item"? Do I enter a 'Number of Items' value of, say, 2,000, if I want to 'process'/import 2,000 records at a time, but my entire import file can contain say 50,000 or 500,000 records, as long as it does not exceed 3 megabytes?

Thanks!

2

API CSV Import extension uses Job Scheduler to import the records in Civi. The job scheduler breaks down the whole csv into small batches(also known as queue item) to import to avoid timeout issue, memory excess and various reasons.

'Number of Items' is used to define how many records you want to process in single single queue. If you specify 2000 than there will be 25 queue item lined up in job scheduler to process 50k records with 2k in each queue. The 'Number of Items' you specify should respect the max time out and memory size of the server or it will always result in error. I prefer to set to 500 per batch for better results.

HTH

Pradeep

1
  • Great Pradeep, thanks so much for the explanation! Apr 12 at 16:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.