How to get data from database in html page created in web dev module

ptchanchal · February 10, 2020, 3:41pm

I just started using Ignition so i don’t have much idea about how things work in this. I created a page using html and bootstrap in the web dev module. So what i am trying to do is, I want to show some data from my database in html table I created. I tried using php code but it doesn’t worked and I figured ignition doesn’t support php. So is there any other way that I can pull data from my database and show inside my html table?

Thank You.

pturmel · February 10, 2020, 3:49pm

Ignition uses jython for all scripting. Create a GET routine with jython that queries the database using Ignition’s standard functions. Programmatically construct the HTML you need, incorporating the database query results. Consider adding some python templating libraries to your gateway to help with the HTML generation.

pturmel · February 10, 2020, 3:50pm

Consider going through the free online training so you'll get an overview of what's possible and how things work.

PRAMANJ · February 10, 2020, 6:01pm

We have developed a RWS (Web Services) module for Ignition, that allows you to pull any data from Ignition server using WebDev module in an HTML page in JSON format. Once you have the data source available in the HTML page , you can use it to drive any HTML/DOM component. We can easily modify it to get Data from a Database as a json object. We are coming out with the next version 1.5 to have this request/response feature soon. Present version 1.4 is available on EXCHANGE portal at https://inductiveautomation.com/exchange/1954/overview

ptchanchal · February 10, 2020, 8:09pm

I did as given in the github instructions(“GitHub - PRAMANJ/ARSCADA-1.4: ARSCADA version 1.4 repository”) but I am getting 404 error

PRAMANJ · February 11, 2020, 3:49am

sorry for the late response, it was midnight when I signed off yesterday. The download and instructions are also available on Exchange portal https://inductiveautomation.com/exchange/1954/installation. On step 13, you need to replace the host name pramanj to your server’s host name in the URL http: //pramanj:8088/main/system/webdev/ars/ARS/rws/rws1.html. Sorry I forgot to mention it here, though I have mentioned it in ARSCADA instructions in step 10 on this page. To get your host name type hostname and press enter on command prompt.

I will upload the revised version 1.5 soon with request/response structure so that you can get database values as well on the HTML client.

ptchanchal · February 11, 2020, 1:54pm

No problem for the late response and thank you for your time. I tried as you told but still getting the same error 404. I also tried calling postjson file in the web dev and its working but when try calling ARS/systemlist.html its giving 404 error.

PRAMANJ · February 11, 2020, 2:38pm

Strange! try following things:

The default project name “ars” (lower case) in URL http: //pramanj:8088/main/system/webdev/ars/ARS/systemlist.html is case sensitive.Have you named your project as ARS or ars? Change the project name or URL accordingly.
The project name in c:\ARS\viewer\embedhost.js is also case sensitive. Ensure its in line with your project name given.
Hope you have saved the project after importing the appropriate demo project , depending upon the Ignition version your are trying with.(b.t.w which version of Ignition are your trying with? 7.9 or 8?).
Hope you have imported the tags.xml file in default tag provider in the ars project.
Just make sure the file C:\ARS\systemlist.html exists in the path.

Let me know if it works with these changes

regards:

ptchanchal · February 11, 2020, 3:01pm

My project name is “ars”
The project name in c:\ARS\viewer\embedhost.js is also “ars”
I saved my project after importing and my ignition version is 8.0.7
Imported Tags too
C:\ARS\systemlist.html it exists in the path and i tried opening it outside of ignition and it was opening.
And I used Host name after checking the hostname in cmd
In the URL instead of pramanj I tried using hostname then its showing " This site can’t be reached" and I changed it with localhost ip then getting 404 error page not found.

PRAMANJ · February 11, 2020, 3:15pm

I will install version 8.0.7 and try . I have an older version

PRAMANJ · February 11, 2020, 3:33pm

Hope a file resource with path C:\ARS is mounted on your webdev node on project browser? If not then right click in webdev and mount folder and select path. Also use hostname instead of localhost in the URL.

ptchanchal · February 11, 2020, 4:07pm

Yep, I have C:\ARS is mounted on my webdev node. And when I use hostname its giving an error " This site can’t be reached"

PRAMANJ · February 11, 2020, 4:33pm

Any ignition webdev experts may like to throw some light, what could be going wrong ? I have enabled CORS

PRAMANJ · February 11, 2020, 5:09pm

Could be some proxy setting issue? Which browser are you using? Chrome? Some google search may give the solution perhaps!

ptchanchal · February 11, 2020, 6:38pm

I am using chrome.

ptchanchal · February 11, 2020, 6:40pm

Is it working for you after installing ignition 8.0.7?

PRAMANJ · February 12, 2020, 6:42am

I just upgraded my Ignition trial version to 8.0.7 (it upgraded smoothly!) and my ARS module is running like a champ! I think its got something to do with your proxy setting! Do a google search for “This site can’t be reached” you may get a lot of tips for the likely cause. Being on the local machine, I think it can only be a proxy setting issue, it can’t be a network issue.

Try to open the URL in a different browser like IE or Edge or firefox?

PRAMANJ · February 12, 2020, 6:45am

See the main page for the URL

PRAMANJ · February 13, 2020, 3:27am

As mentioned earlier , yes it’s working fine on 8.0.7. Did you try on different browser or proxy settings? Will appreciate your feedback . I am coming out with slightly revised version 1.5 of ARSCADA soon

ptchanchal · February 13, 2020, 3:43pm

I tried with google chrome and edge still it didn’t work.