Export Multiple Results to CSV or XML Spreadsheet Format

Document created by Chris Sommerstad Employee on Jul 22, 2017
Version 1Show Document
  • View in full screen mode

Users can export multiple results to a CSV file or XML Spreadsheet. The resulting export will present one row per result and the resulting spreadsheet contains the name, composition name, path, status, dates, and lots of total metrics. Many results can be selected for this type of export and they will all be in the same CSV file.

  1. In the Central > Composition list expand the composition(s) to select from among their results.

  1. Right click the selection to access the Export command.
  2. In the Export dialog box, first select either the CSV or XML Spreadsheet export format, and then set the Data Source to "Basic Information."

  1. Click OK to complete the export.

  1. Open the exported CSV in your spreadsheet application to examine its columns. Apply application-specific formatting to fix up the text, if desired.

For the Basic Information selection in the Data Source drop-down, the following fields are exported:

Basic Information (for Actions)

This export contains information for each test result selected with each result representing a row.

  • Result Name – The result to which the data in the row corresponds.
  • Composition name at execution time – The name of the composition in this result.
  • Path – The repository path of the composition. For example, /SOASTA Tutorial/Advanced/Composition for Fools Mate Clip.
  • Status – The completion status. For example, Playing or Completed.
  • Start – The time the composition was fired.
  • End – The time the composition status became "Completed."
  • Effective Start – The time when messages/actions were first sent.
  • Total Time – the sum of the Total times for every message/action attempted to send. Timeouts and other times are included.
  • Result Name – The name of the result in the row.
  • Browser Actions – The number of browser actions, if any.
  • Error Browser Actions – The number of browser actions that produced errors, if any.
  • Checkpoints – The count of checkpoints in the clip.
  • Controls – The count of controls in the result.
  • Delays – The count of delays in the result.
  • Ifs – The count of If-Then-Else containers in the result.
  • Nops – The count of "no operation" (Nops) in the result.
  • Scripts – The count of scripts in the result.
  • Error Scripts – The count of error scripts in the result.
  • Switches – The count of Switch containers in the result.
  • Events – The count of Maestro events in the result.
  • Status – For example, Composition completed. Execution of App Action "App Action1" failed. (Band "Band 1" Track "Track 1" Clip "Fools Mate Clip" Target "SOASTA Demo iPad Stockfish")

Basic Information (for Messages)

This export contains information for each test result selected with each result representing a row.

  • Band Name – The band in which the 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.
  • Container Name – The name of the container in the test composition.
  • Container Index – The index of the container in the composition.
  • Clip Element Name – The name of the clip in the test composition.
  • Clip Element Index – The index of the clip in the test composition.
  • 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 (Offset) – The offset time for the clip element.
  • Start (Absolute) – The absolute time for the clip element.
  • 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.
  • TTFB – The average time to first byte.
  • TTLB – The average time to last byte.
  • DNS Lookup – The average time for DNS Lookup to complete.
  • Wait for Connection Pool Time – The total time for the connection pool.
  • 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 for the result.
  • Bytes Sent – The bytes sent for the result.
  • Bytes Received – The bytes received for the result.

Attachments

    Outcomes