Event Data Export Formats

Owned by Stonebranch (Deactivated)
Jul 03, 2023
2 min read

Overview

UES event data is exported from Universal Enterprise Controller's UES database using the UECLoad utility.

There are three formats for UES exported data:
 

XML

Event data is exported as an XML (extensible markup language) document. XML is often used for exchanging data between two systems.

CSV

Event data is exported as a CSV (comma separated value) text file. The CSV file can be used by most spreadsheet software, such as Microsoft Excel.

ARC

Event data is exported in ARC (archival) format for long-term storage. The exported ARC format data (written in UTF-8) is portable between operating systems with differing code pages.

Exported Fields

Exported event data includes all the event fields defined by the event record including the event header and event body.

Additionally, two other fields are exported that are maintained by Universal Enterprise Controller:

  • agentName is the name of the agent assigned to the agent definition in UEC.
  • agentUuid is the UUID that identifies the Universal Agent installation. The UUID is provided by the Universal Broker and remains the same for the life of the Broker installation. Note that if the product is uninstalled and reinstalled, or the Broker databases are deleted, a new agent UUID is generated.

XML Format

The XML (extensible markup language) format consists of an exported document enclosed in an export tag. Each event record is enclosed in a record tag. The event fields are enclosed in tags named after the field name.

Date and time formats are specified as:

yyyy-mm-ddThh:mm:ss

The date and time are separated by the character T.

CSV Format

The CSV (comma separated value) format consists of all event records exported as a row and all event fields as a column in the CSV file. The first row is a column heading row.

Since all event records are exported in the CSV file, there is a column for each event field for all the event types. This produces a large number of columns of which only a subset pertain to any particular row (event record). The column names are based upon the event field name.

Due to limitations in CSV date and time formats, two columns are produced for all date and time fields. The column names are appended with _date and _time for the date portion and time portion, respectively.

ARC Format

The ARC (archival) format data is used internal to the product only. It can be read by UECLoad and exported into either XML or CSV formats.