Importing Alarms and Events Data in the Excel Add-in

About this task

Alarms and Events data can be imported into Historian through the Excel Add-In. This is useful to include alarms and events 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 alarms and events data in the Historian Excel Add-In:

Procedure

  1. Create a new Excel spreadsheet and populate it with your alarms and events 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 window appears confirming the completion of the import function. Select OK to close the window.
    Note: If errors occur on the import, a window appears detailing the issues encountered in the import. If an error occurs in any line of the import, the whole import is aborted.