LGH File Inspector for AVEVA InTouch (formerly Wonderware) enables scalable, fast access to local daily historical data files (*.lgh files) logged by Wonderware InTouch HMI and SCADA applications without the limitations imposed by other solutions.
LGH File Inspector is the easiest, fastest, and most scalable way to extract data from those files for reporting, analysis, integration to other solutions, and more.
LGH File Inspector uses a visual interface and does not require scripting, complicated setups, or migrating the data to historian tools to get the information you need from your InTouch systems.
Once you've set your timeframe for your query, and LGH file inspector has given you the list of available tags across the fileset, showing you dates with missing data, etc. you can pick the tags to query. Using Shift+Click and Ctrl+Click, plus the matching search capability, you drag and drop the tags to the lower query window. You can save your query for re-use and/or later editing.
Click the Run Query button to generate a preview of your results, and then once you like those results you can send them to the supported formats, make adjustments to your settings, or use the advanced settings to setup your query for use as a scheduled job.
LGH File Inspector does a lot more than just export data and make Excel worksheets.
LGH File Inspector supports on-demand or scheduled/automated exports to the well known, universally compatible CSV format
For example, you could automate a query to extract the previous hour’s worth of data and include the query beginning date and time in the filename. Each hour, the query would execute and export the results to a new CSV file with a unique filename that represents the time frame of the data it contains. File names would look like the following assuming a query base filename of C:\ InTouchData.CSV. The date format is configurable using a setting in the app config file covered in the LGH File Inspector documentation.
For users with multiple sets of LGH files or system integrators with multiple clients, the LGH File Places feature makes it easy to associate a friendly file path to a location for a set of LGH files. You can store as many file places as you want and edit them after creation. File Places also lets you store the timezone for those files.
For best performance, especially with large file sets, it's best to work on a local copy but you can link to LGH file sets across the network, which we cover in our LGH file data from remote InTouch systems technical blog post
We know that everything in the real world is not perfect, and LGH File Inspector can handle the inevitable source data gaps.
You can also download the LGH File Inspector Users Guide for review without installing the product.
The Software Toolbox technical blog has a dedicated section for LGH File Inspector where we share application tips, use cases, and release update details.