Exporting Test Cases to Excel
![]()
Hi,
I am looking to export test case information, with test script steps into an excel document.
I cannot see this functionality in the user interface. I know there is the ability to upload test cases with test script steps from excel using the RQM importer plug in for excel. Does anyone know if the reverse plug in exists to convert from the RQM database into excel format?
Thanks,
Phil
|
2 answers
![]()
Phillip,
There is an option in the 'Browse Test Case' view that you can download to a CSV file; this will give a list of test cases. If you want the actual data (The XML) you'll need to use the REST API https://jazz.net/wiki/bin/view/Main/RqmApi
![]() Comments Thanks Ara,
What i am trying to do is export multiple test cases with test script step information, into one excel document.
I'm guessing I will need the REST API for this, because the .csv export only gives a one line summary of each test case?
|
![]()
Phillip,
Yes, you will need to use the REST API to capture the details of a Test Case
An example of the syntax would look like this;
https://clm401:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/LPA+project+1+%28Quality+Management%29/testcase/urn:com.ibm.rqm:testcase:32
where the ...
Public URI is clm401:9443
QM Project are is LPA+project+1+%28Quality+Management%29
Test Case ID is 32
You can use any type of HTTP client to run the request (i.e. Poster, cURL..etc)
You can also write a quick program the would output a range of ID's to automate the process
Thanks
Ara
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.