Unable to import CSV for Data Injection

Contents of Article

1. Issue: Unable to Import CSV file for Data Injection
2. List of Symptoms
3. Expected Behaviour
4. Cause of Issue
5. Resolution of Troubleshooting steps

Issue: Unable to Import CSV file for Data Injection

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 > Comma separator.

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