Open, Read & Export InTouch LGH file History Data in 3 Simple Steps

Export to CSV, Excel, or AVEVA Historian FastLoad format on demand or on automated schedules

LGH File Inspector for AVEVA InTouch (formerly Wonderware) enables scalable, fast access to local daily historical data files (*.lgh files) logged by AVEVA 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. 

lghinspector_infographic_700wx541h

 

FEATURES

  • Key Features
  • Step 1: Set Query Time Range
  • Step 2: Tag Selection
  • Step 3: Run Query & View Results
  • Export to Excel
  • Export to CSV
  • Query Automation
  • LGH File Set Management
  • Scalability
  • Multiple Time Zone Support
  • Data Gap Management
  • Advanced Features
  • Applications

Flexibility, Power & Ease-of-Use

lghfileinspector_ui

  • Visual interface, no scripting or coding
  • Automatic tag list discovery 
  • Display aggregate values in on-screen query results
  • View raw data behind your sampled data 
  • Export to Excel, including to template files for basic reporting
  • Export to CSV
  • Create AVEVA Historian FastLoad files 
  • On-demand or automated query options
  • Flexible options on query start date when queries launched on schedules or by external applications
  • Does not use the InTouch HistData utility and can query up to about 15 million values, far more than HistData

Easy Identification of the Right LGH Files and Data Query Granularity

  • finding_the_right_filesPick your query start date on the calendar
  • Or Pick an LGH file to see what date the data starts with.
  • Once you’ve picked your Query Begin Time, set the Query Duration you want in seconds, minutes, hours, days, weeks, or months
  • Set your Query Interval in seconds, minutes, hours, days, weeks, or months to get a close view or high level view of the data
  • Automated queries will dynamically update their date ranges based on when they are run

Searchable Tag Lists for Rapid Selection

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. 

Lgh-file-inspector-tag-selection-600w

 

Run Your Query & View Results

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-run-query-V35

 

Exports from basic to sophisticated 

send_grid_data_to-excelLGH File Inspector does a lot more than just export data and make Excel worksheets.

  • Create new or update existing worksheets
  • Specify the worksheet within a workbook
  • Update a specific worksheet within a specific workbook
  • Map data to specific cells in workbooks
  • Create or update workbook and
    • Show it after the query runs
    • Save and close it

 

CSV Universal Export Format

lgh-file-inspector-export-to-csv-v35-400wLGH File Inspector supports on-demand or scheduled/automated exports to the well known, universally compatible CSV format

  • Create new files
  • Append to existing CSV files
  • Include query begin date and time in the filename
  • Checkbox to support the AVEVA/Wonderware Historian FastLoad special 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

C:\InTouchData 2016-08-16-00-00-00.csv
C:\InTouchData 2016-08-16-01-00-00.csv
C:\InTouchData 2016-08-16-02-00-00.csv
C:\InTouchData 2016-08-16-03-00-00.csv

Save time and effort with repeatable tasks & results

  • lgh-file-inspector-advanced-query-settings-350wExecute Saved Queries Automatically without opening LGH File Inspector
  • Schedule queries to execute when needed to automatically
  • Scheduled queries can embed date/timestamps in filename.
  • Optional dynamic date range update based on query run time
  • Launch automated queries from other applications
  • Create new Excel Workbooks and/or Worksheets automatically, including creating a new file on each run
  • Add Worksheets to or update existing Workbooks and Worksheets within a Workbook! 
  • Create or append to CSV files
  • Generate AVEVA Historian FastLoad CSV files.
  • Generate InTouch history reports
  • Log files available for troubleshooting automated tasks

Organization for Multi-system/site or Multi-client applications

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.  Store as many file places as you want and edit them after creation. File Places also lets you store the timezone for those files.  Quickly access LGH File Places from the application status bar as shown here. 

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

LGH-file-inspector-New_File_Place_Area-350x80

Lgh-file-places-annotated-600w

