we are trying out zephry for jira and with 1.6 we were able to export to excel with test steps. now with 1.7 the test steps are not exported to excel. I noticed that they are still exported to xml but not excel.
we are using jira 5.2.7 and zephry 1.7.1021
You could try a sql query instead, as a temporary workaround until this issue is fixed. Here's what I use in lieu of the export regardless, as the export doesn't provide everything I need at this point. Obviously, some of the custom fields in my query won't apply to what you do and you will need to use the table prefixes for your installation of JIRA. You can then export the results to a CSV or XLS or whatever format your SQL tool (I use Squirrel) allows.
SELECT (SELECT stringvalue FROM customfieldvalue v WHERE v.issue = i.ID AND v.customfield = 10001) as "External ID", (pkey || '.' || t."ORDER_ID"::text) AS "Test ID", summary as "Summary", t."STEP" as "Test Step", t."RESULT" as "Expected Result", (CASE WHEN (r."STATUS" is null) THEN 'Untested' WHEN (r."STATUS" = '-1') THEN 'Untested' WHEN (r."STATUS" = '1') THEN 'Pass' WHEN (r."STATUS" = '2') THEN 'Fail' WHEN (r."STATUS" = '3') THEN 'WIP' WHEN (r."STATUS" = '4') THEN 'Blocked' END) as "Status" FROM jiraissue i, "[your prefix here]_TESTSTEP" t LEFT OUTER JOIN "[your prefix here]_STEP_RESULT" r ON t."ID" = r."STEP_ID" WHERE i.id = t."ISSUE_ID" AND t."ISSUE_ID" IN (SELECT "[your prefix here]_SCHEDULE"."ISSUE_ID" FROM "[your prefix here]_SCHEDULE", "[your prefix here]_CYCLE" WHERE "[your prefix here]_CYCLE"."ID" = "[your prefix here]_SCHEDULE"."CYCLE_ID" AND "[your prefix here]_CYCLE"."ID" = 6) AND t."ISSUE_ID" IN (SELECT issue FROM customfieldvalue where stringvalue IN('10080','10123')) ORDER BY "External ID", i.pkey, t."ORDER_ID";
Zephyr for JIRA 220.127.116.113 has officially been released. The ability to export test steps was fixed. You can get the new version with the bug fix here:
we have upgraded to Zephyr v18.104.22.1683 and our JIRA instance is v5.2.11 and export test steps works properly. By information from Emily it should works also with your version. Maybe try to check fields configuration and set up in administration.
For exporting the steps is necessary to chose option "Excel (All fields)".
Hope this helps,
Can you please supply the exact steps you are taking? I am trying to recreate what you explained and am unable too. However, you may be doing something a little different and if in fact there is an issue this is the most guarenteed way for me to re create it.
Emily <-- works at Zephyr :)
Currently there is not a solution to be able to export out test steps. However, our dev team is currently working on having the bug solved soon. We do not have a time frame on when the bug will be fixed however please stay tuned. They are working diligently on this now.
Yes the next release of Zephyr for JIRA will be compatible with JIRA versions 5 and 6. I advise you wait the few days for the next release to come out. You can roll back to Zephyr for JIRA 1.6 if you wish however we do not support rolling back. There is always a possibilty of data getting lost with this decision. However, if you wish to do it this way you can get any of our Zephyr for JIRA versions off of the Atlassian marketplace. You would need to uninstall your current version and re install the version you got off the marketplace. Also, make sure you make a backup of your data in the event something goes wrong.
Select a given project from Projects menu. Select Test Cycles from left hand menu. Select Export Tests from gear menu on right hand side of one of theTest Cycles.
"Cycle-[MyCycleName].csv CSV file is downloaded.
As I've just started with Zephyr this might be an error with how I've set things up (using defaults) as another poster suggested.
Your current export is working as expected. We unfortunatlly do not yet have a way to export test step results, the area where you are looking.
You can export test steps when just looking at the testcases. To do so, produce a list of testcases. You can do so in the Issue Navigator by filtering on the issue type of Test or you can do so by clicking on the Test menu item and then selecting the "Search Tests" choice.
Here, you can go to Export and choose either Excel (All Fields) or Excel (Current Fields). If you choose current, you'll need to have already displayed the "Zephyr Teststep" column on your detailed list.
You do not need to downgrade anything. You are running JIRA 6.0 which we are compatible with and you are also running the latest Zephyr for JIRA which is great. Currently we are not compatible with JIRA 6.1. However, we will be releasing Zephyr for JIRA 2.1 in about 4-6 weeks which will be compatible with JIRA 6.1. It is currently our highest priority and are hoping to have it out sooner.
What you are going to want to do is export from the 'Search Test Executions' location. In here you can search for test cases using a ZQL query and then export them out with their executions statuses and the test steps to many different formats. The formats we currently support to export too are XML, RSS, CSV, HTML and Excel.
Please read the documentation posted below. It will show you where to do this but also there is a link in the documentation that will take you to all the different ZQL queries you can do.
Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG