Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

 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.

0 votes



2 answers

Permanent link
 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

0 votes

Comments

 Hi Hao,

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


Permanent link
 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.  

0 votes

Your answer

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

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,022
× 22

Question asked: Jul 25 '13, 6:39 p.m.

Question was seen: 6,500 times

Last updated: Jul 29 '13, 10:20 a.m.

Related questions
Confirmation Cancel Confirm