By means of the import format, you can specify which data, or rather columns, from the import file are to be transferred, how these columns are named and delimited (separators), and into which database tables the import data are to be taken over.
Note: In order to successfully import data, the separator in the import file must coincide with the one set in the import format (comma, semicolon, tab, etc.).
Note: The start number determines the position where a column is expected by metasfresh in the import file during import. It has nothing to do with the order (SeqNo) in which the format fields were added to the import format. It is therefore not necessary that the fields are placed in a fixed and ascending order, as long as the start numbers coincide with the column positions in the import file.
Note: Repeat steps 1 to 6 to add further format fields.
If you want to add a new import format with the same format fields as an existing format, you can very easily copy the format fields from the existing import format into the new one via the actions menu. To do so, take the following steps:
Note: In order to successfully copy the format fields from an existing import format, the new format must be configured with the exact same DB table as the existing one.