The delimiter can be set to colon, semi colon, pipe or tab.
It is possible to set the first row as the one containing the column names and to wrap text with double quotes.
The Column mapping allows defining the structure of the expected file. Fields can be added manually here with a name, type and length. When the structure is defined, it can be exported and later on imported again when a new file is being loaded.
The three options at the bottom indicate what should be done when delimiter problems occur:
- Continue on invalid rows: rows with errors are ignored. The following row is imported.
- Keep invalid rows: rows with too many or too few columns are nevertheless imported, if possible
- Mark invalid rows as rejected: rows with errors are marked as rejected
