It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,961

question asked: Sep 20 '11, 6:21 a.m.
question was seen: 4,238 times
last updated: Sep 20 '11, 6:21 a.m.

Related questions

Import Test Cases from Excel

0
Simon Norrington (31●1●10●9) | asked Sep 20 '11, 6:21 a.m.
Anyone know how I can import test cases from Excel and link them to an already existing Test Plan?

I added testplan.dc:title=O2 & testplan.XLSLink=testcase to my cfg file and all it did was create a new Test Plan and not link any Test Cases. :?

Any pointers on what I'm doing wrong would help. Looked at the samples and they haven't helped.

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Paul Slauenwhite (8.4k●1●2) | answered Sep 20 '11, 9:04 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Unfortunately, the test case resource does contain a reference to a containing test plan (see https://jazz.net/wiki/bin/view/Main/RqmApi#Detailed_Schema_Documentation). Otherwise, you could use the Link() keyword (see https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/51360). However, you could specify the test plan with the XLSArtifactID keyword (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Keywords_and_special_cases) set to the it's external ID in your configuration file.
0
permanent link
Simon Norrington (31●1●10●9) | answered Sep 22 '11, 7:10 a.m.
Thanks for the links. I have to say, I'm not much clearer on whether it's possible to import a test case to an existing test plan.

I tried using the XLSArtifactID keyword set to the external ID in the cfg file, but it's not working. I'm guessing I'm not understanding how external IDs work.
0
permanent link
Paul Slauenwhite (8.4k●1●2) | answered Sep 22 '11, 12:46 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
The idea is to update the existing test plan with the references to the test cases. For example:

testplan.XLSArtifactID=B1
testplan.dc:title="test plan title"
testplan.XLSLink=testcase

testcase.XLSStartRow=1
testcase.dc:title=A
...

Note, https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/56614. As a side effect, addition test plans (equaling the same number of test cases) are created.

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.