Great news! I have approval to upgrade to the Ignition platform but I have to wait until IT upgrades their server (Hopefully, this month). At that point I get the old one for all “my” stuff. I like what I have tested so far and am looking forward to it. My biggest question right now is what to do about the historical logging.
Here is the current setup:
We have 8 Production lines with several machines per line. I am using a separate database for each line and each machine has it’s own table. In FSQL I am using several historical groups to log the data. Inside the tables there is a column for each tag in the group.
Remember the Click to Graph goodie? Well I copied the table structures and modified the script to use the underlying tables (now modified). The end result is: whenever I add groups/tables to FSQL a stored procedure reads the column names of all tables in all databases and compares them with the pens in the pens table. This presents me with a list of tags that I can then add as new pens to the system or ignore them. I also have screens that alow a user to create and save their own pen groups. This way I do not have to modify the project just to add PLC logging points. This strategy works because I mainly log the data for future analysis.
Now I realize that I will have to make major changes if I move to the new historical logging feature but that is the price for improved performance.
The biggest problem is, I do not know how to overcome the next feature.
When a process engineer is analyzing the data (in the easy chart component) for a new product he clicks on a point when the process was stable and then clicks a “Generate Report” button. This button script reads the x axis timestamp and passes it to a report window using the reporting plugin. The report window uses the timestamp to query all the tables for values at that time then prints a report.
My question is this:
Is there a way to use the new historical feature with what I am currently doing? Specifically, how would I query the new tables for data?
I have not played with this feature yet because our existing server is “getting full” and IT does not not want me to experiment until they upgrade. As a result I am just speculating on how to do it.
What are your thoughts on this topic?