Import history data

You can use the Historian Data Importer (aahImport.exe) to import history data from these types of files:

• InTouch history (LGH) file
  Before you perform the import, review the requirements in Importing data from an intouch history file.

• CSV file
  You must format the CSV file according to the "FastLoad" format. For more information, see Import data from CSV files.

You can run the Historian Data Importer from a command prompt. For more information, see Run the Historian data importer from a command prompt.

To import history data

1. On the Windows Start menu, point to Programs, point to AVEVA, point to AVEVA Historian, and then click Data Import. The Historian Data Importer dialog box appears.

   

2. In the Historian server box, type the name of the Historian into which you want to import history data.

3. In the Security area, provide a logon account that is an administrator for the AVEVA Historian.

   • Click Current User to use the account of the currently logged on Windows user to connect to the AVEVA Historian.

   • Click Alternate remote user to use a different Windows account to connect to the AVEVA Historian.

4. In the Path usage area, specify the location of the files to import.

   1. To import a single file, click Single file import and then click Browse to select the file.

   2. To import multiple files, click Import all files added to folder and then click Browse to select the folder that contains all of the files.

      The folder you select becomes a "watched folder." Any files you place in the folder at any time are automatically processed until you change the folder configuration or change to a single file import.

   3. If you are importing .lgh files, select the Import LGH files for the InTouch application on node check box and then select the name of the InTouch node (computer) from which you want to import data.

      Note: If the desired node is not listed, you need to first import the tagname database. For more information, see Importing an InTouch data dictionary.

5. In the Import Method area, specify how to integrate the data into storage.

   Append new values (streamed)

   The data in the import file must be ordered according to timestamp. If you are importing multiple files, you must start with the oldest first. That is, if there are two files containing data for the same tags, but from different time periods, the file with the oldest data must be imported first, followed by the newer data. Other data collection mechanisms (for example, SQL INSERTs, data sent from Application Server, or from a Historian SDK application) may interfere with streamed imports if they ever supply values newer than the file data.

   When it is processed on the Historian server, streamed data is exposed through the Historian IO server, Historian IO (classic) server, the Live extension table, the History table, and other extension tables.

   Insert missing values in the past (non-streamed)

   The data in the import file must be ordered according to timestamp. However, if you are importing multiple files, you can import the files in any order.

   Non-streamed data will not be reflected in the Historian IO server, Historian IO (classic) server, or in the Live extension table, but can be queried from the History table and other extension tables.

   For more information on the different categories of data, see Data categories in the AVEVA Historian Concepts Guide.

6. For the Store Forward Path box, click Browse to select a folder in which processed data collects if a disconnect to the Historian occurs after the data transfer to storage starts. After the connection is restored, the data transfer resumes.

7. Click Process.

   The results of the import are shown in the Log window. Errors are logged to the ArchestrA Logger. If the utility can’t process a file, the file moves into a support folder that is automatically created.

   Note: The history importer does not report whether the data in the resultant CSV files is successfully imported into the AVEVA Historian extension tables.

8. Click Close.