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

Import new Test Suite or Test Plan linked to existing Test Cases to RQM using the RQM Excel importer

Questions
Tags
Users
Badges
Stefano Bonaiuti
(11) Mar 28 '18, 3:49 p.m.

 it is possible ? thanks ! 

0 votes

Comments
Stefano Bonaiuti
Mar 29 '18, 3:39 a.m.

 This is my CFG file , and imports a Test Suite linked with only one existing Test Case , when i change the ID of the test case to link more test cases to the new test suite , it doesn´t work.


testsuite.XLSWorksheetID="Excel12" 
testsuite.XLSStartRow=2
testsuite.dc:title=A2
testsuite.dc:description=B2
testsuite.alm:owner=C2
testsuite.priority=D2
testsuite.weight=E2
testsuite.Section("com.ibm.rqm.execution.editor.section.design","RQM-KEY-EXE-DESIGN-TITLE")=F2
testsuite.Section("com.ibm.rqm.planning.editor.section.testSuitePreCondition","RQM-KEY-TSUITE-PRE-COND-TITLE")=G2
testsuite.Section("com.ibm.rqm.planning.editor.section.testSuitePostCondition","RQM-KEY-TSUITE-POST-COND-TITLE")=H2
testsuite.Section("com.ibm.rqm.planning.editor.section.testSuiteExpectedResults","RQM-KEY-TSUITE-EXP-RESULTS-TITLE")=I2
testsuite.attachment=J2
testsuite.XLSArtifactID=K2                  

testsuite.testcase=Link("urn:com.ibm.rqm:testcase:"&L2)   

Donald Nong
Mar 29 '18, 3:41 a.m.

This forum uses a Q&A format, so don't put your follow-up comment as an answer. Otherwise, most people will just skip your post because it's "answered". Also "it doesn't work" does not provide any meaningful details. Please try to provide more concrete information next time.

1 answer
2,094 views
0 votes

One answer

Permanent link
Donald Nong
(14.5k●6●14) Mar 29 '18, 3:46 a.m.

If you check the document, you should notice that you need to use the LinkExisting() modifier to link any existing artifacts.
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Modifiers_of_data_Used_to_the_ri

So your last line should be: testsuite.testcase=LinkExisting("urn:com.ibm.rqm:testcase:"&L2)

0 votes

Comments
Stefano Bonaiuti
Apr 03 '18, 8:34 a.m.

Thanks Donald , i tried the solution that you say using the LinkExisting , but in the wiki document says that link existing only works on master/child artifacts , and also when i used it only imports one existing Test Case to the new Test Plan or Test Suite. 

For more specific info , it´s like an update , the cases don´t accumulate.
And in the log of the RQM Server says :

- unable to resolve Test Case 55 , you need to create test suite steps first 

Donald Nong
Apr 05 '18, 12:46 a.m.

I believe it's always "update", not "add". The error that you showed appears irrelevant, as it says "Test Case 55" does not exist. If you construct a resource URI with "urn:com.ibm.rqm:testcase:55" at the end, can you link to the actual test artifact?

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

Question asked: Mar 28 '18, 3:49 p.m.

Question was seen: 2,094 times

Last updated: Apr 05 '18, 12:46 a.m.

Confirmation Cancel Confirm