I run weekly reports on an online database (I don't have full access to the database) where I need to generate states based on a certain field. Currently the only way to do this is to select each option from a drop down list, perform the search and copy the number I need from the search results. I then hit back, select the next option from the drop down list and repeat.
Quite tedious and time consuming. The database maintainers won't add the search option I need.
I was thinking that if I could see what query is being sent, I could then write a script that automatically sends the query, picks out the string I need from the result and save that.
What I need therefore is:
- Ability to log into the site
- Create query
- Strip info I need out of result
- Save result
- Rinse and repeat
Any suggestions /help would be appreciated!