Answers.Body: <p>I re-ran the import with skip for duplicates and it worked perfectly.  For my case this fixed the problem.  </p>
  
  <p>-Josh</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-05T16:39:10.160Z
Answers.LastActivityDate: 2015-11-05T16:39:10.160Z
Answers.UserDisplayName: Josh
Answers.Body: <p>After an import the failed rows are included in a new CSV file which you could download. That file contains the errors and per row why it failed. </p>
  
  <p>It could be basicly something as invalid e-mail address e.g.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-05T13:34:16.767Z
Answers.Text: The error is "Matching Participant record not found for Participant ID 10180. Row was skipped." The 10180 is changed for each of the CiviCRM ID's. I am sorry if I was not clear with this.
Answers.UserDisplayName: Josh
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-05T15:09:57.867Z
Answers.Text: The error is caused because you on duplicate setting set to update. Your participant id column should not contain the civicrm contact id but the participant id.
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-05T07:59:27.080Z
Answers.LastActivityDate: 2015-11-05T07:59:27.080Z
Answers.UserDisplayName: Jaap Jansma - CiviCooP
Body: <p>I have about 4,500 rows of participant that I would like to import.  In each row is a column for the  CiviCRM internal ID and columns for the requisite information about the event.  </p>
  
  <p>When I upload the CSV file about 400 rows are imported and for each of the other rows I get this error "Matching Participant record not found for Participant ID 10180. Row was skipped." Of course the ID number changes for each row.  </p>
  
  <p>I have cross-checked several rows and the IDs are valid.  </p>
  
  <p>The file is a CSV file so Excel formatting should not make a difference but I tried changing the field format and a few other things in Excel. Nothing has worked.  </p>
  
  <p>There are many duplicates in the list but not 4,000.  I have the duplicate setting set to update.  </p>
  
  <p>I appreciate any help.  </p>
  
Tags: <civievent><import>
Title: CiviEvent Participant Import
ThreadText: # CiviEvent Participant Import
  
  (Asked by: username_0 on 2015-11-05)
  
  I have about 4,500 rows of participant that I would like to import. In each row is a column for the CiviCRM internal ID and columns for the requisite information about the event.
  
  When I upload the CSV file about 400 rows are imported and for each of the other rows I get this error "Matching Participant record not found for Participant ID 10180. Row was skipped." Of course the ID number changes for each row.
  
  I have cross-checked several rows and the IDs are valid.
  
  The file is a CSV file so Excel formatting should not make a difference but I tried changing the field format and a few other things in Excel. Nothing has worked.
  
  There are many duplicates in the list but not 4,000. I have the duplicate setting set to update.
  
  I appreciate any help.
  
  **Tags:** civievent, import
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2015-11-05. Score: 1
  
  I re-ran the import with skip for duplicates and it worked perfectly. For my case this fixed the problem.
  
  -username_0
  
  
  ---
  
  ### Answer by username_1 on 2015-11-05. Score: 0
  
  After an import the failed rows are included in a new CSV file which you could download. That file contains the errors and per row why it failed.
  
  It could be basicly something as invalid e-mail address e.g.
  
  > **Comments:**
  > **username_0**: The error is "Matching Participant record not found for Participant ID 10180. Row was skipped." The 10180 is changed for each of the CiviCRM ID's. I am sorry if I was not clear with this.  
  > **username_1**: The error is caused because you on duplicate setting set to update. Your participant id column should not contain the civicrm contact id but the participant id.  
  
  ---
  
  