This article describes the format requirements for data imported by CSV or XML file. For XML files that have different formats you can use XSLT to transform the data.
Text values
- In text fields optionally place data between “” (necessary if text contains “;” characters!)
- Text fields cannot contain (hard/soft) enters
- If the length of the text in the import file exceeds the defined length of the target field, the text is truncated
Select values
- Select values can be imported as text values
- Select values can be defined as ‘display name,database value’; for imports use the database values
- Select values are imported without validation on the database values defined in the field. For example: if a field has the select values ‘green’ or ‘red’, and the import file contains the value ‘medium’, the value ‘medium’ is imported as is
Date/time values
- Date and time fields have to use the following format: YYYY-MM-DD hh:mm:ss
Example without time stamp: 2018-10-05
Example with time stamp: 2018-10-28 12:12:06 - Values should use ‘lead zeros’ where applicable, e.g. 2019-03-07 01:01:01
Number values
- Number fields have to use the following format: [-]n[.d]
Example: 10000.00
Example: -25.04
Example: 36550.1
Example: 400
Currency values
- Currency values have to use the same format as number values
- Currency values are imported as the defined ‘global currency’, unless otherwise mapped / defined in the import task field mapping
Boolean values
- Boolean values can be imported as ‘1’, ‘y’, ‘yes’ or ‘true’ for ‘true’, any other value is considered ‘false’
