Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

link test plan to test suite using RQM import

Questions
Tags
Users
Badges
Amit Garg
(31●20●51) Dec 13 '17, 9:40 a.m.

We are using RQM 6.0.3 and RQM import utility (6.0.3). I want to know if we can link a test plan to a test suite using the excel import. Test plan and test suite both doesn't exist in RQM. 


Currently it allows linking between  test case --> test plan and testsuite -- testcase

I could not find any reference to testplan.XLSLink=testsuite  or currently it is not possible?

0 votes

3 answers
6,652 views
0 votes

3 answers

Permanent link
Don Yang
(7.7k●21●114●139) Dec 13 '17, 11:31 p.m.

Hi, Amit

 testplan.XLSLink=testsuite should work.For example from the sample cfg file:
'TestSuite with TestCases 001.cfg'
I tried something quick like
testsuite.dc:title=C1
testsuite.dc:description=A4


 testplan.dc:title=C1
 testplan.dc:description=A4
 testplan.XLSLink=testsuite

as a new cfg file and use the same 'TestSuite with TestCases 001.xls' to export, I would see the new test plan has test suite added to testsuite section,

0 votes

Comments
Amit Garg
Dec 14 '17, 2:14 a.m.
Hi Don, We have tried using testplan.XLSLink=testsuite multiple times and it never worked. Although it did work for sample you quoted above. Following is my config file information. Please suggest if missing something here: ============================ testscript.XLSStartRow=11 testscript.steps.type="execution" testscript.dc:title=B testscript.dc:description=D testscript.steps.title=E testscript.steps.description=F testscript.steps.expectedResult=G testscript.steps.comment=L testscript.XLSDelimeter="\n" testcase.XLSStartRow=11 testcase.dc:title=testscript.dc:title testcase.dc:description=C testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=D testsuite.dc:title=A11 testsuite.XLSLink=testcase testplan.dc:title=B1 testplan.XLSLink=testsuite ===========================================

Don Yang
Dec 14 '17, 6:42 p.m.
I tried the sample Testsuite with testcases that have testscripts.cfg/Testsuite with testcases that have testscripts.xls, in which it has testscript, testcase, test suite creation and linkage configuration file. I simply add the below to the end of cfg file for testplan creation and link to testsuite(I believe the scenario is the same as yours): //the below is existing testsuite bit in cfg file testsuite.dc:title=B1 testsuite.dc:description=B2 testsuite.XLSLink=testcase //adding the below to create testplan and link test suite to it testplan.dc:title=B1 testplan.dc:description=B2 testplan.XLSLink=testsuite This works for me with no problem. I tested it with RQMExcelImporter 6.0.4 and RQM6.0.4. You may want to try with RQMExcelImporter 604 and see if it helps if the above sample does not work for you.

Permanent link
Neeta Valera
(45●6●43) Aug 16 '18, 2:22 p.m.

 The construct above suggested by Don does not work for me with the sample file:

8/16/2018 2:20:40 PM: 
--------------------------------------------------------------------------------
8/16/2018 2:20:40 PM: 
SESSION: 8/16/2018 2:20:40 PM

8/16/2018 2:20:40 PM: Getting artifacts from current document TestSuite with TestCases 001.xls
8/16/2018 2:20:42 PM: Created 7 artifacts, sending to server
8/16/2018 2:20:42 PM: sending testcase0 named Dead_Hammer
8/16/2018 2:20:43 PM: Server returned code OK
8/16/2018 2:20:43 PM: sending testcase1 named Socially_Acceptable_Hammer
8/16/2018 2:20:43 PM: Server returned code OK
8/16/2018 2:20:43 PM: sending testcase2 named Pretty_Hammer
8/16/2018 2:20:43 PM: Server returned code OK
8/16/2018 2:20:43 PM: sending testcase3 named Hot_Hammer
8/16/2018 2:20:44 PM: Server returned code OK
8/16/2018 2:20:44 PM: sending testcase4 named Strong_Hammer
8/16/2018 2:20:44 PM: Server returned code OK
8/16/2018 2:20:44 PM: sending testsuite5 named TestSuite_with_TestCases_001_Acme_Hammers_1.xml
8/16/2018 2:20:44 PM: Server returned code InternalServerError
8/16/2018 2:20:44 PM: Error sending to server TestSuite_with_TestCases_001_Acme_Hammers_1.xml of type testsuite
8/16/2018 2:20:44 PM: Internal Server Error
8/16/2018 2:20:44 PM: sending testplan6 named TestSuite_with_TestCases_001_Acme_Hammers_1.xml
8/16/2018 2:20:44 PM: Server returned code OK
8/16/2018 2:20:44 PM: finished writing artifacts 

0 votes

Comments
Don Yang
Aug 16 '18, 9:13 p.m.
not sure what version of RQM and RQMExcelImporter you are using. I have got no problem with v6.0.4.

Neeta Valera
Aug 29 '18, 8:18 a.m.
Don, I am using RQM 6.0.6 and RQM Excel Importer Version is 6.0.6.16274. Please look into it. Thanks. 

Permanent link
Neeta Valera
(45●6●43) Aug 17 '18, 8:07 a.m.

 Don, I am using RQM 6.0.6 and RQM Excel Importer Version is 6.0.6.16274. Thanks

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,143

Question asked: Dec 13 '17, 9:40 a.m.

Question was seen: 6,652 times

Last updated: Aug 29 '18, 8:18 a.m.

Confirmation Cancel Confirm