Importing data from an intouch history file

The Historian Data Importer (aahImport.exe) is a stand-alone utility that allows you to import existing InTouch history data into the AVEVA Historian history blocks. InTouch history data is stored in one or more .lgh files located in the InTouch application folder.

Before you start the import, be sure that:

• You can access the LGH files (that is, files having an .lgh filename extension). The InTouch HMI software is not required to be installed on the same computer as the InTouch History Importer, and InTouch is not required to be running. The importer can import history data generated with InTouch HMI software version 7.0 or later.

• The tag definitions already exist in the AVEVA Historian database. The easiest way to make sure that you have all of the definitions is to use the AVEVA Historian Tag Importer to import the contents of the InTouch tag database. For more information, see Importing an InTouch data dictionary.

• You can log on to the AVEVA Historian. The InTouch History Importer requires a logon account to the Historian to retrieve a list of all currently imported InTouch nodes.

• The full path to the InTouch LGH files (including the name of the actual LGH file) is not longer than 64 characters. This limitation is inherent in the underlying InTouch infrastructure used to access LGH files. If the path is longer than 64 characters, the importer produces an error message and prevents the import from continuing. If necessary, use a mapped drive or a drive substitution to shorten the name of the path.

• The InTouch application is not currently storing data to the LGH file that you plan to import.

• You change the value of the AllowOriginals system parameter to 1. This allows you to insert original data for I/O Servers. For more information on editing system parameters, see Edit system parameters.

• The data you want to import does not interfere with data in the current history block for the same tags. For example, suppose you import tag definitions from an InTouch application and are currently storing the tag values received from the I/O Server in the Historian. If you attempt to import existing InTouch data for these same tags, and the timestamps of the data to be imported fall within the current history block, the import may produce unexpected results. Wait until the next history block is created before attempting to import existing InTouch data.

• If you have a large amount of data to import, process the data in batches, starting from the most recent data to the oldest data. For example, you want to import one year's worth of InTouch history. Divide up the data so that one month of data is included in a batch. When you import the most recent batch, the utility automatically starts with the most recent block and then proceeds backwards. Then, import the second-most recent batch, and so on.

The fast load import mechanism used by the InTouch History Importer is intended for importing data into history for periods where no data for the tags currently exists. For delta stored tags, importing into a region where data already exists results in the addition of the new points. For cyclically stored values, however, the new points are imported on top of the existing cyclic values. For more information on fast load imports, see About fast load CSV file imports.