You can use a type conversion to convert the data to match the format as required in the target. With a type conversion, you can convert values from any type to string or from string to any type. Usually, the string value is the external value. Note: Type conversions from any type to any type are not supported. For example, a conversion of type integer to type date is not possible.
You can use these conversion types:
Conversion type |
Description |
Text |
Define the format in which a text is imported or
exported. You can, for example, replace or remove characters, or use one element
of the text. |
Amount |
Define the format in which an amount is imported or exported. You can, for example, define separators and unit conversion. |
Date |
Define the format in which a date is imported or exported. You can, for example, define the sequence and separator. |
Enum |
Define the format in which an enum value is imported or exported. You can, for example, define that the enum value is imported or exported as text. |
Time |
Define the format in which times are imported or exported. You can define the format and the separators to be used. |
UtcDateTime |
Define in which format a date and time field value is imported or exported. This type combines the Date and Time types. |
Date/time format |
Define in a flexible way the format in which a date and time field value is imported or exported. You can also include a time zone. Note: The format is case sensitive. For example, the lowercase 'm' is the identifier for minute, and the uppercase 'M' is the identifier for month. Example: dd-MM-yyyy. For more information on how to set up the date/time format, refer to Custom date and time format settings. |
Name | Responsible | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Define type conversion for field mapping |
Application Consultant |
You can use a type conversion to convert the data to match the format as required in the target. With a type conversion, you can convert values from any type to string or from string to any type. Usually, the string value is the external value. If a type conversion is required for a field mapping, add the relevant type conversion to the field mapping. |
||||||||||||||||
Set up type conversion |
Application Consultant |
If you need a type conversion and it does not already exist, you must set it up. You can use a type conversion to convert the data to match the format as required in the target. With a type conversion, you can convert values from any type to string or from string to any type. Usually, the string value is the external value. Note: Type conversions from any type to any type are not supported. For example, a conversion of type integer to type date is not possible. You can use these conversion types:
|