RQMExcel importer get an ID with testplan.XLSArtifactID

Question

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

0

permanent link

Hao Wan (1.5k●3●5) | 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

It's all about the answers!

Related questions

RQMExcel importer get an ID with testplan.XLSArtifactID

Accepted answer

Your answer