Ways to acquire history data

You can import, insert, and update history data in various ways.

• Import InTouch history data with Historian Data Importer
  If you have existing InTouch history data, you can easily import it into the AVEVA Historian extension tables using the Historian Data Importer utility. See Importing Data from an InTouch History File.

• Import a CSV file with Historian Data Importer
  You can create a CSV file for the data and then use the following methods to import it. See Import data from CSV files.

  • Use the Historian Data Importer to select and import the CSV file.

  • Use the Historian Data Importer to create a "watch" folder that you drop CSV files into. For more information, see Encode formats for configuration exports.

  • Drop CSV files into the predefined \DataImport watch folder.

• Insert or update history data with Transact-SQL statements
  With INSERT and UPDATE statements, you can insert or update history data in the AVEVA Historian extension tables. See Inserting or Updating Data with Transact-SQL Statements.

• Rename tags with Tag Rename utility
  With this tool, you can rename tags. See Renaming Tags.

You can track modifications to history data. For more information, see Modification Tracking for Historical Data Changes.