Automated DB Export from Web Page
Project detail
We are looking to automate the following process:
1. Read an ID from an excel file
2. ‘paste’ the ID into a web page search box (the web site belongs to someone else) that will display a page tied to the ID
3. Select a button on the web page to show select data about that particular item
4. Select ‘Export’ button
5. Save the resulting csv export file
There are probably ways to eliminate some of the manual steps. The end goal is to automatically create all of the required csv files without any human interaction.