Business Integration Solutions Documentation

CSVTOXMLTRANSLATOR Activity

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

Usage

Using this activity you can translate a CSV document into an XML document, which can be easily read and processed by the BIS pipeline.

Concept

Microsoft Dynamics BC cannot interpret data stored in CSV (Character-Separated Value) format. But in case your company is subscribed to data stored in CSV format then you must use the CSV to XML Translator activity in your import pipeline. This activity helps you to convert the incoming data into a more readable XML format, based on a predefined internal document.

To be able to use this activity, you must define an external document based on which the incoming data will be translated. Optionally you can specify a specific row from where you would like to start data translation.

In a CSV document the delimiter does not necessarily have to be a comma, therefore you have an option to choose various predefined delimiters, such as Tab, Semicolon, Comma and Space. You have an option to specify Other character used as a delimiter in the CSV document.

CSV Input ➡️ [CSV to XML Translator] ➡️ XML Output