It's all about the answers!

Ask a question

Need cfg file to import test cases and link existing Require


Sunanda Patil (611) | asked May 02 '11, 2:14 a.m.
I have all the requirements in RQM. Now I want to import the test cases from excel file and link to the existing requirement while importing.

If anyone knows the configuration parameters required for this, please post.

I also tried following configuration(Sheet1 contains the requirements).
Test cases and requirements are imported in RQM but not linked.

testcase.XLSStartRow=7
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

requirement.XLSStartRow=2
requirement.XLSArtifactID=A
requirement.dc:title=B
requirement.dc:description=C
requirement.jzalm:owner=D
requirement.dc:creator=D
requirement.XLSWorksheetID="Sheet1"

testcase.requirement=requirement.XLSArtifactID

Comments
VIJAY SUNDARESHWARAN commented Dec 07 '12, 1:38 p.m.

By any chance did you find the solution to this? I am facing the exact same scenario and would be interested in the solution.


This is the question I have posted in the forum:

Thanks.  

3 answers



permanent link
Hao Wan (1.5k35) | answered Dec 11 '12, 2:04 a.m.
JAZZ DEVELOPER


the correct config for Excel Importer 4.x and 3.x is
testcase.requirement=Link(A)
not
testcase.requirement=requirement.XLSArtifactID
if you want to link testcase and requirement.

Which version of Excel Importer are you using?
from Excel Importer 4.0 the Reportable REST API for requirement is Formally deprecated in RQM 4.0 and will no longer be supported in the next major release any more, and requirement are created through OSLC in 4.0, and will create new requirement every time when exporting.


permanent link
himanshu agrawal (113) | answered May 24 '17, 5:20 p.m.

Hello Sunanda,


If above solution has worked for you, could u please let me know what is A in below command 

testcase.requirement=Link(A)

If you have tried anything else please share
Thanks in Advance 
 


permanent link
Don Yang (7.7k21114139) | answered May 24 '17, 7:28 p.m.

Hi, Himanshu

The samples TestPlan Requirement Collection Test Case and Requirements.xls/TestPlan Requirement Collection Test Case and Requirements.cfg when you installed ExcelImporter will have the details, please have a look there.
Thanks

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.