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

Need cfg file to import test cases and link existing Require

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

0 votes

Comments

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


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.

0 votes


Permanent link

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 
 

0 votes


Permanent link

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

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.

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: May 02 '11, 2:14 a.m.

Question was seen: 8,426 times

Last updated: May 24 '17, 7:28 p.m.

Confirmation Cancel Confirm