Introduction
When importing a file to update a list, the file is analysed in its entirety before being imported. This analysis may generate errors and prevent the import from proceeding.
File settings
When an import fails, the error may be due to a difference between the file and the configurations entered.
Encoding
The encoding entered must match the file encoding. In the event of an error, you can:
change the configuration encoding;
replace unsupported characters at the expense of value integrity.
Lines too long
All lines must have the same number of columns. A line with too many columns will generate an error. You can then:
- clean up the file so that there are no more lines that are too long
- enable the configuration to truncate lines that are too long, at the expense of line integrity.
File does not exist or is too big
The file selected on the SFTP
- must be available at the expected path;
- must not exceed 5 GB.
File structure
The error may also be caused by a difference between the structure of the file to be loaded and the mapping of the list.
File with header
All columns in the file used to initialise the list must be present in the file to be imported. The order of these columns has no impact.
You can view the columns of the file used during initialisation by clicking on the eye icon in the “Mapping” setting in the left-hand side menu. It corresponds to the values in the “Source” column.
File without header
The different lines in the file to be loaded must have the same number of columns and be in the same order as the file used to initialise the list. It is not possible to update from a file without a header a list that has been initialised with a file containing a header.
Conclusion
When importing a file, a complete analysis of the file detects any differences with the configuration and generates an error. For the import to be successful, it is necessary to modify the configuration or correct the file.