ROES Events Import Error "An Error Occurred Importing: #"

If ROES throws and error like the below when trying to import data, there is an issue in the CSV.

  1. Excel may not open the file, but a text editor should

  2. Review the CSV and there is probably missing commas (Figure 1).

  3. Copy and Paste a string of commas to the end of each line missing commas (Figure 2)

  4. Reimport the CSV to correct the issue

image.png

This may be related to something that changed after Excel 2003, so if using a version up to and including that one, that may be the source of the issue.