Exporting Events

In this topic:

The Dashboard lets you export data from the Events window to several standard file formats, allowing you to view and manipulate the data using other programs. You can export:

Events data from the Events grid
Event Contents (for Email, Chat/IM, or Keystroke events)
Summary data from the Summary pane
Aggregated data from data covered by the Navigate tree

To export:

Click one of the Export buttons, or open the File menu and select Export.
From the Export submenu, choose:
Events: Data in the Events grid
Summary: Data totals in the Summary pane for currently selected Navigate branch
Aggregates: Data totals for the entire Navigate tree with events aggregated, either in a flat table or grouped in the Navigate tree (data grouping) hierarchy.

For Chat IM/Email/Keystroke events, you can choose to export the content of the activity:
Export Messages
Export Email
Export Keystrokes

An Export dialog box opens.
Choose a file location and enter a file name. Select a file type (see below) and click Save.

Exports from the Events and Summary panes contain exactly what is shown in the pane. To change what is shown, you can select a different data group, change the grouping, or hide/show columns.

Data Export File Types

The following file types are available for Events window exports.

Microsoft Excel (.xls): View the export as a spreadsheet using Microsoft Excel.
HTML (.html): View the export as a web page using a web browser.
Text (.txt): View the export data with any text editor or word processor.
Unicode Text (.txt): View the export with any editor or word processor that supports unicode characters (Chinese, Japanese, etc.).
XML Document (.xml): Handle the export data as needed and view as a textusing a web browser.
Rich Text Format (.rtf): Open and view the export in Microsoft Word.
Electronic Mail file (.eml): View the export using Microsoft Outlook or another Email client.

Save as type:	Chat/IM Messages	Email Messages	Keystroke Contents	Events	Summary	Aggregate
MS Excel (.xls)				X	X	X
HTML (.html)	X	X		X	X	X
Text (.txt)	X	X	X	X	X	X
Unicode (.txt)			X
XML (.xml)				X	X	X
RTF (.rtf)			X
Email (.eml)		X

Export Events

The Events grid shows each recorded event that has been loaded for a selected Navigate or Summary item. The Events grid provides all types of data captured in the recording. See "Understanding Recorded Events" in this guide to learn what information is included for each activity type. Be sure to select a Navigate or Summary item and click Load Events to display data in the Events grid.

Export Event Contents

Chat/IM, email, and keystroke event recordings include the content viewed or entered by the user.

Export Summary

The Summary pane summarizes the event data for the item selected in the Navigate pane. For example, you can see the total number of keystrokes from each user.

Export Aggregates

Export Aggregates saves all data currently represented by the Navigate tree. Events are shown either in a flat grid or in a hierarchy that mirrors the data grouping hierarchy. Select a "Grouped" aggregate export when you select the export file type.

For example, exporting Program Activity to Microsoft Excel (*.xls) format produces the following data grid in Excel format.

Exporting the same activity to Microsoft Excel (*.xls) - Grouped produces the following hierarchical data grid in Excel format.