It's all about the answers!

Ask a question

RQMExcel importer get an ID with testplan.XLSArtifactID


Francisco Burgos (5157) | asked Nov 16 '12, 4:56 a.m.
edited Nov 16 '12, 6:18 a.m.
I have a problem with XLSArtifactID because it seems not recognize it.
My goal is to create two Excel. First I have a Test Plan -> Test Cases, and in second file a Test Cases with Test Results.
So I guess I have to link this Test Cases in first with the second file uses their IDs.
For example:

File 1: TP - TCs (cfg)
testplan.XLSArtifactID=C1
testplan.dc:title=C2
testplan.XLSLink=testcase
testcase.XLSStartRow=8
testplan.XLSArtifactID=A
testcase.dc:title=B

File 2: TC - TRs
testcase.XLSArtifactID=B2
// static configured testcase definition with link to testcase
executionworkitem.XLSLink=testcase
executionworkitem.dc:title=C2
executionworkitem.dc:description=D2
executionresult.XLSStartRow=5
executionresult.XLSDelimeter=\n
executionresult.dc:title=B
//links all results to all of the configured testcases in the worksheet.
executionresult.XLSLink=executionworkitem

But when I export all this, RQM creates within the Test Plan, a section on left with name: XLSArtifactID. So it isn't recognize my ID written on Excel.

I read https://jazz.net/wiki/bin/view/Main/RqmApi#Types_of_IDs_in_RQM and I use some type IDs as: 488 (like IDs shows in the UI), TC1, etc... but  don't work.

How do I get this IDs for link the same TC within the two files?


Accepted answer


permanent link
Hao Wan (1.5k35) | answered Nov 18 '12, 8:47 p.m.
JAZZ DEVELOPER
Hi Francisco,
from the description
testcase.XLSArtifactID=B2

then for testcase, the value in column B2 is the external.

i.e. if the B2 value is "testcase1" then testcase1 is the external id

and you can use the Link() modifier to link the testcase with the external id "testcase1" in other excel files.


Francisco Burgos selected this answer as the correct answer

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.