Skip to main content
Skip table of contents

General requirements

Generic Masterdata Guideline - Retarus Intelligent Document Processing

  • The CSV structure is documented in each data type worksheet.

  • Data must be provided in UTF-8, ASCII, or UNICODE encoding.

  • 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

Uploading the CSV file

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.