10-01-2014 09:52 AM
I have exhausted my resources and brain trying to figure this out, reaching out for help now.
I have built a program that captures velocities and pressures from a group of bullets fired from a test barrel (thanks to others here who helped me get this far!). After results are gathered it is autosaved and printed. Then I send it to my boss who maually data-entries it on our online database. He wants to automate this process. I have planned out to save the the data to a file which will later be loaded and the entries will plug into the online database (which I have 80% working, no issues there).
My problem resides here: I built another program that loads up an Activex Web browser of our database, logs in, and navigates to the page where I can submit all of the data values. This works. But there are two drop-down menus on this page which are programmed to refresh when changed. Here is the HTML code from our page:
What happens in Labview when I use these drop-down menus is a new actual Web Browser window pops up and says "Refresh Complete." I'd rather there not be any pages pop up, I am trying to streamline this as much as possible. I will be checking this post frequently and can supplement more information as needed. Thanks in advance!
10-01-2014 10:17 AM
10-02-2014 11:20 AM
Thanks for your quick response yesterday! After chatting with our official IT guy, He lined some things out for me. We are using SQL 2005. We discussed working up a program to add our data directly, which is an option. It will take some learning on my part, and I am willing to do it.
It would be optimal, in my mind, to use our web version in conjunction with Labview. But the more experienced person might know better.
When I call up our webpage on the front panel, I am able to navigate it by clicking around just like a normal browser. Using this method, the refresh issue I mentioned in my original post is not a problem. It refreshes with no pop-up. BUT I lose the capability to place my data into the fields. I am assuming the reference at the property node before the data placement is incorrect. (pictured below)
Is there a way to physically navigate a webpage and then use Labview to find the reference of whatever page I am currently on in order to place my data? This might be the route I need to go.
10-02-2014 11:48 AM
10-08-2014 09:29 AM
I have started looking into SQL (which will take some time to write up somethign new) but would still like to know about my original question:
If I phsyically navigate a few buttons within the Browser in Labview, am I able to find the reference of my current page in order to place the data on that page? As of now when I navigate to my needed page, the data entry doesn't work because the reference is incorrect. But if I go straight to the URL of my needed page, I CAN place the data, but this causes the refresh issue to crop up. Thanks in advance.
10-09-2014 01:28 AM