Use RQM Excel Importer to import associated Test Case, Test
Hi All,
I am writing a .cfg file to import Requirement, Test Case and Test Script from Excel to RQM. I am aware of the article on jazz.net (https://jazz1.torolab.ibm.com/wiki/bin/view/Main/RQMExcelWordImporter). I created a sample Excel file and a cfg file according to the instructions in the article and provided examples. But I still couldn't make the association between "test case and requirements", "test case and test scripts" to be imported into RQM. In my sample Excel file, there are: Requirement 1 --- Test case 1 --- Test Script 1; Requirement 2 --- Test case 2 --- Test Script 2; Requirement 3 --- Test case 3 --- Test Script 3; What the I want is to link Requirement, Test Case and Test Script to each other. For example, "Requirement 1" <<link>> "Test case 1" <<link>> "Test Script 1". I have been able to import requirements, test cases and test scripts into RQM successfully. Now the problem is how to link **single** requirement, test case and test script to each other respectively. I tried the methods in provided sample cfg files but could make what they want. Please see below what I have tried. // Link test case to test script // Below lines will link test case and test script to each other BUT also create duplicate test cases in test script's name <<< testcase.dc:title=testscript.dc:title testcase.dc:description=testscript.dc:description //Link test case to requirement //This line will link test case to ALL requirements in the xls file <<< testcase.XLSLink=requirement I also found that above two sections cannot be used together, otherwise the link between requirements and test case will be missing. Any input will be appreciated. |
16 answers
Hi All, Hi, Multiple artifact linking isn't supported yet in the tool. The ability is covered in WI 25869. |
Hi,
I have succefully imported artifacts linked to other artifacts using the XLSLink notation in the cfg file. But this works only if I could import everything at the same time. What if I need to import test case and link it to an already EXISTING requirement? Do you now if this can be done? Thanks! Matteo |
Hi All, Hi, We are trying to upload test cases and test scripts together. We have used the following mapping command. testcase.XLSLink=testscript When we are uploading all the test scripts are getting mapped to all the test cases. Can anyone suggest a method to map a particular test script to a particular Test case |
Hi,
you have to split your records into several excel sheets: put 1 parent and N childs (1 TC & N TS script) for each sheet. Also do not declare the sheet name in the conf file, the import will process all the sheets. Regards, Matteo |
When is this ability to be released, Mike? It would be extremely useful to be able to link plans to cases to scripts. My understanding is that this WI 25869 is the solution. Is this correct? Thank you and regards, Andrew |
|
Hi alll
I am currently doing some research for the project team in regards to importing and exporting our Requirements, Test Cases, Test Scripts etc into RQM. After reading all the relevant documentation i understand i will need to create a .cfg file which in most cases will be tailored to specific project needs however i am wondering is there is a basic generic .cfg file i can obtain to begin to understand what is needed to produce one for myself. I am tasked to look in to the best practice of getting all our test data into RQM on behalf of the team so i am hoping someone can give me some basic lessons learnt advice or even point me in the direction of a basic commonly used cfg file to have a look at. Once the config file is created is there anything else i would need to consider which i have already come across (just so that i am one step ahead of the game) Your help would be greatly appreciated Thanks in advance Vishal-UK Comments hi Vishal, you can use the samples in the importer installation folder Mso2Rqm_Excel\samples and refer to the link https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter |
A couple of points:
-See the examples (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration), specifically Scripts that create testcases.cfg. -Look at self referential links (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Data_locations_and_self_referent). |
A couple of points: Hi Paul, thks for your input... can i ask for your advise on the Test Case Updater thingy? I understand that It is tested with RQM 2.0.0.1 and applicable iFix releases only. But now we have RQM 3.0 and I have tried but the updater ain't running on RQM 3.0. Do you have any updates on this? Thank you |
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.
Comments
one way is to use Link key word to link testcase with requirement testcase.requirement=Link(A). and using self reference testcase.dc:title=testscript.dc:title to link testcase withtestscript