[AccessD] Automating web page entry (was: Scroll button)

Hi John

In Visual Studio you have a native browser object which allows you to read the page, input data, and call JavaScript functions of the page.

It works very well. For fun I made a test once to "hack" an entry key to a (non-essential) page where the key could be from 0000 to 9999. A simple loop that checked if the confirming page or an error page was showed after the entry. It was cracked in a couple of minutes.

/gustav


>>> jwcolby at colbyconsulting.com 09-09-2010 20:32 >>>
Ken,

I guess I wasn't clear.  The web site is from the state of Pennsylvania.  I didn't write it, nor do 
I get any input.

So I get no input on the right way.  The bottom line is all I need is to send them a CSV or similar 
file.  But they don't even accept that.  Nope, every person in the state who wants to enter data 
into their system gets to spend hours every week poking data into a web form.  THOUSANDS of man 
hours monthly across the state, I am sure.

This is the front end to being paid by the state of PA for all therapists and agencies that wish to 
bill the state for services to children (and maybe just services generally).

Do you get a clue why medical costs are so high in this retarded place?

Now for the wrong way.  Yep, it sucks but it has to be better than click / click / paste / repeat 
for hours on end.  And my app is at least SOMEWHAT automated.  I am sure most are manually TYPING 
the data into the state form.

Asking thousands of people to enter their specific 10 pieces of information into 200 controls on a 
"one size fits all" web page, doing this over and over for hundreds of billing records every week is 
asinine!

Do I sound irritated?  That would be because I AM irritated.  Stupidity irritates me.

8(

Or maybe this is PA's equivalent of a "full employment" plan, to keep people off welfare?

;)

All of this data is in my database.  I could just press a button, dump it to CSV file and email it 
or FTP it to the state, but no, my client hires people for hours every week to manually enter this 
into PA's web page.

Sigh!

John W. Colby
www.ColbyConsulting.com