a968734e-736c-4c12-894d-0f60043e2609.png

Tired of spending countless hours manually converting documents between different formats? Whether you need to convert a Word file to PDF, HTML, TXT, or even XML, these automations have got you covere

Document Format Conversion

ドキュメントを異なる形式間で手動で変換するのに膨大な時間を費やすことにうんざりしていませんか? Word ファイルを PDF、HTML、TXT、さらには XML に変換する必要がある場合でも、これらの自動化機能が役に立ちます。コンテンツをコピー＆ペーストしたり、フォーマットの問題に苦労したりして貴重な時間を無駄にする必要はもうありません。希望の出力形式を選択し、あとは自動化に任せるだけです。

Simplify your data management processes and unlock new levels of efficiency.

Text-Based Tabular Data Manipulations

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

ce60c479-dc81-4850-9295-78701497fba3.jpg

RPA Solution Architect

171c876e-fb07-4a66-b97c-9ba2c1c1024e.nupkg

The package contains 3 custom activities for converting XML files to other data formats:

  

1\.     **XML to DataTable**

2\.     **XML to JSON**

3\.     **XML to CSV**

  

These activities can handle all types of complex and nested XMLs either in a text file (specified in the input property InputXmlFilePath) with valid XML in it, or accept XML strings directly (specified in the input property InputXmlString). The output will be a CSV or JSON file, at user's designated path (specified in the input property OutputCSV/JSONFilepath), or a DataTable from the input XML.

*   **XML to CSV:** To view the data in tabular format, the output CSV file can be opened using Excel. The first row in Excel will be the header generated from all the tag names in the XML file. In case of multi-level nested XML, it retains the complete path of each element, separated by slash '/'.
*   **XML to JSON:** This activity converts XML in JSON format without any data loss. In case of Array, element tags are added for each array element. In case of non-array objects, XML keys are converted to JSON tags and XML values are converted to JSON inner text. The output of this activity is a .json file.
*   **XML to DataTable****:** It converts input XML to DataTable and provides the flexibility of directly applying all DataTable functions like filtering the XML Data. In case of Array, each Data row is converted to Excel Row Item. In case of non Array structure, all the tags generate headers and in case of multi-level nested XML, it retains the complete path of each element, separated by slash '/' to prevent any data loss.

The time required for this conversion is proportional to the level of nested data structure of the XML (between milliseconds to a few seconds).

  

**Input Properties**

*   InputXmlFilepath - Takes the path of the text file which contains the valid XML.
*   InputXmlString (optional, if InputXmlFilepath is not passed) - Takes as input the XML string. Use Read Text file &gt; Deserialize XML &gt; pass the generated XML with tag name.
*   OutputCSV/JSONLFilePath - Takes the path of the CSV or JSON file in which the output will be generated. The CSV/JSON file will be generated at this path even if it is not present.

**Output Properties**

  

Output DataTable – It generates a DataTable from the input XML and provides an option of saving it in a DataTable type of variable.

  

**Notes**

  

Among InputXmlFilepath and InputXlString properties, only 1 input is allowed to be passed for all these activities and it is a mandatory input property. Output XmlFilePath and Output DataTable are mandatory output fields.

A package of 3 custom activities that accept any complex XML file as input and converts it into DataTable, JSON and CSV files.

Version	Release Date	Download Link
1.0.1	June 28, 2019
First Release

XML Conversion Activities