By means of an import format, you can specify which data, or rather columns, from an 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.
Which columns you can choose from when adding an import format depends on the DB table that is linked to the format. As a system administrator, you can adapt, modify and extend this database table by adding custom fields to the import format.
The following data can be imported to metasfresh:
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: You can learn more about date and time patterns here.
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, please proceed as follows:
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.