About Excel Importer Utility
![](http://jazz.net/_images/myphoto/938d8447b3f86d46667076fb6ad4bd1f.jpg)
Hi all:
I tried to use RQM Excel Importer Utility to import some testcase, but in my situation, I have test suites,test cases,test script, test suite and test cases have a multiple relationship(1:N) and test cases and test script have a 1:1 relationship, I want all of them in a excel file, also it can be imported with all their links the excel file should be like this:
Test Suite Name Test Case Name Test Script Expected
Test Suite 1 Test Case 1_1 Test Script 1_1 Expected Result 1_1
Test Suite 1 Test Case 1_2 Test Script 1_2 Expected Result 1_2
Test Suite 1 Test Case 1_3 Test Script 1_3 Expected Result 1_3
Test Suite 2 Test Case 2_1 Test Script 2_1 Expected Result 2_1
Test Suite 2 Test Case 2_2 Test Script 2_2 Expected Result 2_2
Test Suite 2 Test Case 2_3 Test Script 2_3 Expected Result 2_3
Test Suite 3 Test Case 3_1 Test Script 3_1 Expected Result 3_1
Test Suite 3 Test Case 3_2 Test Script 3_2 Expected Result 3_2
I tried to use RQM Excel Importer Utility to import some testcase, but in my situation, I have test suites,test cases,test script, test suite and test cases have a multiple relationship(1:N) and test cases and test script have a 1:1 relationship, I want all of them in a excel file, also it can be imported with all their links the excel file should be like this:
Test Suite Name Test Case Name Test Script Expected
Test Suite 1 Test Case 1_1 Test Script 1_1 Expected Result 1_1
Test Suite 1 Test Case 1_2 Test Script 1_2 Expected Result 1_2
Test Suite 1 Test Case 1_3 Test Script 1_3 Expected Result 1_3
Test Suite 2 Test Case 2_1 Test Script 2_1 Expected Result 2_1
Test Suite 2 Test Case 2_2 Test Script 2_2 Expected Result 2_2
Test Suite 2 Test Case 2_3 Test Script 2_3 Expected Result 2_3
Test Suite 3 Test Case 3_1 Test Script 3_1 Expected Result 3_1
Test Suite 3 Test Case 3_2 Test Script 3_2 Expected Result 3_2
One answer
![](http://jazz.net/_images/myphoto/938d8447b3f86d46667076fb6ad4bd1f.jpg)
in this scenario, it's better to move the test suite to another worksheet and using Link modifier to make the reference to multiple test cases,
e.g
Link(B) and column
A B
row1 test suite 1 case1_1 id <- separate ids by a new line '\n' in the same cell
case1_2 id
case1_3 id
row2
row3 test suite 2 case2_1 id <- separate ids by a new line '\n' in the same cell
case2_2 id
case2_3 id
row4
row5 test suite 3 case3_1 id <- separate ids by a new line '\n' in the same cell
case3_2 id
Comments
haizi wu
Sep 03 '12, 12:57 p.m.and my question is how to write the configuration file(cfg file) and the excel file should be like below: