It's all about the answers!

Ask a question

RQMExcelImporter:export test execution result to the existing TCER created via GUI


Don Yang (7.7k21111139) | asked Apr 22 '15, 2:24 a.m.
RQM and ExcelImporter 5.0.2

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


permanent link
Reshma Ratnani (1.1k1) | answered Apr 22 '15, 7:24 a.m.
JAZZ DEVELOPER
Hi Don,

Try using Link attribute, something like below in your cfg file

executionresult.executionworkitem=Link(M)

Thanks
Don Yang selected this answer as the correct answer

Comments
Reshma Ratnani commented Apr 22 '15, 7:25 a.m.
JAZZ DEVELOPER

Similarly for TestCase also use Link attribute

executionresult.testcase=Link(N)


Don Yang commented Apr 23 '15, 2:11 a.m.

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?


Reshma Ratnani commented Apr 23 '15, 2:16 a.m.
JAZZ DEVELOPER

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


Donald Nong commented Apr 23 '15, 5:33 a.m.

 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.


Reshma Ratnani commented Apr 23 '15, 5:46 a.m.
JAZZ DEVELOPER

Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Modifiers_of_data_Used_to_the_ri

LinkExisting()
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.
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)


Reshma Ratnani commented Apr 23 '15, 5:46 a.m.
JAZZ DEVELOPER

Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Modifiers_of_data_Used_to_the_ri

LinkExisting()
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.
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)


Don Yang commented Apr 23 '15, 8:44 p.m.

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.

showing 5 of 7 show 2 more comments

Your answer


Register or to post 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.