Skip to content

Latest commit

 

History

History
97 lines (79 loc) · 3.29 KB

README.md

File metadata and controls

97 lines (79 loc) · 3.29 KB
Raw

🤖 UMB AutoBill Inspector 📊

Automation script to check and save billing data from Mercu Buana University's Academic Information System (SIA).

Python Version Pandas Version Pyppeteer Version Pillow Version

🚀 Key Features

  • 🔐 Automated Login: Secure and automatic authentication to UMB's SIA.
  • 🧩 CAPTCHA Verification: Displays CAPTCHA for user input.
  • 📊 Bill Data Extraction: Retrieves development and education fee billing data.
  • 💾 Excel Export: Saves extracted data to a neatly formatted Excel file.

📋 Requirements

Ensure you have Python 3.8 or higher installed on your system. Additionally, install the required libraries:

pip install -r requirements.txt

Dependencies:

  • pandas==2.2.2
  • Pillow==10.4.0
  • pyppeteer==2.0.0

🛠️ Installation

  1. Clone this repository:

    git clone https://github.com/RehanDias/cekTagihanUmb.git
cd cekTagihanUmb

  2. Install Dependencies:

    pip install -r requirements.txt

  3. Configure Chrome Path: Edit the CHROME_EXECUTABLE_PATH variable in main.py to match your Chrome installation:

    CHROME_EXECUTABLE_PATH = "C:/Program Files/Google/Chrome/Application/chrome.exe"

⚙️ Usage

  1. Run the script:

    python main.py

  2. Follow the prompts in the terminal:

    • Enter your UMB SIA username and password.
    • Input the displayed CAPTCHA.
    • Billing data will be saved to an Excel file named [username]_Billing.xlsx.

📂 Project Structure

cekTagihanUmb/
├── main.py               # Main script for running the automation
├── requirements.txt      # List of dependencies
└── README.md             # This project documentation

📄 License

This project is licensed under the MIT License. You are free to use, modify, and distribute this project in accordance with the license terms.

🤝 Contributing

Contributions are warmly welcomed! Please fork this repository and submit a pull request. You can also open an issue for feature discussions or bug reports.

Report Bug • Submit Pull Request

🔒 Security

This script handles sensitive login information. Always use it responsibly and avoid sharing your credentials.

📞 Support

If you encounter any issues or have questions, please open an issue on the GitHub repository.

Created with ❤️ by RehanDias