Exporting Alarms and Events Data in the Historian Excel Add-In

About this task

Historian Alarms and Events data can be exported as XML or CSV files or to a new worksheet. Exporting alarms and events data is similar to querying alarms and events data, and generally has the same query types and criteria.

To export alarms and events data in the Historian Excel Add-In:

Procedure

  1. From the Historian menu, choose Administration and then Export Alarms. The Historian Alarm Export window will appear.
  2. Select a Server. Your default server should be selected.
  3. Select a Query Type.
  4. Select Query Criteria.
  5. Select your Output settings and maximum results.
  6. Select your Export Options:
    • To New Worksheet will export the alarms and events data to a new Excel worksheet with the supplied file name.
    • To CSV File will export the alarms and events data with comma separated values to a new file with the supplied file name.
    • To XML File will export the alarms and events data to a new XML file with the supplied file name.
  7. Select OK to export.