It's all about the answers!

Ask a question

How can I add multiple TCER per test case with RQMExcelImporter?


jeff mccallum (302912) | asked Jul 25 '13, 6:39 p.m.
 Hello,
The xls I have has four rows with the same test case name. Each row has different column data.
I need to create 1 test case for all four rows and then create 1 test script and then 4 TCERs .

Testcase name |   Switch Type
Test1          |        brocade    |
Test1          |         qlogic      |
Test1          |         Mcdata    |
Test1          |         whatever |

Is this possible?

It looks like it is a 1 to 1 to 1 mapping of test case to test script to test execution record at this point via importer.

I was using the cfg format:

// Start looking for scripts after row 2
testscript.XLSStartRow=3

// use the data in the first row of a found script's column B
testscript.XLSArtifactID=Q
testscript.dc:title=Q
//testscript.dc:description=C

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
//testscript.steps.type="execution"
//testscript.steps.description=E
//testscript.steps.title=D
//testscript.steps.name=D
//testscript.steps.expectedResult=F

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID

// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description


Any help is greatly appreciated.

2 answers



permanent link
Hao Wan (1.5k35) | answered Jul 25 '13, 11:11 p.m.
JAZZ DEVELOPER
 Hi Jeff, 
which version of importer are you using? I think you can refer to the latest samples in the 4.0.3 Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.xls

Comments
jeff mccallum commented Jul 26 '13, 12:19 a.m.

 Hi Hao,

Unfortunately I am on 4.0.2. Does that example work with my version?
Thanks 


permanent link
Antoinette Iacobo (650712) | answered Jul 29 '13, 10:20 a.m.
 Hi Jeff,
Take a look at this link for the Wiki: 
https://jazz.net/wiki/pub/Main/ExcelWordImporterBestPractice/Migrate_MS_office_document_to_RQM_--_complicate_scenarios.pdf
"Section 8: Migrate test case, script, execution workitem and execution result" has an example.  

Your answer


Register or to post your answer.