invalid_file error in CSV import for Assets Cloud

Summary

Learn how to fix the error rlabs.insight.i18n.import.module.validation.invalid_file when creating a new Assets import configuration.

Solution

Formatting issues with the CSV file

The known causes for this error are related to problems with the CSV file formatting:

1. The file has a header column with no name. These can easily be identified when opening the file in a text reader by seeing two commas (or other separators) side by side in the first line:

   First Name,Last Name,Address,City,, Mike,Cannon-Brookes,Level 29/363 George St,Sydney,, Scott,Farquhar,Level 29/363 George St,Sydney,,

2. There are two or more header columns with the same name. This can be trickier to identify in larger files, so opening it on a spreadsheet editor is advised:

   First Name,Last Name,Address,Address,City Mike,Cannon-Brookes,Level 29,363 George St,Sydney Scott,Farquhar,Level 29,363 George St,Sydney

Double-check your CSV file for the symptoms above and make sure they are corrected before uploading the file again.