It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,956
×6,109

question asked: Sep 03 '12, 12:42 p.m.
question was seen: 4,538 times
last updated: Sep 03 '12, 10:10 p.m.

Related questions

About Excel Importer Utility

0
haizi wu (60●5●42●48) | asked Sep 03 '12, 12:42 p.m.
edited Sep 03 '12, 12:58 p.m.
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

 
Comments
haizi wu commented Sep 03 '12, 12:55 p.m. | edited 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:

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Hao Wan (1.5k●3●5) | answered Sep 03 '12, 9:18 p.m.
JAZZ DEVELOPER
 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 commented Sep 03 '12, 10:10 p.m.

Could you give the sample, I am new in RQM, tks so much!

Your answer

Register or 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.