Handling small to large datasets that others cannot 

  • scalability_graphUp to 1024 tags/columns in a single query
  • Up to approximately 15,000,000 data values in a single query
  • Leverage up to 4 CPU cores for fastest results such as 1.8 million data points in 150ms! 
  • Performance is a function of your LGH file size, local drive speed, available memory, and CPU speed
  • Save any number of query jobs for re-use on-demand or in automated tasks 
  • LGH File Places help manage large numbers of different file sets even in different time zones.
  • Use Multiple automated queries to generate regular Excel reports or CSV exports.
  • Multi-threaded high performance query execution

Manage LGH Files from Multiple Time Zones & Formats

  • Lgh-file-time-zone-settings-400wQuery in different time zones than the local machine without changing your machine's time settings!
  • Users are warned when LGH file sets they want to query are in a different time zone than their machine and given chance to update the time zone the application will use
  • When using saved LGH File Places, time zone settings are saved with the file location 
  • LGH File Inspector time formatting options to address global local time formats
  • Great for integrators 
  • Great for users with multiple regional sites 
  • Learn more in the LGH File Inspector Users Guide

Handling the reality of data gaps

blackout_datesWe know that everything in the real world is not perfect, and LGH File Inspector can handle the inevitable source data gaps.

  • Blackout dates on the calendar show you where there are gaps in your LGH files so that you can either go back to the source and make sure you have all the files, or easily know where you will have gaps in the data in your query
  • Exclude blank rows option allows you to skip reporting for time periods with no data for any of the tags in your query.

View Raw Data, Display Aggregate Calculations

Starting with LGH File Inspector 3.5 and higher, users gain further insight into their data and can add value it on the fly.

  • Raw Data View - Pick a range, view the underlying data to see if you need to sample at a different rate
  • Aggregates - Get calculations on a range of data by just highlighting the data range

Screenshot_LGH_File_Inspector_Aggregates_Example

 

Learn More

One tool, many applications besides just CSV & Excel Export

RESOURCES

  • System Requirements
  • Documentation
  • Release Notes
  • Technical Blog

Operating System Support, System Requirements & InTouch Compatibility

  • LGH Files created by InTouch versions up to AVEVA InTouch 2022.  InTouch 2023 has longer maximum tagnames and we are investigating support for that version and will update here when available.
  • Windows Desktop: Vista, 7 SP1, 8.x, 10, and 11 (x86 and x64)
  • Windows Server 2008 SP2 x86 & x64, 2008 R2 SP1 (x64)
  • Windows Server 2012 & 2012R2
  • Windows Server 2016, 2019, 2022
  • .NET Framework 4.5 or higher 
  • Multi-core processor with at least 2 Gb of RAM free and 60 Mb disk space. Large queries and datasets will benefit from faster processors and more free memory up to the Windows 32-bit application memory limit of 3 Gb. If you plan to run queries approaching the ~15 million data point limits of LGH File Inspector you will see short term memory usage exceeding 2 Gb, plan accordingly. 

LGH File Inspector Documentation

lgh-file-inspector-users-guide-250hLGH File Inspector installs with an extensive PDF users guide that shows all configuration, operation and setup of the product from simple to advanced.

You can also download the LGH File Inspector Users Guide for review without installing the product. 

 

LGH File Inspector Release Notes

Full release notes are available for download in our knowledgebase. 

Download LGH File Inspector Release Notes

Technical Blog

lgh-file-inspector-technical-blog-overview-300wThe Software Toolbox technical blog has a dedicated section for LGH File Inspector where we share application tips, use cases, and release update details. 

Visit the LGH File Inspector Blog

Users Trust LGH File Inspector and Software Toolbox Support

lgh-file-inspector-user-logo-wall_v2

 

Get Started Now

All features are available in trial mode. In trial mode, each query is limited to 25 tags and 100 rows. You can execute 25 total queries prior to purchase. Purchasing a license key removes all limitations. 

Connect with Us

1-888-665-3678 (US + Canada toll free)
+1-704-849-2773 (Global)
support.softwaretoolbox.com