Tag Report Utility

New resource just uploaded to the Exchange (pending review).

Also available here:

https://www.automation-pros.com/TagReportUtility/

I intend to publish at this link as well as in the Exchange going forward.

Announcements will be in this topic. (:

Highlights:

  • Provides a Perspective Popup View that provides a user interface to system.tag.query() that entirely replicates the functionality of the Designer's Tag Report Tool.
  • Provides a Perspective Embedded View that provides Time Span selection user interface with the controls needed to accurately and easily constrain to your requirements, while also satisfying the requirements of system.tag.queryHistory().
  • Provides numerous library scripts for tag manipulation, historian access, and alarm journal queries.

The above views are completely parameterized for easy repurposing within your own projects. As a demonstrator, the project also includes a Main Perspective View that drives tag history queries, alarm journal queries (via database only), Time Series Charting, and both Excel and zipped CSV export.

The historian queries intelligently extract the necessary information from remote tag providers to create well-formed Qualified Paths where necessary, and where the Storage Providers named in tag configuration are present with the same names locally.

The alarm querying function enumerates all tables in all database connections that have the structure of Ignition's alarm_events tables. These are all queried in parallel when searching for alarm events that belong to selected tags. (The journal results are deduplicated, too, in case there are aliased tables present.)

Documentation is a bit sparse at the moment. Will be poking at that in the near future.

14 Likes

Project file updated to fix a bug found in review. (Not having Toolkit v2.0.19 would try to throw a proper exception and log, but the Throwable import was also missing. :frowning_face: )

Also note that the resource includes no sample files. Presumably, your applications have historized tags you can point at.

2 Likes

Now approved, here:

The final review found another bug, in hour/minute/second adjustment of time spans. So be on the lookout for v1.0.1.

3 Likes

V1.0.1 has been published at my own server, and is under review on the Exchange.

Forgot to mention that the update was approved fairly quickly.

Meanwhile, I'm working on substituting Kyvis Lab's Apex Chart module for the native TS Chart component--the performance difference is mind-boggling. Will also try Musson's Embr Charts module.

There's some logging in the data handling that shows that even low tens of thousands of total data points will absolutely crush the browser side of the native TS Chart component. Like, 5-10 milliseconds to extract and reshape the raw data in pageVarMap() to that needed by the TS Chart's props.series and props.plots, then 10-15 seconds to display in the browser. Followed by horribly laggy X-Trace action on mouse movement. :frowning_face:

I don't have the Apex chart's subplotting done, so not a full test, but the basic Apex chart testing with the same raw data doesn't have any significant lag. (About the same props reshape time.) :smile:

Update just uploaded to the Exchange and to my own server. Fixes a bug when attempting to export results (Excel or CSV) when the tag collection involved had no alarm definitions at all. :frowning_face:

1 Like

DM me, I'll help collaborate.

1 Like