Excel-to-Portal Entry Automation
Budget: ₹12,500 – ₹37,500 INR
I maintain an Excel workbook containing new–loan information and need every record pushed into the online utility at https://mpapexbankutility.bank.in automatically. A quick outline of what the script, bot, or small desktop tool must do:
• Read the source sheet (standard .xlsx).
• For each row, submit the following fields through the web form exactly as they appear: customer name, contact number, Aadhaar number, saving-account number, loan amount, loan type, sanction amount, sanction date, and recovery date.
• Capture any server response that indicates success or failure. If a record fails, write the full error message and the row data to a local log file so I can review and repost if needed (no e-mail alerts or retries required right now).
The portal uses normal browser sessions, so you are free to choose Selenium, Playwright, AutoHotkey, or a comparable automation framework as long as it runs reliably on Windows 10. A compact UI to select the Excel file and show a real-time progress bar would be a plus but isn’t mandatory—stability and clean logging are the priorities.
Once delivered I will test with a sample sheet; acceptance is complete when every record posts correctly and any failed rows appear in the log with clear error details.
• Read the source sheet (standard .xlsx).
• For each row, submit the following fields through the web form exactly as they appear: customer name, contact number, Aadhaar number, saving-account number, loan amount, loan type, sanction amount, sanction date, and recovery date.
• Capture any server response that indicates success or failure. If a record fails, write the full error message and the row data to a local log file so I can review and repost if needed (no e-mail alerts or retries required right now).
The portal uses normal browser sessions, so you are free to choose Selenium, Playwright, AutoHotkey, or a comparable automation framework as long as it runs reliably on Windows 10. A compact UI to select the Excel file and show a real-time progress bar would be a plus but isn’t mandatory—stability and clean logging are the priorities.
Once delivered I will test with a sample sheet; acceptance is complete when every record posts correctly and any failed rows appear in the log with clear error details.
Related categories:
PHP
Python
Visual Basic
Excel
Web Scraping
Software Architecture
Selenium
Automation