System operation
StockSAVER manual - Software version 2.1
59
6.10.2
Importing Material Master data from CSV
The CSV import for Material Master data can be used to create new Material Master data or
overwrite existing Material Master data. The Part Number is used to check whether a part has
already been created.
The import can be opened in the user interface in the Material Master and in Location
assignment.
Please note the following:
−
If a part has been deleted and is re-imported via CSV, a new part for the Part Number. will
be created in the database.
−
If a CSV file contains a part several times, every line will be imported. The last line
overwrites the data imported from the previous rows.
−
If an optional field in the CSV file is not defined as a column, the current values in the
database are retained for these fields.
Formatting rules
−
CANSI, UTF-8 and Unicode can be used as character sets for the CSV file. Unicode is
recommended as a character set if available. All data is converted into Unicode
internally.
−
The first line must be the header containing the field names.
−
Fields are divided using one of the following delimiters:
−
Semicolon (;)
−
Comma (,)
−
Tab (\t)
−
Pipe (|)
The delimiter defined in the header must be used throughout the entire file.
−
A double quotation mark " is used as an escape character. A semicolon or double
quotation marks indicate an escape in a character string.
−
Double quotation marks " are displayed twice in an escape sequence.
Example:
Character string: Large T-shirt; long-sleeved and "colourful"