I have an application where a data scientist needs to select from a list of reports to be downloaded from a website. These reports are stored in an excel file. What i need to do is as follows:
- Open excel and create a list of reports required
- For each report in the list
a. log onto website and generate report
b. Switch to “save as” window and save generic report
c. Rename report and move to server
- Create a message that all reports are generated
The problem is that website actions cannot be nested inside a “For each” loop so I don’t know how to pass the appropriate parameters to the bot so that each report is generated. Also, the site is so complex I need xPaths to navigate properly (images don’t work reliably enough) so opening a website and doing the task using actions is also not working well.
Is this something I should be doing using control tower? Is there some other way of approaching this problem that I have not thought of?
Any direction appreciated.