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 |
|
2..n lines | Data fields |
|
Naming convention | Example |
---|---|
Your Retarus customer number must be included in the filename, represented as | |
nnnnn_CustomerMaster_timestamp.csv |
|
Uploading the CSV file
Upload the CSV file using the web service API provided and described in the IDP product documentation.