It's all about the answers!

Ask a question

[closed] Linking a Test Case in RQM with a requirement in RRC


1
1
VIJAY SUNDARESHWARAN (25247) | asked Dec 06 '12, 2:22 p.m.
closed May 25 '17, 12:20 p.m. by Ralph Schoon (63.3k33646)
 I am trying to create test cases in Rational Quality manager and link them to Requirements in Rational Requirements Composer. 
I was using the RQMExcelWordImporter utility 4.01 to generate the XML files from my excel spreadsheet and the method of directly exporting them to the repository.
I use the configuration file as mentioned below:

testcase.XLSStartRow=2
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")=G
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=H
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXPECTED-RESULTS-TITLE")=I
testcase.requirement=Link(A)
requirement.XLSStartRow=2
requirement.XLSArtifactID=A
requirement.dc:title=A
requirement.dc:description=B
requirement.jzalm:owner=D
requirement.dc:creator=D
requirement.XLSWorksheetID="Requirements"

The excel spreadsheet has 2 sheets. 1 named "TestCases" and another one named "Requirements". There are 3 test cases and 3 requirements. Each test case mapping to a requirement.
I use the utility to export these artifacts (Test cases to RQM and Requirements to RRC) to the repository and create links between them. 

When the utility completes its execution, 3 test cases get created in RQM and 3 requirements get created in RRC. But the test cases do not have any link to the requirement. In addition to the 3 test cases created, 3 more  test cases (using the same details as the ones in the requirements sheet) gets created in RQM and they have the link to the requirements in RRC.

Can anyone please point me to something that I am doing wrong here? Or, what else should i try to successfully create the artifacts and create the link between the Test Cases (in RQM) and Requirements (in RRC)? 

Thanks

Comments
VIJAY SUNDARESHWARAN commented Dec 06 '12, 3:03 p.m.

 Just to add to the scenario mentioned above... 


If i make a change to the config file by adding:

requirement.XLSWorksheetID="TestCases"
    
or requirement.XLSArtifactID, 6 artifacts get created. 3 Test cases in RQM and 3 Requirements in RRC. But this time, there are no links between the test cases and requirements.

Please let me know if you think I am doing something wrong here!!!

Thanks!!


1
Max Bridges commented Dec 06 '12, 3:54 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

Hi Vijay,

Have you looked over the information available on these wiki pages?
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
https://jazz.net/wiki/bin/view/Main/RQMWordAndExcelWhatSNewIn40

There are some updates described there that could be helpful.

The question has been closed for the following reason: "The question is answered, right answer was accepted" by rschoon May 25 '17, 12:20 p.m.

Accepted answer


permanent link
Hao Wan (1.5k35) | answered Dec 06 '12, 9:42 p.m.
JAZZ DEVELOPER
Hi Vijay,

From Excel Importer 4.0,
the your config file will create new requirement every time,
when link testcase to existing requirement, you need to check the "Linking to existing RM requirement" check box.
and do the linking through Excel Importer UI.
you can refer to the links provided by Max.
VIJAY SUNDARESHWARAN selected this answer as the correct answer

Comments
VIJAY SUNDARESHWARAN commented Dec 07 '12, 9:02 a.m.

@Hao Wan - Thank you for your reply. I did try the option of linking to an existing requirement through the UI. That worked successfully. I was able to upload  requirements first and then import and link test case to them. Links are correctly there under "validates" and "validated by" sections. But the scenario stated above came up when we had to import both the requirements and their associated test cases together and we had a large number of these artifacts. Assuming we create a single test case for each of the requirement, we are looking for an easier way to import all these requirements and test cases that we have in an Excel Sheet format to the Repository. So when I tried attempting this, I see the requirements set created again in RQM, in addition to them getting created in RRC. 

Is there any way (i assume i need to use attributes in the config file) to prevent these requirements from getting created in RQM again? 
As stated above, I can prevent these repetitions by specifying the XLSWorkSheetID 
attribute. But I don't see the link between the requirement and test case.


Hao Wan commented Dec 10 '12, 4:13 a.m.
JAZZ DEVELOPER

Vijay,
if you want to import new test case and new requirement and link them together,  you can refer to the sample, "TestPlan with TestCases 001 linked to requirement 001.xls"
the sample create 1 testplan ,  5 testcases and 5 requirements, each testcase is linked to one requirement.


VIJAY SUNDARESHWARAN commented Dec 10 '12, 10:13 a.m.

