A way to export test cases from RQM to Excel with complete content
We need a way to export test cases from RQM to Excel with all the content including test scripts.
I have tried RQM URL Utility with the below command,
java -jar RQMUrlUtility.jar -command GET -user USERNAME -password PASSWORD -filepath "c:\Script2.xml" -url "https://HOSTADDRESS/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/PROJECT%20(Testing)/testcase/urn:com.ibm.rqm:testcase:393"
It returns the success msg as below, It says the XML retrieved successfully, but it doesn't generate anything in the file i-e C:\Script2.xml
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<----- [ RQMUrlUtility ] ---->>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Default cookie policy RFC_2109 is used.
RQMUrlUtility: Connected to https://HOSTADDRESS using project "PROJECT+(Testing)"
Attempting to create SSL_TLS context
java.security.NoSuchAlgorithmException: SSL_TLS SSLContext not available
Unable to create SSL_TLS context, trying SSLv3
RQMUrlUtility: Calling [ HTTP GET ] method to retrieve XML from a specified URL
RQMUrlUtility: Server Response code: 200
RQMUrlUtility: [ SUCCESS ] XML string retrieved from URL : "https://HOSTADDRESS/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/PROJECT+(Testing)/testcase/urn:com.ibm.rqm:testcase:1838 " is written to file located at -: " c:\Script2.xml "
Disconnecting from the IBM Rational Quality Manager server.
Can someone assist if there is something missing or this solution will work or not?
Thanks in advance.
Accepted answer
Comments
Hi Michael,
Well, the first thing I would say is that the XML isn't really optimized for viewing in Excel. I think perhaps the URLUtility is not the best tool for what you are trying to do. Have you looked at the CSV Export feature?
To answer your question though, yes there is a way to export more than one item at a time by using the feed URL and the fields selection feature. For example:
https://${host}/${root}/service/com.ibm.rqm.integration.service.IIntegrationService/resources/${projectAreaAlias}/testcase?fields=feed/entry/content/testcase/*
You can further tune the fields parameter to select only the properties of the test case that you are interested in. You'll want to study the REST API wiki (https://jazz.net/wiki/bin/view/Main/RqmApi) to learn how to use these capabilities to get exactly what you want.