About Excel Importer Utility
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
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: