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. 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 |
|
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.