Selenium based Python app that automates the download process for Catalyst reports.
My current role requires that I download .csvs from multiple webpages in order to update rosters. The website itself is a bit older, and a bit finicky to work with on multiple tabs, and takes multiple clicks to download a single .csv for one program out of many. My goal is to automate this process using Selenium, so with only a few keystrokes I can automatically download all of the rosters for the day, two times a day, and then later on automatically highlight newest entries compared to yesterday's/previous download's entries, and eventually import said new entries into Sharepoint. Additionally, the script will eventually strip out entries who did not complete registration, and automatically queue up an email for those who did not complete registration.
- Automatic Login to Catalyst
- Downloading .csvs (partially done)
- Automatically runs 2x per day
- Creation of a Folder, labeled, for the downloads for the day
- Replace and delete old downloads
- Eventually update the existing rosters in OneDrive
- GUI interface
- Downloading of only relevant programs/excluding unneeded programs
- "Bypass" 2FA if already logged in on different browser instance