🤖 UMB AutoBill Inspector 📊

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

🚀 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