AdvancedHMI Software
General Category => Application Showcase => Topic started by: ShriramPendse on February 01, 2016, 01:13:32 AM
-
Hi ,
A very basic prelim application trial using AdvHMI as Server connected to ModTCP PLC , SQL server for dataexchange between ASP.net clients and PLC .
Runs OK to some extent , but lot of further development required to make it Deployable & reliable enough to give it to client.
Screenshot attached.
-
Nice work! A lot of people will be interested in how you implemented the web interface.
-
Sure ,
I am still working on it . Once it comes to workable form I will post code .
But meanwhile others can try how this is organised .
AdvHMI at local PC has application to communicate with PLC and works as a usual SCADA station.
This PC has SQL Server database having a table with only one row as latest values all tags that you need to monitor on WebClients .
AdvHMI appln UPDATES these values after reading those from PLC at whatever interval you desire (100 tags every 500 Ms or so).
There is another table, "commands" , having three Columns , TagID , Address and value .
Our AdvHMI appln keeps looking for "Commands" table for any new commands issued by clients . If it sees new commands , it writes these to PLC . After executions these could be marked done or simply deleted .
A simple web application made in ASP.net gets data from the SQL database values table and displays on screen. It is deployed on IIS .
Now comes tricky part , user actions on web page to write to PLC , actually write to SQL commands table .
Our AdvHMI appln keeps looking for "Commands" table for any new commands issued by clients . If it sees new commands , it writes these to PLC . After executions these could be marked done or simply deleted .
This mechanism WORKS , now to make it deployable various checks and balances are to be made . It is quite OK within company network over LAN. Over internet there are issues like static IP , Firewall , security , reliable connection etc.
Hoping for the best .
-
Currently working on a similar project.
-
I have been thinking about this for a while. Please do keep us informed. Its good stuff.
-
I have been working on this over the last year. I am using MySql community running on a cloud sever. We deploy either cell modems with static ip's and on occasion have to use a satellite. We currently have 18 locations reporting to the one server and about 35 users. We have to have a touchscreen pc on each location for user login and local control, that is where I deploy ADvHMI and MySql code and also handles email alarms. I have found that as long as you deploy with some type of "report by exception" so your not just constantly pounding the cell modem it works fairly well. My biggest problem now is the asp side as we had another developer that just wrote the web side of stuff has left for other opportunities I am stuck with maintaining the web stuff which I cannot make look very good. Anyway looks good.
Jody
-
Jody
Can you put up a screen shot of what your web page looks like now and some mock up of what you want it to look like?
-
plas projact code