Test settings for the CSV file
The Test settings button allows you to check whether the import file can be imported correctly using the settings that you have specified. The system checks the following:
- Assignment between columns in the import file and in the recipient table
- Validity of data in the import file
The test is carried out for the first 15 lines of the import file. If several import files exist in the source directory, the system uses the most recent import file for the test.
Information messages
If an information message is output, you can still perform the import.
The following information messages are possible:
Information messages |
|
---|---|
|
Please note that you are importing data to columns that do not exist in the system. Column: <Name of the column> |
|
Columns from the import file are hidden in the selected list. |
Error messages
If an error message is output, you must correct the settings for the import file or the data in the import file. The message for the first error that has been found is always displayed. The following error messages, among others, are possible:
Error messages |
|
---|---|
|
The source column with the tracking permission does not exist in the CSV file. |
|
The source column with the email address does not exist in the CSV file. |
|
A line in the CSV file contains too few columns. Line <Line number> |
|
A column in the CSV file has no name. |
|
No files are contained in the directory. |
|
The CSV file is too short to test. Select a CSV file with at least 15 data records. |
|
The CSV file cannot be read correctly with the selected settings. Check the settings for the CSV file. The file may be damaged or incorrectly formatted or compressed. |
Success message
Success message |
|
---|---|
|
The test was performed with the file <file name.csv(.gz)>. Settings were successfully tested |
Step by step
To test the settings for the import file, proceed as follows:
- Open the import in the
Settings workflow step.
-
Click the Test settings button.
The respective success, information or error message appears below the Test settings button.
- You have now tested the settings for the import file.