This repository contains two Python scripts developed at Infozillion Teletech BD Ltd. to automate web-based tasks using Selenium and PyAutoGUI. The scripts facilitate the automation of logging into a web dashboard, navigating to specific panels, and downloading data in CSV format. Additionally, a third script, named Telecom-Error-Analyzer and available in a separate repository, complements these automation scripts. Telecom-Error-Analyzer combines and analyzes the data downloaded by the first two scripts from Mobile Network Operator (MNO) and Internet Protocol Telephony Service Provider (IPTSP) files, generating a comprehensive summary table.
This section includes scripts designed to automate web-based tasks for dashboard data retrieval. Two available scripts are mno-log-downloader.py and iptsp-log-downloader.py:
-
Functionality:
- Automates the login and data download process for web dashboards related to MNO and IPTSP Failed HTTP Hit Count panels.
-
User Input:
- Requests user input for the start and end times to define the time range for data retrieval.
-
Dependencies:
- Selenium
- PyAutoGUI
-
Execution Steps:
- Opens the Chrome browser and navigates to the provided URL.
- Waits for the authentication prompt.
- Uses PyAutoGUI to input username and password.
- Navigates through the dashboard to access panel options and downloads data as a CSV file.
- Waits for a specified time before closing the browser.
-
Clone Repository:
git clone https://github.com/iftekharmickey/Web-Task-Optimizer/
-
Install Dependencies:
pip install selenium pyautogui
-
Set up Chrome WebDriver:
-
Run Scripts:
Execute scripts following the provided user prompts.
-
Security Measures:
- The username and password for the web application have been removed from the scripts for security reasons. Users must manually input their credentials during script execution.
- Ensure the confidentiality of your credentials and avoid sharing them in any publicly accessible space.
-
Adjusting Script Parameters:
- Some scripts may have parameters such as time intervals and URLs hardcoded. Adjust these parameters based on your specific requirements before running the scripts.
-
Web Browser Compatibility:
- The scripts are developed for Chrome. If you are using a different browser, update the WebDriver accordingly.
-
XPath Expressions:
- Note that the scripts rely on XPath expressions to locate elements in the web application. If the structure of the web application changes, you may need to update the XPath expressions used in the scripts for accurate element identification.
For data processing and analysis, refer to the Telecom-Error-Analyzer:
-
Functionality:
- Processes MNO and IPTSP files, combines them, and generates a summarized CSV file.
-
User Input:
- Requests the user to input the filenames for MNO and IPTSP files.
-
Dependencies:
- Pandas
- NumPy
-
Execution Steps:
- Loads and processes MNO and IPTSP files into DataFrames.
- Combines the DataFrames, filtering out specific rows.
- Performs data manipulation, pivoting, and calculation operations.
- Generates a comprehensive summary table.
- Saves the output to a CSV file.
This project is licensed under the MIT License - see the LICENSE file for details.
- Iftekhar Tahir
- Email: iftekhar.tahir@proton.me
- GitHub: https://github.com/iftekharmickey
- LinkedIn: https://www.linkedin.com/in/iftekharmickey/
These scripts have been created and tested for use with a specific web application with appropriate permissions. The author and contributors are not responsible for any misuse of the tools. It is essential to use these tools only with prior permission and in compliance with all relevant laws and regulations.
Please ensure that you have the necessary authorizations to access and automate interactions with web applications before using these scripts.