@Hao Wan.. yea that was the one I was using to import my test cases and requirements. I tried using the sample as such. And it worked just like it should creating 5 testcases and 5 requirements, each testcase is linked to one requirement. But when I tried to remove the test plan section from the sheet and attempted to match it as per my need (just having test cases in one sheet and requirements in another) ... and trying to edit the configuration file by commenting out the test plan section.. I end up with the same problem. Where the requirements get created in RQM as well as test cases. I know I am definitely doing something wrong in the configuration file. Trying to figure out what it is....  I will post how the config file looks after i modified it.



VIJAY SUNDARESHWARAN commented Dec 10 '12, 10:19 a.m.

 I removed the Test Plan section from the sample file and edited the config file. I commented out the Test Plan section in the config file and changed the XLSStartRow as 2 for the test case. I am attaching a screenshot of the excel sample file and the config file after this modification. I assume I am doing something wrong here, but trying to figure out what it is and why the requirements get created again in RQM as test cases. Excel Sheet after modification Config File after Modification





Hao Wan commented Dec 10 '12, 9:14 p.m.
JAZZ DEVELOPER

Hi Vijay,
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.
That means, you could not do a update for requirement currently.


VIJAY SUNDARESHWARAN commented Dec 12 '12, 5:17 p.m.

Hi Wan.. I was only trying to remove the test plan section from the config file and try and match it for my excel sheet. And that is where I am facing the problem of Test Cases not getting linked with requirements or requirements getting created as Test Cases. 

But  if I use the sample, "TestPlan with TestCases 001 linked to requirement 001.xls" , and its config file, there is no problem in uploading the artifacts. 
So is there any way to work around this problem?
And as @Der M requested below, can you please  elaborate on the answer above. Thanks!!


1
Hao Wan commented Dec 13 '12, 1:36 a.m.
JAZZ DEVELOPER

Hi Vijay,

would you try to add the following config file?
testcase.XLSWorksheetID="Acme Hammers"


VIJAY SUNDARESHWARAN commented Dec 13 '12, 1:48 p.m.

Thanks a lot Wan!!!... That did the trick!!! Now the config file looks like this and it works great... Thanks!!

testcase.XLSWorksheetID="Acme Hammers"
testcase.XLSStartRow=2
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
testcase.requirement=Link(A)

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" 

showing 5 of 8 show 3 more comments

6 other answers



permanent link
Der M (6121418) | answered Dec 11 '12, 7:37 a.m.

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

Could you explain this a little more?  Are we losing the Excel importer functionality?


permanent link
VIJAY SUNDARESHWARAN (25247) | answered Dec 13 '12, 3:00 p.m.
 @Hao Wan..  Thanks a lot for helping me resolve the earlier problem.. I am now able to upload test cases and requirements in 2 worksheets and am able to link them successfully... 
I also came across the LinkExisting() modifier.. so is there a way to import Test Cases and link them to existing requirement in RRC? I don't want to use the RQMWordExcelImporter Utility's Interface and do the linking, instead is there an alternative approach using the LinkExisting() modifier and import the test cases and link them to exiting requirements?


permanent link
Hao Wan (1.5k35) | answered Dec 13 '12, 9:58 p.m.
JAZZ DEVELOPER
Hi Vijay,
the LinkExisting() modifier is only for link to existing master test asset, if you want to link to existing requirement you can have a try with check the "Linking to existing RM requirement" check box. This Feature is added in Excel Importer 4.0.1



Comments
VIJAY SUNDARESHWARAN commented Dec 14 '12, 3:09 p.m.

@Hao Wan.. yeah I did try this and I was able to import Test cases and link them to requirements using this utility. I wanted to know if instead of manually selecting the Requirements, is there a way by which we can import the test cases and link them to the requirements by using only the config file? Just like how the test cases and requirements are uploaded together in the example mentioned above in this forum, I would like to know if there is a way (using the LinkExisting() or any other modifier) by which an existing requirement can be linked (without any manual intervention at all).


permanent link
Millard Ellingsworth (2.5k12431) | answered Apr 22 '14, 9:39 a.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER
edited Apr 22 '14, 9:40 a.m.

permanent link
AnuM C P (15814) | answered Jun 16 '14, 7:08 a.m.
 RFE is Rejected in the following note:
Could not link new testcases to existing requirement through OSLC using an specified external id due to limitation of RRC restAPI (64383)

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

Hello Vijay, 


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 


Comments
Ralph Schoon commented May 25 '17, 12:23 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

This was discussed 2012 - 6 years ago. The people on this thread might have flown off to and already reached the great Magellanic cloud since then.

If you have a question, you might want to consider to spend the effort to create your own question with the details relevant to your case.