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.


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.