Sunday, October 25, 2009

Automating a Dynamic Webpage

Today I created my first asp page. Nothing fancy of course, but it allows for some interesting manipulations of the HTML DOM. It makes what I do at work make a lot more sense now though.

Normally I just work on the client side of things. I became sick and tired of having to automate our GUI with basic webcontrol functions. I knew there had to be a quicker way. I eventually discovered how the form submit works, and reverse engineered how the client requested and updated the database through the GUI. I was able to build hundreds of scripts that allowed for very quick scraping and updating processes. But I really didn't know how the XML updates I was running were actually working.

Now that I've had time to play on my own ASP server, I can see how the GET and POST functions actually work. The SQL behind what I'm doing is still invisible of course, but knowing what's happening makes a lot of sense now.

I should be able to leverage this knowledge at work to further increase the speed of what I'm doing. I only which I could get the raw ASP page to see the SQL side of the request.