Issue
When importing a CSV file for data injection an error message is thrown:
List of Symptoms
When exporting the Data Injection Template, the CSV file has all the data in one Column:
This be changed by going to Text to Columns > Delimited > choose separator (comma or semicolon).
This causes the data to be in fixed columns.
However, when trying to import CSV the same error is thrown.
Expected Behaviour
Data Injection > Export Injection Template > Save and export
The CSV file comes out already separated:
Data Injection > Import CSV > Upload the correct file:
Cause of Issue
OpenField only allows certain Excel settings to be imported from the CSV.
When the region is set to something else, OpenField cannot import the CSV.
Resolution Steps
A workaround is to change the regional settings from the control panel to ‘English (United Kingdom)’
Control Panel > Clock and Region > Region > Formats > English (United Kingdom).
Related articles