Answers.Body: <p>Along with the <em>CiviCRM has detected invalid data or formatting errors in 50 records</em> 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.</p>
  
  <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-07T22:48:41.477Z
Answers.Text: 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...
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-07T23:01:22.490Z
Answers.Text: 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.
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-07T22:06:07.537Z
Answers.LastActivityDate: 2016-08-07T22:06:07.537Z
Answers.UserDisplayName: Chris Burgess
Answers.Body: <p>Here is how I set my import up and use it every week and it works. </p>
  
  <p><a href="https://i.sstatic.net/nHbVT.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/nHbVT.png" alt="Event participant import"></a></p>
  
  <p>This is how my csv is setup.</p>
  
  <p><a href="https://i.sstatic.net/TYTsE.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/TYTsE.png" alt="CSV file"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-07T19:25:48.187Z
Answers.LastActivityDate: 2016-08-07T19:25:48.187Z
Answers.UserDisplayName: frTommy
Answers.Body: <p><strong>PROBLEM SOLVED!</strong></p>
  
  <p>It turns out that <strong>semicolon</strong> does not work as <em>Import Field Separator</em>.
  With <strong>comma</strong> every went as it was supposed.</p>
  
  <p>P.S. Microsoft Excel saves CSV files semicolon-separated.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-07T23:59:13.410Z
Answers.Text: Sounds like the Excel on that PC might be configured to do something non-standard there, since [CSV](https://en.wikipedia.org/wiki/Comma-separated_values) 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.
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-08T00:19:59.630Z
Answers.Text: ... and then the form [asks for the field separator](http://i.imgur.com/PG935gr.png), 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:
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-08T06:55:30.397Z
Answers.Text: @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. https://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).
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-08T10:28:50.593Z
Answers.Text: 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"](https://issues.civicrm.org/jira/browse/CRM-19192). 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!
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-07T23:31:10.757Z
Answers.LastActivityDate: 2016-08-07T23:31:10.757Z
Answers.UserDisplayName: Aivars
Body: <p>I can't figure out how to import event participants.
  I have created an event (ID=1).
  Same problem with event ID=3.</p>
  <p>No matter whether I use Participant status or Participant status ID, CiviCRM gives me error for all lines.</p>
  <p><em>Missing required field(s) :Event Participant Status.</em></p>
  <p>What data should I be providing to CiviCRM to make it work?</p>
  <p><a href="https://i.sstatic.net/3sdEB.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/3sdEB.jpg" alt="enter image description here" /></a></p>
  
Tags: <wordpress><import>
Title: Can't import Event participants
ThreadText: # Can't import Event participants
  
  (Asked by: username_0 on 2016-08-07)
  
  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](https://i.sstatic.net/3sdEB.jpg)](https://i.sstatic.net/3sdEB.jpg)
  
  **Tags:** wordpress, import
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_0 on 2016-08-07. Score: 3 | Accepted answer
  
  **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.
  
  > **Comments:**
  > **username_1**: Sounds like the Excel on that PC might be configured to do something non-standard there, since [CSV](https://en.wikipedia.org/wiki/Comma-separated_values) 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.  
  > **username_1**: ... and then the form [asks for the field separator](http://i.imgur.com/PG935gr.png), 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:  
  > **username_0**: @username_1 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. https://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).  
  > **username_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"](https://issues.civicrm.org/jira/browse/CRM-19192). 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!  
  
  ---
  
  ### Answer by username_1 on 2016-08-07. Score: 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.
  
  > **Comments:**
  > **username_0**: 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...  
  > **username_0**: 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.  
  
  ---
  
  ### Answer by username_2 on 2016-08-07. Score: 1
  
  Here is how I set my import up and use it every week and it works.
  
  [![Event participant import](https://i.sstatic.net/nHbVT.png)](https://i.sstatic.net/nHbVT.png)
  
  This is how my csv is setup.
  
  [![CSV file](https://i.sstatic.net/TYTsE.png)](https://i.sstatic.net/TYTsE.png)
  
  
  ---
  
  