Answers.Body: <p>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.</p>
  <p>'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.</p>
  <p>HTH</p>
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-12T16:23:45.310Z
Answers.Text: Great Pradeep, thanks so much for the explanation!
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-12T09:21:40.090Z
Answers.LastActivityDate: 2021-04-12T09:21:40.090Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I'm using Civi 5.35 and Drupal 7. We've installed the <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport" rel="nofollow noreferrer">API CSV Import extension</a>. At ~/civicrm/index.php?q=civicrm/csvimporter/import , I see a place to enter
  &quot;Number Of Items To Process For Each Queue Item&quot; followed by &quot;This is the number of rows to process in each queue item. (Eg. 10)&quot;</p>
  <p>What is a &quot;queue item&quot;? 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?</p>
  <p>Thanks!</p>
  
Tags: <api><import><data-import><csv>
Title: What does 'Number of Items to Process For Each Queue Item' mean when using the API Importer extension?
ThreadText: # What does 'Number of Items to Process For Each Queue Item' mean when using the API Importer extension?
  
  (Asked by: username_0 on 2021-04-12)
  
  I'm using Civi 5.35 and Drupal 7. We've installed the [API CSV Import extension](https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport). 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!
  
  **Tags:** api, import, data-import, csv
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-04-12. Score: 3 | Accepted answer
  
  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
  
  username_1
  
  > **Comments:**
  > **username_0**: Great username_1, thanks so much for the explanation!  
  
  ---
  
  