About this task
Historian Alarm and Event data can be exported as XML or CSV files or to a new worksheet. Exporting alarm and event data is similar to querying alarm and event data, and generally has the same query types and criteria.
To export alarm and event data in the Historian Excel Add-In:
Procedure
- From the Historian menu, choose Administration and then Export Alarms. The Historian Alarm Export dialog will appear.
- Select a Server. Your default server should be selected.
- Select a Query Type.
- Select Query Criteria.
- Select your Output settings and maximum results.
- Select your Export Options:
- To New Worksheet will export the alarm and event data to a new Excel worksheet with the supplied file name.
- To CSV File will export the alarm and event data with comma separated values to a new file with the supplied file name.
- To XML File will export the alarm and event data to a new XML file with the supplied file name.
- Click OK to export.