- Scan each file in the Input folder
- If file type is XML, the BOT Converts and appends to CSV
- Else Skip the file
This BOT converts all the files in the Input folder to a single CSV file (converted.csv). The converted.csv files is created in Output Folder. Each XML file is appended in the same file.
Many applications exports data in XML format. Eg. Salesforce. The files such created have limit on number of records in each file and hence one would have many XML files in same format. If one wants to use the data exported in XML format to any other application, one would need to convert the same in csv file. This BOT will help to convert the XML data in CSV files.
The BOT scans thru the Input folder. If the file type is XML, BOT reads the xml file and converts the same to csv file in Output folder.
- Automation Type
- Last Updated
- July 24, 2020
- First Published
- March 3, 2020
- Enterprise Version
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- XML Files in the Input Folder