Business Integration Solutions documentation

CSVTOXMLTRANSLATOR activity

In Business Integration Solutions, use the CSVTOXMLTRANSLATOR activity to translate a CSV document into an XML document.

Usage

Use this activity to translate a CSV document into an XML document that the BIS pipeline can read and process.

Concept

Microsoft Dynamics BC cannot interpret data stored in CSV (Character-Separated Value) format. If your company receives data in CSV format, use the CSV to XML Translator activity in your import pipeline. This activity converts the incoming data into a more readable XML format based on a predefined internal document.

To use this activity, define an external document based on which the incoming data translates. You can optionally specify a row from which to start data translation.

In a CSV document, the delimiter does not have to be a comma. You can choose from several predefined delimiters: Tab, Semicolon, Comma, and Space, or specify another character as the delimiter.

CSV input ➡️ [CSV to XML Translator] ➡️ XML output