Find Out How

Print Friendly Version

Exporting Results

Result objects can be exported into a variety of formats:  SOASTA XML Definition, Comma Separated Value (CSV), XML Spreadsheet (which can be read by Excel) as well as RSS 2.0 files.

  

To export a result:

  1. In the Central list, find an existing result either under Central > Recently Played or under Central > Test Compositions in the Compositions list. Click the Expand icon for the given test composition to display its listed results.

You can expand the results under a given test composition in the list by clicking the arrow key next to its name.
  1. Click the Etc. (...) button on the toolbar or select and right-click the result item and then choose the Export command. The Export dialog box appears.

  1. Next, choose an export format.

When you choose CSV, XML Spreadsheet, or RSS, then another drop down will display for Data Source selection.

In the example on the right, the CSV option is selected, with the available data sources appearing in the drop-down.

The Data Source list will contain the following choices:

Note: Exported results are not available for the export format, XML Definition.

  1. Press the OK button. The standard Browser download dialog will display.
  

Export Result Tables

For the selections in the Data Source drop-down list above, the following fields are exported:

Clip Element Details

This export contains information for each clip element executed during the test. It contains one row for each message or script or other element executed during the test. This information is only available if the test was run with “Save Clip Element Details” turned on.

  • Band Name – The band in which this test clip was executed.
  • Band Index – The index of the band in the test composition.
  • Track Name – The name of the track in the test composition.
  • Track Index – The index of the track in the test composition.
  • Clip Name – The name of the test clip in the test composition.
  • Clip Index – The index of the test clip in the composition.
  • Chain Name – The name of the chain in the test clip.
  • Chain Index – The index of the chain in the test clip.
  • Clip Element Name – The name of the clip element in the test clip. For example, Message1.
  • Clip Element Index – The index of the given clip element within the test clip.
  • Clip Element Type – The type of clip element, such as message, browser action, delay, checkpoint, or chain.
  • Target Name – The target name for the given clip element.
  • Operation – The type of operation. For example, in a SOAP-based WSDL.
  • Server – The test server that ran this clip element.
  • Location – The location that was defined for the given test server.
  • Start Time – The time the clip element was fired
  • Send Time – The time the clip element was sent.
  • Receive Time – The time the clip element was received.
  • Connection Establish Time – The time at which a connection was established to the target site.
  • Response Time – The time at which a response was received for the clip element.
  • Delta From Scheduled Time – The difference between the scheduled time and the actual time.
  • Delta Scheduled Duration – The difference between the scheduled duration from send to receive and the actual one.
  • Validation Error – The number of validation errors.
  • Bytes Sent – The bytes sent for the given clip element.
  • Bytes Received – The bytes received for the given clip element.

Time Aggregate

This export contains aggregated information for each second of the test. There is one row for each second. The fields are:

  • Start Second – the second offset into the test using a ‘round up’ method. For example a message sent at 3.454 of the test will be included in the Start Second of ‘4’.
  • Message and BrowserActions Count – Number of messages plus browser actions processed in this second.
  • Send Count – the number of messages successfully sent during this second.
  • Receive Count – the number of messages received during this second
  • Total Response Time – the sum of the response times for every message sent during the second. Only messages which are successfully sent are included.
  • Avg. Response Time – calculated as Total Response Time divided by Send Count
  • Min. Response Time – the minimum response time sent during the second. Only messages which are successfully sent are included.
  • Max. Response Time - the maximum response time sent during the second. Only messages which are successfully sent are included.
  • Total Time - the sum of the Total times for every message attempted to send during the second. Timeouts and other times are included.
  • Min. Total Time - the minimum of the Total times for every message attempted to send during the second. Timeouts and other times are included.
  • Max. Total Time - the maximum of the Total times for every message attempted to send during the second. Timeouts and other times are included.
  • Bytes Sent – The Total number of bytes sent for each message successfully sent during the second.
  • Bytes Received – the Total number of bytes received for every message received during the second.
  • Total Errors – the Total number of messages with errors for messages attempted to send during the second.
  • Total Scripts - the Total number of scripts executed during the second.
  • Total Error Scripts - the Total number of scripts with errors executed during the second.

Clip Element Aggregate

This export contains aggregated information for every clip element in the test. There is one row for each clip element and error combination.

  • Clip Name – The name of the test clip in the test composition.
  • Clip Element Name – The name of the clip element in the test clip. For example, Message1.
  • Error – Displays the error text (or NONE if no error).
  • Clip Element Type – The type of clip element, such as message, browser action, delay, checkpoint, or chain.
  • Count – The count of clip elements. For example, eight for a message with eight repeats.
  • Send Count – The send count for the clip element. For example, eight messages sent.
  • Total Response Time – The sum of response time for the clip element. For example, 3517.
  • Avg. Response Time – The average response time for the clip element. For example, 439.
  • Min Response Time – The minimum response time. For example, 199.
  • Max Response Time – The maximum response time. For example, 873
  • Total Time – The total time for the clip element, including send and receive. For example 3519.
  • Min. Total Time – The minimum total time. For example, 199.
  • Max. Total Time – The maximum total time. For example, 873.
  • Bytes Sent – The sum of bytes sent for the given clip element.
  • Bytes Received – The sum of bytes received in response to the given clip element.
  • Total Errors – The sum of errors for the given clip element.
  • Validation Errors – The sum of validation errors for the given clip element.

