Introduction
When configuring a list, the source step consists in selecting the source file and entering its parameters. Validation of this step leads to analysis of the first 1000 lines of the file.
Errors
When validating the source step, an error may occur and prevent you from moving on to the next step.
The error may be due to a difference between the parameters entered and those of the file.
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.
Conclusion
The source step configurations of a list must match the source file. Several options are available to allow the import of ill-formed files at the expense of data cleanliness. Check out this article to understand How to load a file.