Business Integration Solutions SaaS

About: TEXTTOXMLTRANSLATOR Activity

In Business Integration Solutions, use the TEXTTOXMLTRANSLATOR activity to convert a TEXT document into an XML document.

Usage

Use this activity to translate a document in Text (or fixed length) format into a document in XML format.

Concept

A fixed width text file is a file that has a specific format which allows for the saving of textual information/data in an organized fashion.

Fixed width text files are special cases of text files where the format is specified by column widths, pad character and left/right alignment. Column widths are in units of characters. So if you have data in a text file where the first column always has exactly 10 characters, and the second column has exactly 5, the third has exactly 12 (and so on), then you have a fixed width text file.

Each row (paragraph) contains one record of information; each record can contain multiple pieces of data (fields), each data field (column) has a precise number of characters. The data is padded with spaces (or any character you specify) if it does not completely use all the characters allotted to it. Further, each piece of data can be left or right justified, meaning the padding of characters can occur on either side.

Business Central cannot interpret data stored in Text format, but in case your company is subscribed to data stored in Text format then you must use the TEXTTOXMLTRANSLATOR activity in your import pipeline. This activity helps you to convert the incoming data into a structured XML format, based on a predefined document.

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

---

Text input ➡️ \[TEXTTOXMLTRANSLATOR\] ➡️ XML output