RQMExcelImporter:export test execution result to the existing TCER created via GUI
I have existing TCERs created via GUI in RQM and want to use RQMExcelImporter to import the test result to that TCER. From https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#XLSLinkKeyword, I notice that LinkExisting() seems to be the keyword I can use to do that.
Suppose TestCase id is 46 and TCER for this test case has id: 58
I add internal id for TCER in Excel Column M: urn:com.ibm.rqm:executionworkitem:58
internal id for test case in Excel column N: urn:com.ibm.rqm:testcase:46
in cfg file, I tried:
executionresult.executionworkitem=LinkExisting(M)
executionresult.testcase=LinkExisting(N)
After exporting to RQM. I notice that TCER timestamp shows last modified at the time I exported but I cannot find any result in TCER itself.
Am I doing anything wrong for such a use case (TCER created in GUI and result will be from ExcelImporter) or this is not achievable in ExcelImporter?
Thank you very much.
Accepted answer
Try using Link attribute, something like below in your cfg file
executionresult.executionworkitem=Link(M)
Thanks
Comments
Similarly for TestCase also use Link attribute
executionresult.testcase=Link(N)
Thank you very much Reshma for the suggestions. I tried and it does work for the TCER created by GUI. For those TCERs exported from ExcelImporter, it seems that using internal id does not work(I did a quick test but did not get error and result not imported). I am trying that because I want to see if I use internal id, whether I don't need to care about which TCER is from GUI and which are from importer when I export the result to them.
Is internal id applicable to TCER from Importer or the external id should be set in the column instead when using Link() modifier?
Hi Don,
The TCERs which are exported dont have Ids similar to the ones created in GUI. So you will have to use external IDs for those exported TCERs
You can check the IDs to be used in the feed url for TCERs. Feed url would be similar to below url
https://<host>:<port>/<context_root>/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<proj_area_name>/executionworkitem
Hi Reshma, under what circumstances should we use LinkExisting()? With a working configuration, I only change Link() to LinkExisting() and I will get errors while importing.
Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Modifiers_of_data_Used_to_the_ri
modifier - indicates a reference to the master test artifacts, content is the external/internal id or the excel cell/column that stores the external/internal id of the master artifact on RQM server.
LinkExisting()
i.e.
testplan links with testcase, then test plan is master artifact and testcase is sub/child artifact.
test case link with test script, then test case is master test artifact, and test script is child artifact.
test suite link with test case, then test suite is master test artifact, and test case is child artifact.
the
LinkExisting
modifier only deals with the support for linking master artifact and the artifact must exist on the RQM server side first.
the syntax will be
testcase.testplan=LinkExisting("testplanid"), testplanid1 is the external/internal id of the test plan on RQM server.
testscript.testcase=LinkExisting(E1)
testcase.testsuite=LinkExisting(F)
Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Modifiers_of_data_Used_to_the_ri
modifier - indicates a reference to the master test artifacts, content is the external/internal id or the excel cell/column that stores the external/internal id of the master artifact on RQM server.
LinkExisting()
i.e.
testplan links with testcase, then test plan is master artifact and testcase is sub/child artifact.
test case link with test script, then test case is master test artifact, and test script is child artifact.
test suite link with test case, then test suite is master test artifact, and test case is child artifact.
the
LinkExisting
modifier only deals with the support for linking master artifact and the artifact must exist on the RQM server side first.
the syntax will be
testcase.testplan=LinkExisting("testplanid"), testplanid1 is the external/internal id of the test plan on RQM server.
testscript.testcase=LinkExisting(E1)
testcase.testsuite=LinkExisting(F)
Thanks Reshma for the info. Yes the feed does return the different id for TCERs created by GUI or exporter.
I saw the info on LinkExisting() before posting the question here. I was thinking TestResult is a child of TCER and TestCase but it seems that it is not the case in ExcelImporter.