It's all about the answers!

Ask a question

How to link Testsuites to TestPlans using the RQM Excel Importer


David Beange (111364101) | asked May 27 '15, 6:57 a.m.
edited May 27 '15, 8:02 a.m.
RQM v5.0.2

using the RQM Excel Importer to load tests into RQM is there a statement that can be added to the config file that will automatically associate the Testsuite just created with a specific TestPlan id?
eg to link a testcase that has just been created to an existing test plan which has it's id in a particular cell i can do -

"testcase.testplan=LinkExisting("urn:com.ibm.rqm:testplan:"&F2"

I would like to do the same for a testsuite is this possible?

Thanks

Accepted answer


permanent link
Don Yang (7.7k21114139) | answered May 28 '15, 1:20 a.m.
Yes, you can do the same for testsuite to be exported and then added to testplan's test suite section.
For example, test plan was created in GUI and its id is 5, then
you can use: testsuite.testplan=LinkExisting("urn:com.ibm.rqm:testplan:5")
in your cfg file to export testsuite into RQM and add it to the test plan:5
A quick test can be done against the sample TestSuite with TestCases 001.xls,
in TestSuite with TestCases 001.cfg, you can comment out test cases related and only use testsuite creation part and
add the above link to cfg file, it will be like:

// this configuration file will create a static testsuite and a testcase object for each one listed
// and link all testcase to the testsuite


testsuite.dc:title=C1
testsuite.dc:description=A4
testsuite.testplan=LinkExisting("urn:com.ibm.rqm:testplan:5")


//testcase.XLSStartRow=7
//testcase.XLSArtifactID=B
//testcase.dc:title=B
//testcase.dc:description=E
//testcase.jzalm:owner=C
//testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=F
//testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
//testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=L

you will need to change the testplan id to your real one for it. In my case, it is 5.
if your testplan is also exported from ExcelImporter, you should use external id when exporting testplan. In that case,
using a column in xls file to specify external id and then testsuite.testplan=LinkExisting(C)
(C is the column you have testplan external id specified)

Hopefully this helps.



David Beange 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.