IT-Dashboard Challenge

This is a repository for IT-Challenge developed with Python, rpaframework.

Features

1. Automate Scrap the IT-Dashboard
2. It will scrap agencies with amount and save it into the Excel file
3. It will open one of the agency and will scrap the Individual Investments into another excel file.
4. It will check in the Individual Investments table that if the UII contains link it will open that link and download the PDF file associated with Download Business Case PDF button into output folder
5. Can be test on robocorp
6. All downloaded PDF's and Excel sheets will be land in output folder
7. It will read the downloaded PDF files and get the Section A from each PDF then it will compare the values "Name of this Investment" with the column "Investment Title", and the value "Unique Investment Identifier (UII)" with the column "UII"

Setup (robocorp)

1. rpaframework

Installation

1. Goto robocorp create a bot
2. Add this repo link in public GIT
3. Goto assistants and add new assistant linked with robot that you had registered above.
4. Download and install desktop app of robocorp assistant from there by click on Download Robocorp Assistant App
5. Run the assistant you had created above
6. Bot will start performing the task as mentioned above
7. Your output data will be saved in output folder. click on output when task finished.

File Structure

constants.py

Keyword	Description
URL	URL of the it-dashboard website
DOWNLOAD_DIR	Download directory name
AGENCY_EXCEL_NAME	Excel file name for agencies
INVESTMENT_EXCEL_NAME	Excel file name for investment table data.
KEYWORD	Button name to click on home page so agencies can be visible
OPEN_AGENCY	Number for which agency you wan to scrap the agency investment table, and download the PDF's

task.py

It will initialize the ITDashboard from it_dashboard.py instance and call the required functions to perform the challenge.

it_dashboard.py

• Have the logic to scrap and create the Excel file for agencies and Investment table,
• Get the uii links and download the PDF's associated with it.
• Read PDF's and compare with "Name of this Investment" with the column "Investment Title", and the value "Unique Investment Identifier (UII)" with the column "UII".

conda.yaml

Having configuration to set up the environment and rpaframework dependencies.

robot.yaml

Having configuration for robocorp to run the conda.yaml and execute the task.py

You can find more details and a full explanation of the code on Robocorp documentation