Selenium Bank Scraper to MySQL
Budget: $30 – $250 USD
I need a Selenium-based script that signs in to my Bank A online portal, reaches the transaction-history page, pulls every row (date, description, amount, running balance) and writes the results into a MySQL table.
Key points for the build
• Robust login flow: credentials read from an external config file and clear placeholders for any 2-step verification the site may trigger.
• Accurate scraping: the script must page through the entire history so no record is missed, normalise each field, and flag duplicates before inserting.
• Clean MySQL insert: use parameterised queries, include a simple table-creation script, and leave room for incremental updates on subsequent runs.
• Headless option and concise logging so I can schedule it later with cron or Task Scheduler.
Deliverables
1. Fully commented source code (Python + Selenium or another mainstream language you prefer).
2. SQL file with the table schema.
3. README with setup, runtime arguments and a quick test case showing data written to MySQL.
Acceptance criteria
– Script completes a full fetch from a demo account I will provide.
– All transaction lines appear in MySQL with no duplicates.
– Re-running the job after new transactions exist adds only the new rows.
Let me know your preferred language, any library choices besides Selenium, and the estimated turnaround time.
Key points for the build
• Robust login flow: credentials read from an external config file and clear placeholders for any 2-step verification the site may trigger.
• Accurate scraping: the script must page through the entire history so no record is missed, normalise each field, and flag duplicates before inserting.
• Clean MySQL insert: use parameterised queries, include a simple table-creation script, and leave room for incremental updates on subsequent runs.
• Headless option and concise logging so I can schedule it later with cron or Task Scheduler.
Deliverables
1. Fully commented source code (Python + Selenium or another mainstream language you prefer).
2. SQL file with the table schema.
3. README with setup, runtime arguments and a quick test case showing data written to MySQL.
Acceptance criteria
– Script completes a full fetch from a demo account I will provide.
– All transaction lines appear in MySQL with no duplicates.
– Re-running the job after new transactions exist adds only the new rows.
Let me know your preferred language, any library choices besides Selenium, and the estimated turnaround time.