CygNet History Export Utility

Use the CygNet History Export utility to export data from the VHS to a comma-separated values (CSV) file. Export definitions are saved in a .cex file so that you can schedule the export or run it at a future date.

Data can be exported in its raw form or in a rollup form. The VHS stores data in "raw" form. That is, only the values that were sent to the VHS are stored in the VHS. "Rollup" data is raw data that is condensed by thinning or calculation. An example rollup is thinning the raw values to the minimum and maximum values for every hour. You can specify the rollup type on a per tag basis.

Note: See CygNet Excel Export for another method for exporting data directly to Microsoft Excel.

CygNet History Export can be installed using the CygNet Client Installer. In most installations, it may be found in the CygNet\Utilities directory (CExport.exe) on the host server.

Starting CygNet History Export

Installing and Launching

To install and launch (start) the application or utility using version management:

Use CygNet Client Installer to install and launch the application. Once installed you can use CygNet Client Installer to start the application.

-OR-

If previously installed, click Start > All Programs > CygNet > <name of the application or utility> or double-click the desktop shortcut.

Alternatively, browse to the CygNet\Utilities directory using Windows Explorer and double-click the program icon. You can also start an application or utility from a command line. These methods do not provide version management.

The CygNet History Export dialog box appears.

CygNet History Export

To Define and Run an Export

Define the export properties on the Values, Tags, Layout, and Export File pages.
Save the export definition (File > Save/Save As or ) .
Export the data (File > Export/Export As or ).

CygNet History Export Utility User Interface

The CygNet History Export utility user interface includes a Menu Bar, a Toolbar, four configuration pages, and a Status Bar.

Menu Bar and Toolbar

Menu options are contained in the following menus: File, View, and Help. The CygNet History Export utility toolbar contains the following icons.

CygNet History Export Toolbar

File Menu

The File menu contains the following options to help you manage the export definitions created by the utility.

Menu Option	Description	Shortcut
New	Create a new export definition.	Ctrl+N
Open	Open a previously saved export definition file.	Ctrl+O
Save	Save an export definition file.	Ctrl+S
Save As	Save current settings to a new export definition file.	Alt+F+A
Export	Export VHS data to the CSV file specified in the export definition using the configured settings.	Ctrl+E
Export As	Export VHS data to a different CSV file to the one specified in the utility.
Export Preview	This option is not implemented.
Exit	Exit the CygNet History Export utility.	Ctrl+E

View Menu

The View menu contains options for showing and hiding UI elements.

Menu Option	Description	Shortcut
Toolbar	Hide or Show the toolbar.
Status Bar	Hide or Show the status bar. The status bar displays tooltips for buttons in the tool bar.

Help Menu

The Help menu opens About information.

Menu Option	Description	Icon
About CygNet History Export…	Displays an About CygNet History Export Application dialog box to view application information. Available information includes the following: The application name, version, and release date Copyright information The CygNet Software website address, including a hyperlink to the website The log file location, including a hyperlink to the log file The location of the application's file executable In addition to information about the application, the About box includes the following buttons: Client Settings — opens the Client Settings dialog box to view and modify client log settings for the application on an ad hoc basis. See Client Log Settings in the Logging section for more information. Diagnostics — access the following options for additional analysis from the drop-down menu: Loaded Modules — use this option to view and search file information for modules loaded in your system. Double-click any result row to view properties for that module. See Loaded Modules for more information. Gather Logs — accesses the Windows file directory where the open log files are located. Double-click to select and view an application log file. User Local Crash Dumps — Local crash dumps are not enabled. See Generating Crash Dumps for more information. Close — click to close the About box.

Menu Option

Description

Icon

About CygNet History Export…

Displays an About CygNet History Export Application dialog box to view application information.

Available information includes the following:

The application name, version, and release date
Copyright information
The CygNet Software website address, including a hyperlink to the website
The log file location, including a hyperlink to the log file
The location of the application's file executable

In addition to information about the application, the About box includes the following buttons:

Client Settings — opens the Client Settings dialog box to view and modify client log settings for the application on an ad hoc basis. See Client Log Settings in the Logging section for more information.
Diagnostics — access the following options for additional analysis from the drop-down menu:

Loaded Modules — use this option to view and search file information for modules loaded in your system. Double-click any result row to view properties for that module. See Loaded Modules for more information.
Gather Logs — accesses the Windows file directory where the open log files are located. Double-click to select and view an application log file.
User Local Crash Dumps — Local crash dumps are not enabled. See Generating Crash Dumps for more information.

Close — click to close the About box.

About

Configuration Pages

CygNet History Export has four pages to define the properties of an export:

Values Page — specifies the source of the data, the date range, and the type of data
Tags Page — specifies the names of the tags for which to export data
Layout Page — specifies what fields to export
Export File Page — specifies the name of the file to which the data will be exported.