5 replies to this topic

[barnigan]

my job wants me to create a link that will display real time data from our test towers. the test towers send there data directly to a data base called RPO_Proddata. the problem is the only access they gave me is a .exe that can access the database. the program does create .cvs files that I can use, so my question is does anyone know how to sutomaticly open and navigate a .exe automaticly. I looked at batch files, however all i could find was how to open/close files.

[Orjan]

how shall you display data? in a program? on a web page?

[barnigan]

I will be displaying a table on a web page but the data i need to get will be coming from the program

[WingedPanther]

It sounds like you need to open .cvs file and parse it into an HTML table.

[barnigan]

Yes, that is probably what I am going to do, what i don't know is how to automate the .exe program to get the cvs file, here is a word file with the proccess procedure that I need to automate

i may need to post this on a diffrent forum but i'm not sure where

Attached Files

•  dbprocess.doc   386.5K   84 downloads

[Orjan]

well, you can connect with any program actually i can see, but then you might do lots of data remodelling that your program does for you. but i see on first screen, that you connect to the db with integrated security, i.e. your domain login.

this way, you could connect by odbc or any other way.

if you were going to program this in php, i'd suggest the PDO database connectivity solution.

in ASP, you can do it by normal database connectivity

you would need to know what that program "_Robert" does.

otherwise, you need to get a macro recorder for windows and that way run the program.