Export Statistics Listing (kourier_ktruntimestats_listing.aspx)


Purpose

This report displays the runtime statistics associated with Standard or SQL exports. It can be very helpful when monitoring the actual processing time required for exports.

File/Key Field

KT_RUNTIME_STATS/ID

Prerequisites

One or more exports must have been processed via a Service in order to capture the runtime statistics.

Cautions

None

Report Filters

This report may be filtered using the following Quick Filters: Integration, Export Mode, and Export. Click the filter icon in the command bar to enter additional filter criteria.

The Integration filter displays a list of all Integrations used for existing export specifications. Selecting an Integration from the drop down list will display only export specifications that match the chosen integration and limit the selections available from the Export filter. Select "(All)" to show all export specifications. Note, the chosen integration will be maintained when you view other listings with an integration filter.
The Mode filter displays the three export modes available when processing exports: Full, Net, or  Netd. Selecting Full will limit the runtime statistics to only showing those exports that were processed with Full refresh mode. Selecting Net will limit the runtime statistics to only showing those exports that were processed with Net Change refresh mode. Selecting Netd will limit the runtime statistics to only showing those exports that were processed with Net Change with Deletes refresh mode.  Select "(All)" to show all export specifications.
The Export filter displays a list of all Exports that have been created. If an integration has been selected from the Integration Filter, then only exports associated with that integration will be displayed. Select "(All)" to show all exports.
Click the Export Statistics filter to display a page with multiple fields that provide many options for filtering the Export Statistics Listing .

Report Fields

ID The internal record id for the export statistic item. You may click the ID to view the individual statistic information in form view.
Export A unique name for the export specification. By convention, exports are named using an Integration ID such as KS for KommerceServer, followed by an underscore and a string that describes its purpose (e.g., KS_CONTACTS)
Mode The mode the export was processed using: Full (full refresh), Net (net change), or Netd (net change with deletes).
Start The date and time when the export began processing in the format: MM/DD/YYYY HH:MM:SS.
End The date and time when the export completed processing in the format: MM/DD/YYYY HH:MM:SS.
Elapsed The total elapsed runtime in HH:MM:SS for the export.
Records The total number of records processed for the export.
Rows The total number of rows processed for this export. Note, the number of rows processed may be higher than the number of records. This would indicate that there was data normalization during the process.
Byes The total number of bytes processed for the export.
File The name of the actual file that was generated for the export. If you view the export statistic in form view (by clicking on the ID) you will be able to see the full file name including the path.

User Guide - Table of Contents