1. Data Management
  2. Connectivity Studio
  3. Design
  4. Set up messages
  5. Set up field mapping
  6. Set up field mapping - Advanced

Define type conversion

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.

 

 


Application Consultant Application Consultant Start Start Does type conversion  already exist? Does type conversion  already exist? End End Define type conversion for field mapping Define type conversion for field mapping 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. Procedure 1. Click Connectivity studio Integration Design. 2. On the Message tab, in the list, find and select the desired message. 3. Click Edit. 4. In the Mapping section, in the Target record pane, in the list, find and select the desired target record. 5. On the Mapping tab, on the Field mapping tab, in the list, find and select the desired field mapping. 6. In the Type conversions field, enter or select a value. 7. Close the page. Set up type conversion Set up type conversion 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:   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. Procedure 1. Click Connectivity studio Integration Design. 2. Click Type conversions. 3. Click New. 4. In the Type conversions field, type a value. 5. In the Project field, enter or select a value. 6. Define the applicable application for the type conversion. In the Application field, enter or select a value. Note: You can only select an application that is defined for the applicable project. You can define project applications on the Projects page. 7. In the Conversion type field, select an option. 8. Sub-task: Define text conversion settings. 9. In the Text case options field, select an option. 10. In the Trim options field, select an option. 11. In the Remove field, type a value. 12. In the Replace field, type a value. 13. In the Keep field, type a value. 14. In the Prefix field, type a value. 15. In the Suffix field, type a value. 16. In the Control characters field, select an option. 17. You can remove diacritics from a text. Example: Input text: "AàáâãäÀÁÂÃÄBCçÇDEèéêëÈÉÊËFGHIìíîïÌÍÎÏJKLMNñÑOòóôõöÒÓÔÕÖPQRSTUùúûüÙÚÛÜVWXYýÝZæøåÆØÅ" Output text: "AaaaaaAAAAABCcCDEeeeeEEEEFGHIiiiiIIIIJKLMNnNOoooooOOOOOPQRSTUuuuuUUUUVWXYyYZæøaÆØA" Select Yes in the Remove diacritics field. Note: The diacritics are removed after the text is trimmed and before the text case conversion is done. 18. You can choose to only use a part of the field value string. Example: If you want to only use a sub-string of ten characters of the field value, enter a length of '10'. In the Length field, enter a number. Note: If you define a length, also define the start position. 19. In the Start position field, enter a number. 20. You can split an input text string in several elements and only use one of the elements for further processing. You can only split an input string if it contains separators. For example, the string is: Customer|C01234|Wholesale. As a separator, use '|'. In the Separator field, define the separator based on which the string is split into several elements. Note: If you define a separator, you must also fill in the 'Element number' field. 21. If you define a split string separator, you must also define which element of the split string you want to use for further processing. For example, the string is: Customer|C01234|Wholesale. For further processing, you only need the second element 'C01234'. In the Element number field, enter '2'. In the Element number field, enter the number of the desired element of the split string. Note: - If the defined element number is higher than the number of elements after the string is split, an empty string is used for further processing. - The string is split after the sub-string settings are applied. 22. Sub-task: Define amount conversion settings. 23. In the Decimals field, enter a number. 24. In the Decimal separator field, select an option. 25. In the Thousands separator field, select an option. 26. In the From unit field, enter or select a value. 27. In the To unit field, enter or select a value. 28. Select Yes in the Absolute field. 29. In the Rounding form field, select an option. 30. Sub-task: Define date conversion settings. 31. If the conversion type is Date, fill in the date conversion options. You can define in which sequence the day, month and year are shown in the field value. In the Sequence field, select an option. Note: - Auto is not the preferred option, because it uses the settings from the current D365 FO environment. If you have several servers with own settings, Auto is not predictable. - If the Date format doesn't fit your needs, consider using the Date/time format. 32. In the Year/date format field, select an option. 33. In the Month format field, select an option. 34. In the Day format field, select an option. 35. In the Separator field, select an option. 36. Sub-task: Define enum conversion settings. 37. In the Enum name field, enter or select a value. 38. In the Format field, select an option. 39. Sub-task: Define time conversion settings. 40. In the Time format field, select an option. 41. In the Time separator field, select an option. 42. Sub-task: Define UTC date time conversion settings. 43. In the Time separator field, select an option. 44. In the Time format field, select an option. 45. In the Sequence field, select an option. 46. In the Year/date format field, select an option. 47. In the Month format field, select an option. 48. In the Day format field, select an option. 49. In the Separator field, select an option. 50. Sub-task: Define date/time format conversion settings. 51. In the Format field, type a value. 52. In the Time zone field, select an option. 53. Close the page. Notes You can the Sample value to test a type conversion. To do so, define the settings, click Save, open the bottom section, and review the sample value. You can change the type of an existing type conversion. If you do so, also define the applicable settings. Yes No

Activities

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:

 

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.

Provide feedback