Clip Details

This export contains information for each clip executed during the test. It contains one row for each clip instance. This information is only available if the test was run with "Save Clip Element Details" turned on in the composition's results logging properties. See Results Logging and Play Modes.

  • Band Name – The band in which this test clip was executed.
  • Band Index – The index of the band in the test composition.
  • Track Name – The name of the track in the test composition.
  • Track Index – The index of the track in the test composition.
  • Clip Name – The name of the test clip in the test composition.
  • Clip Index – The index of the test clip in the composition. For example, in a test composition with three clips, 0, 1, or 2.
  • Error – The error text (or NONE if no error).
  • Type – The type of test clip. For example, a MessageClip.
  • Completion Status – The completion status. For example, Playing or Completed.
  • Message Response Count – The number of message responses received.
  • Total Message Response Time – The sum of response times.
  • Min. Msg. Response Time – The minimum time a response took to be received.
  • Max. Msg. Response Time – The maximum time a response took to be received.
  • Bytes Sent – The sum of bytes sent for the given clip.
  • Bytes Received – The sum of bytes received in response to the given clip.
  • Duration – The duration of play for the test clip.
  • Start Time – The time at which the clip was fired.
  • Message Count – The count of messages in the clip.
  • BrowserAction Count – The count of browser actions in the clip.
  • Script Count – The count of scripts in the clip.
  • Checkpoint Count – The count of checkpoints in the clip.
  • Delay Count – The count of time delays in the clip.
  • Effective Duration – The effective duration of the clip.

Chain Details

This export contains information for each chain executed during the test. It contains one row for each chain instance. This information is only available if the test was run with "Save Clip Element Details" turned on.

  • Band Name – The band in which this test clip was executed.
  • Band Index – The index of the band in the test composition.
  • Track Name – The name of the track in the test composition.
  • Track Index – The index of the track in the test composition.
  • Clip Name – The name of the test clip in the test composition.
  • Clip Index – The index of the test clip in the composition.
  • Chain Name – The name of the chain.
  • Chain Index – The index of the chain in the test clip.
  • Error – The error text (or NONE if no error).
  • Type – The chain type.
  • Completion Status – The completion status. For example, Playing or Completed.
  • Message Response Count – The number of message responses received.
  • Total Msg. Response Time – The total message response time.
  • Min. Msg. Response Time – The minimum message response time.
  • Bytes Sent – The sum of bytes sent for the given clip.
  • Bytes Received – The sum of bytes received in response to the given clip.
  • Duration – The duration of play for the test clip.
  • Start Time – The time the chain was fired
  • Message Count – The count of messages in the clip.
  • BrowserAction Count – The count of browser actions in the clip.
  • Script Count – The count of scripts in the clip.
  • Checkpoint Count – The count of checkpoints in the clip.
  • Delay Count – The count of time delays in the clip.
  • Effective Duration – The effective duration of the clip.

Clip Aggregate

This export contains aggregated information for each clip executed during the test. It contains one row for each clip/error/completion status/Start Time combination regardless of how many times that clip was executed during the second or from which track or band it was executed.

  • Clip Name – The name of the test clip in the test composition.
  • Error – The error text (or NONE if no error).
  • Completion Status – The completion status. For example, Playing or Completed.
  • Start Second – The second when the given clip started.
  • Count – The count for the clip aggregate.
  • Total Duration – The total duration for the clip aggregate.
  • Min. Duration – The minimum clip duration.
  • Max. Duration – The maximum clip duration.
  • Total Msg. Response Time – The total message response time.
  • Min. Msg. Response Time – The minimum message response time.
  • Max. Msg. Response Time – The maximum message response time.
  • Message Response Count – The count of messages responses.
  • Bytes Sent – The sum of bytes sent.
  • Bytes Received – The sum of bytes received.

Chain Aggregate

This export contains aggregated information for each chain executed during the test. It contains one row for each clip/chain/error/completion status/Start Time combination regardless of how many times that chain was executed during the second or from which track or band it was executed.

  • Clip Name – The name of the test clip in the test composition.
  • Chain Name – The name of the chain in the test clip.
  • Error – The error text (or NONE if no error).
  • Completion Status – The completion status. For example, Playing or Completed.
  • Start Second – The second when the given chain started.
  • Count – The count for the chain.
  • Total Duration – The total duration for the chain.
  • Min. Duration – The minimum chain duration.
  • Max. Duration – The maximum chain duration.
  • Total Msg. Response Time – The total message response time.
  • Min. Msg. Response Time – The minimum message response time.
  • Max. Msg. Response Time – The maximum message response time.
  • Message Response Count – The count of message responses.
  • Bytes Sent – The sum of bytes sent.
  • Bytes Received – The sum of bytes received.

©2010 SOASTA, Inc