3

I can't figure out how to import event participants. I have created an event (ID=1). Same problem with event ID=3.

No matter whether I use Participant status or Participant status ID, CiviCRM gives me error for all lines.

Missing required field(s) :Event Participant Status.

What data should I be providing to CiviCRM to make it work?

enter image description here

3

PROBLEM SOLVED!

It turns out that semicolon does not work as Import Field Separator. With comma every went as it was supposed.

P.S. Microsoft Excel saves CSV files semicolon-separated.

  • Sounds like the Excel on that PC might be configured to do something non-standard there, since CSV stands for "comma-separated values". Glad you found it! I've been there :) There is actually a note below import page's file upload box stating that CSVs must be comma-separated. – Chris Burgess Aug 7 '16 at 23:59
  • ... and then the form asks for the field separator, so I'm left as confused as you are :D FWIW I tried this semicolon separated file: John;Doe;098118111, it worked importing a contact: – Chris Burgess Aug 8 '16 at 0:19
  • 1
    @ChrisBurgess Indeed, CSV literally stands for comma-separated values, but it is just a name of file type. In reality there are many formats and many other delimiters are used in this format. en.wikipedia.org/wiki/Comma-separated_values CiviCRM explicitly offers to use different delimiters. Maybe semicolon works for importing contact or contact with simple data. Try semicolon when importing event participants. Or tab delimiter when importing contact data (or a bit more complicated contact data). – Aivars Aug 8 '16 at 6:55
  • 1
    Yep, I concur: this is reproducible. I've reported a bug at CRM-19192: Contributions (and possibly other entity) imports do not handle "non-comma CSV". For now, I'd recommend just using comma-separated CSV. Identifying a bug like this is a good contribution, so thanks for taking the time to ask your question today! – Chris Burgess Aug 8 '16 at 10:28
1

Here is how I set my import up and use it every week and it works.

Event participant import

This is how my csv is setup.

CSV file

1

Along with the CiviCRM has detected invalid data or formatting errors in 50 records message you should have an option to download a CSV of the records which had errors. If you open this CSV, you should see the particular records and field(s) that didn't make sense to CiviCRM.

The easiest way to get the "expected" (=valid) values for import is to add a single record with values like you want to see, and then export it from CiviCRM.

  • Whatever I try to do, it returns error. I added record manually, then created a CSV in the same way, error again. Since I am trying to import 50 lines, I see all my lines in those 50 records. See screenshot in this thread on what I am importing. I have verified Contact IDs, Participant Role IDs, Participant Status IDs. All are valid, enabled, etc. Am I missing something obvious? I tried different ways. With "Participant Status" and with "Participant Status ID", "Role" and "Role ID", Event ID and Event Title, and so on... – Aivars Aug 7 '16 at 22:48
  • No matter what I try, I get the same error in downloaded CSV: Missing required field(s) :Event Participant Status. How do I indicate Event participant status? I guess by using Participant Status ID (numerical: 1, 2, etc.) or by using Participant Status (text: Registered, Attended, etc.) Unfortunately neither works. – Aivars Aug 7 '16 at 23:01

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.