XMLToTxt Step

Use this step to convert XML to TXT format.

Last published at: June 16th, 2024

Description:

This step converts the XML data into TXT format with rows and columns. It may be used in conjunction with the ExecuteSQLStatement step as it requires the//Row tag in the XML to process.

 

Inputs

  • xmlVariable – Variable that holds the xml. Ex: - variable.data
  • txtFilePath – TXT file path on the FlowWright server
  • writeColHeadings - Write column names
  • rowDelimiter – Row delimiter
  • colDelimiter – Column delimiter
 

 

Returns

  • True – step executed successfully
  • False – step failed to execute 
 

 

Usage: 


 

 

Example: 

Let’s build and execute the “XmlToTxtDef” example.          

  • Create a new definition called “XmlToTxtDef.” 
  • Select the definition and click the “design” button
  • Drag the “ExecuteSQL” and “XMLtoTXT” steps from the toolbox
  • Configure Variable variable.xmlData as a string to hold the XML value (containing //Row tag) 
  • Connect the dots between the start, “ExecuteSQL” and “XMLtoTXT”  steps
  • Click on the “executeSQL” step to configure its “Settings” properties. Provide a name to the step. Select the connection string from the drop-down list. Provide the SQL statement to execute. Select “XML” as the result format from the drop-down list. 

 

  • Click on the “executeSQL” step to configure its “Advanced” properties. Provide a database name if it's different from the FlowWright database. Provide variable/global to store the XML value. Select “No” to get an entire result set. Provide SQL command time-out duration (in seconds). Click on the button to provide the SQL parameters.  

 

  • Click on the “XmlToTXT” step to configure its “Settings” properties. Give the step a name. Provide the variable/global reference containing the XML value. Provide the text file path information. 

 

  • Click on the “XmlToTXT” step to configure its “Advanced” properties. Selection “OFF” to ignore column names. Provide the row delimiter sign (pipe symbol |). Provide the column delimiter sign (tilde symbol ~). 

 

  • Save the process definition, create a new process instance, and execute. The step should transform the XML data into a TXT file and save it to the path specified on the server. 
  • A sample xmlData (containing //Row tags) are shown here
<SQLData>
  <Row>
    <DEUSERID>8f86ba16-c285-4326-a73b-00e0649f82c7</DEUSERID>
    <DEEXTERNALUSERFULLNAME>Re-assigning</DEEXTERNALUSERFULLNAME>
    <RowID>0</RowID>
  </Row>
  <Row>
    <DEUSERID>8f86ba16-c285-4326-a73b-00e0649f82c9</DEUSERID>
    <DEEXTERNALUSERFULLNAME>Test</DEEXTERNALUSERFULLNAME>
    <RowID>1</RowID>
  </Row>
  <Row>
    <DEUSERID>5c699c6e-a382-4dea-b6ed-02584e7ab961</DEUSERID>
    <DEEXTERNALUSERFULLNAME>DMilan</DEEXTERNALUSERFULLNAME>
    <RowID>4</RowID>
  </Row>
  <Row>
    <DEUSERID>5c699c6e-a382-4dea-b6ed-02584e7ab976</DEUSERID>
    <DEEXTERNALUSERFULLNAME>mila</DEEXTERNALUSERFULLNAME>
    <RowID>5</RowID>
  </Row>
</SQLData>
  • A sample XMLtoTXT transform is shown here
DEUSERID|DEEXTERNALUSERFULLNAME|RowID~8f86ba16-c285-4326-a73b-00e0649f82c7|Re-assigning|0~8f86ba16-c285-4326-a73b-00e0649f82c9|1~5c699c6e-a382-4dea-b6ed-02584e7ab961|DMilan|2~5c699c6e-a382-4dea-b6ed-02584e7ab976|mila|3~f2327f71-6c22-44cb-b719-05a96c8f0463|9~