Importing data from robot controllers in industrial plant.

[ChillFancy]

"Hi. I am trying to develop an automated system that will track robot cycle time. I work for a large manufacturing company with over 280 giant robots. I have an access database with a list of IP addresses that correspond to the different robot stations; each IP hosts a webpage. The webpages have values listed that give the cycle time in seconds i.e. [400] = 85.123456
[401] = 89.654321
I want to develop something that will create databases for each robot and pull the date, values, and possibly daily statistics such as avg and std dev. Ultimately I would like to track the rate of change. Any ideas?"

[June7]

You want to pull data from webpage?

[ranman256]

a table with all robots and their IPs.
a form with a timer that polls the IP and appends the data to a result table. (i dont see the need for separate db / robot but you can_)

a separate app to report data.

[ChillFancy]

So each robot controller in the plant has a local address 172.40.16.111, 112, 113 ect. On that server there are many different reports which are delivered in simple html (2 or 3 tables and the data is actually after the tables.) I have the IP table already, just need to write the form and results table. Has anyone done anything like this I can reference? I'm from a mechanical background; my VB experience is limited. Thanks for the responses!

[June7]

Has anyone done anything like what - pulling data from web page? Yes.

Review:

https://www.accessforums.net/forms/a...her-34620.html

https://www.accessforums.net/general...ase-27053.html