Export XRay Manual Tests with Steps

[Thilan Karunananda]

Hi,

I'd like to know how to export Manual Tests with steps created in XRay in Jira to csv or xlsx formats. Ayone who knows about this, Pls let me know

Thanks

Thilan

[Aron Gombas _Midori_]

Use the Better Excel Exporter - Xray integration to export to Excel, then you can save the resulted file to CSV:

[Chris Boxall]

Does this work with Jira Cloud?

[Aron Gombas _Midori_]

Better Excel Exporter does not support Jira Cloud at the moment, unfortunately. It is available for Jira Server and Data Center deployments.

To ask for the cloud port, vote here:

https://midori.zendesk.com/hc/en-us/articles/229992968-Better-Excel-Exporter-for-Jira-Cloud

[Levente Szabo _Midori_]

If you are looking for ways to export Xray test details to Excel, here is a new article that would be useful for you on how to export test cases with steps from Jira to Excel

[Mirek]

Already answered on - https://community.atlassian.com/t5/New-to-JSD-discussions/Export-Tests-with-steps/td-p/1094881

[adam.cane]

Hi, 

Top right of the screen when in the test issue view you can export to XML, word or download as feature file (cucumber) if that's the format of your tests. I am not sure how to export to csv if there is a way however I would recommend in the future writing your tests into csv first and then importing them into JIRA that way, so you have both formats available.

EDIT: this is only the JIRA functionality from the test issue view - follow the documentation link below to export to CSV from search issue view which may help you more or look into the Xporter app.

[Kosala De Silva]

@adam.cane  / @Mirek  

  I also have the same issue where I cannot export the "Test Steps" and "Preconditions" with the excel export for a set of Tests.

The use case is that for a particular "Test Set" we want to export all the tests, and each "Test" assigned Test Steps" and Preconditions. 

Also when we export the "Custom field (Manual Test Steps (Export))" this is what we see in the csv or xml which is not correct. the whole purpose of export functionality is gone as we don't want to see HTML code in the excel as "Test Steps". 

ex.

<table border='1' bordercolor='#79a1c9' style='background-color:#79a1c9' width='100%' cellpadding='3' cellspacing='3'><tr><td></td><td>Step</td><td>Inputs/Data</td><td>Expected Results</td></tr><tr><td>1</td><td><p>Set the scheduler timer</p></td><td><p> n = 3mins</p></td><td></td></tr><tr><td>2</td><td><p>Activate the Scheduler</p></td><td></td><td></td></tr><tr><td>3</td><td><p>Check Staging table in (n + 1) mins if the Staging table record has been updated <br/>(Use the node ID to query the table)</p></td><td><p>4 mins</p></td><td><p>Staging table (Staging_sm9_query_problem) records should be updated with the polling_status as "SUCCESS" or "FAILED" for the selected Node ID</p></td></tr></table>

So how do we export to excel with the aboce scenario?

[adam.cane]

What's the reason you cannot use the 'export test steps to csv' button above the manual steps? Sorry if I've misunderstood your issue.

[Abe_Roba]

Hi Adam, the export to CSV button on the issue itself is only good for that one single issue.  We want to be able to bulk export every test and the steps.