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.