Exporting Messages

About this task

The Exporting Messages function lets you find messages and export them from the server to your worksheet or to a CSV or XML file. You can specify the server and select the messages to be exported by specifying a start time, an end time, or a text string, using standard wildcards, where applicable.

You can also select which fields of the messages are exported, such as time stamp, topic, message string, message number, substitutions, or username.

Procedure

Select Administration and then select Export Messages from the Historian menu.
The Export Messages From Historian window appears.
Select a server from the drop-down list. If you do not specify a server, the Add-In uses the default server.
In the Topic field, select one of six types of messages from the drop-down list.
In the optional Filter Criteria fields, enter values for start time, end time, and search text string in the appropriate fields.
In the Fields to Export section, select one or more field names from the displayed list.
To select multiple individual tags, press the Control key and select the tagnames. To select a sequence of tags, press the Shift key and select the first and last tagname of the sequence.
In the Export Options section, select one of three options:
- To New Worksheet
- To CSV File
- To XML File
If you select To CSV File or To XML File, you must enter a file name and path for the new file in the File Name field.
Select OK to initiate the export. Select Cancel to abort the operation.