General requirements | Retarus Docs

The CSV structure is documented in each data type worksheet.
Data must be provided in UTF-8, ASCII, or UNICODE encoding. Do not use BOM (Byte Order Mark).
Use a dot (.) as the decimal separator. Do not use a thousand separator.
Example: 5365000.24 (five million three hundred sixty-five thousand point twenty-four)
Use a semicolon (;) as the delimiter.
If your data contains semicolons, replace them with a space or underscore (_).
Always provide a full data load.
Mandatory fields must contain a value.
If no value is available, use a dot (.) as a placeholder. Otherwise, the import will be rejected.

Line	Description	Example
1st line	Column header fields	`ORGID;ORDCODE;SELLMAT;EDPNO;ANSICO;EANNO;ITEMDESC;PRODFAM_DE;PRODFAM_EN;PRODFAM_FR;PRODFAM_IT...`
2..n lines	Data fields	`001;SX500;99999999;88888;SX 500;123456789000;Software für Order Extraction;Software;Software;;...`

Naming convention	Example
Your Retarus customer number must be included in the filename, represented as `nnnnn_timestamp` in the format `YYYYMMDDHHMMSS`.
nnnnn_CustomerMaster_timestamp.csv nnnnn_CustomerShipTo_timestamp.csv nnnnn_ProductMaster_timestamp.csv nnnnn_CustomerMaterial_timestamp.csv nnnnn_SupplierMaster_timestamp.csv nnnnn_OpenOrders_timestamp.csv nnnnn_Keywords_timestamp.csv	`99999_CustomerMaster_20241209134522.csv` `99999_CustomerShipTo_20241209134522.csv` `99999_ProductMaster_20241209134522.csv` `99999_CustomerMaterial_20241209134522.csv` `99999_SupplierMaster_20241209134522.csv` `99999_OpenOrders_20221209134522.csv` `99999_Keywords_20241209134522.csv`

Upload the CSV file using the web service API provided and described in the IDP product documentation.