Contents of Article
- Issue: Unable to Import CSV file for Data Injection
- List of Symptoms
- Expected Behaviour
- Cause of Issue
- 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.
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).