Unable to Import CSV for Data Injection

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).