Importing Alarm and Event Data in the Excel Add-in

About this task

Alarm and Event data can be imported into Historian through the Excel Add-In. This is useful to include alarm and event data into the Historian archive that is not normally collected by Historian or when you are migrating data from an older system into Historian.

Note: The Excel worksheet must contain source and timestamp columns as a minimum.

To import alarm and event data in the Historian Excel Add-In:

Procedure

  1. Create a new Excel spreadsheet and populate it with your alarm and event data.
  2. From the Historian menu, select Administration and then Import Alarms.
    A message box appears.
  3. The Historian Excel Add-In will attempt to import the current worksheet. If successful, a dialog box appears confirming the completion of the import function. Click OK to close the dialog box.
    Note: If errors occur on the import, a dialog box appears detailing the issues encountered in the import. If an error occurs in any line of the import, the whole import is aborted.