Exporting test-artifact list views as CSV files

You can export the details of a test-artifact list view to a comma-separated values (CSV) file.

About this task

These test-artifact list views include the option to export the view to a CSV file:
  • Test Plans
  • Test Cases
  • Test Suites
  • Test Scripts
  • Test Case Execution Records
  • Test Suite Execution Records
  • Test Case Results
  • Test Suite Results
  • Build Records
  • Execution Schedules
  • Keywords
The CSV file will contain data from all columns and rows in the list view. Selecting specific rows or hiding columns does not affect the exported data. The exported file will also contain data from all pages of the list view. If you have linked files on the Engineering Workflow Management repository to any test artifact, the linked file information will also be displayed in the exported CSV file.
Note: Any cell starting with the ‘=’ ‘@’, ‘+’ and ‘-’ characters are interpreted by the spreadsheet software as formula. This poses a risk of malicious formula injection. To avoid this vulnerability, an open quote is added to these characters. This ensures that there is no possibility of an formula injection attack.

Procedure

  1. Open the Browse page for the test artifact to export. For example, to open the Browse page for test plans, click Planning > Browse Test Plans.
  2. Optionally, sort and filter the data in the list view. Changes that you make to the order and filtered results of the data will be reflected in the exported CSV file.
  3. Click the Download as spreadsheet (.csv) icon (Download as spreadsheet (.csv)). The Manage Print Job Queue page opens, displaying the export status of the CSV file. By default, the page is updated every 4 seconds.
    Tip: The CSV file name in the Manage Print Job Queue depends on the view from which you export it. Test suites, for example, would be named Test Suite.csv.
  4. When the job is marked complete, click the job name to save it to your computer.

What to do next

You can use a spreadsheet editor or a text editor to view the contents of the new CSV file.

video icon Video

Jazz.net channel
Software Education channel

learn icon Courses

IoT Academy
Skills Gateway

ask icon Community

Jazz.net
Jazz.net forums
Jazz.net library

support icon Support

IBM Support Community
Deployment wiki