Introduction
The Contact lists tab allows you to create two types of lists:
- Static lists: Can be updated manually, either individually or from a file.
- Dynamic lists: Update automatically by retrieving a file from an SFTP server.
Once the file has been selected at the source step, the file parameters are displayed.
File parameters
Once the file has been imported or detected, it's necessary to complete the following elements:
Column delimiter
Corresponds to the character that separates columns. It is set to comma by default. However it is detected automatically when downloading a file locally if the encoding of that file allows it.
Setting the wrong delimiter will cause errors when importing the file.
Textual qualifier
Corresponds to the character used to enclose values. It is set to " (double quote) by default.
The addition of a text qualifier is recommended to guarantee the integrity of each field and avoid errors during import.
How to identify my file's text qualifier
First line contains column names
Indicates whether the file has a header with column names or not. This parameter is selected by default.
Encoding
Corresponds to the encoding of the file.
It is set to UTF-8 by default. However it is detected automatically when downloading a file locally for some compatible encodings.
Setting the wrong encoding will cause errors when the file is imported.
Replace unsupported characters
Indicates whether to replace invalid characters with the � value compatible with the selected encoding.
This configuration allows lines with invalid characters to be inserted rather than excluded, but does not guarantee correct display of the value.
Truncate lines that are too long
Indicates whether to truncate lines that are longer than the number of header columns. This configuration allows these lines to be inserted rather than excluded, but does not guarantee complete line integrity.
Interpreting null values
Indicates which values present in the file to insert as null among 'NA', 'NaN' and 'NULL'.
Conclusion
To learn more about the different file types supported, you can refer to the associated article: What file types are supported.
Once finished you can move on to the next step and define contact channel fields.
In the event of an error, consult the help article I have an error after the source step.