RQMExcelImporter: updating Spreadsheet with TestCase, TestScript, Test Result Numbers
![]() Hello, I have figured out how to use this tool to export Test Cases and Test Scripts into RQM and with a bit of effort can export just the results into RQM but I need to go into RQM to get the test case, test script numbers. Ideally, what I want to do is grab the output of the tool so that I can annotate the sheets with the number of the Test Case, Script and Execution Results Record that were created from it, so that any new results on subsequent runs are updated but the test script detail and expected results are not (they might be locked down) and the new result is linked to the script, case and test execution record. You'd think there would be an easy way to do this, what trick am I missing. Cheers for any help. Richard |
2 answers
![]() Richard,
When we use 'XLSArtifactID' with the test artifact, it will update the artifact if already exist otherwise it will create the new. So you need to specify artifact ID for the test artifact which you want to update if exist. Please refer 'Execution Results' from sample file in which testcase has been specified using XLSArtifactID and execution result is explicitly linked with testcase.
Regards,
Mehul
|
![]() Hi Mehul, Thanks for the reply. I need to add a script so cannot add this entry as a comment - not enough characters. I have a potentially large collection of Test cases to add and there is potential for some of them to have the same names. I therefore thought it safer to use the Link using the URN syntax with the number of the test case, script, execution results artifacts I am linking to, this avoids potential ambiguities/ errors with updating the wrong records. The first run or edit runs will update the actual Test Case and Test Script details, on these runs I wish to populate my spreadsheet with the numbers of the Test Script/ Test Case/ Execution Results records that were created/ updated. This seems like a common use case - how can I achieve this? One of my scripts follows, the idea would be to replace the lines
executionresult.testcase=Link("urn:com.ibm.rqm:testcase:20")
with
executionresult.testcase=Link("urn:com.ibm.rqm:testcase:" & D1)
where row D contains the numbers of the artifacts created on a Test Case Detail update run A complete example script to update just the results follows: -
//Here we are just adding execution results and linking to existing items
executionresult.testcase=Link("urn:com.ibm.rqm:testcase:20")
|
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.