It's all about the answers!

Ask a question

How do I set up config file for RQM Excel Import Tool to import Test Cases linked to mulitple Test Scripts?


Michael Kuk (111) | asked Dec 01 '17, 1:29 p.m.

Hello Forum,

 I am trying to import Test Cases that link to multiple Test Scripts.

  • Two test cases (TC1 and TC2) that are linked to multiple test scripts (TS1, TS2, TS3, TS4, TSx)

  • TC1 links to both TS1/TS2, TC2 links to all of TS3/TS4/...TSx

  • **TS1, TS2, …TSx can each have multiple steps

 

This Config file below handles the standard 1:1 for TC to TS.

New Configuration File addresses:

  • Column/Field for Test Script Name

  • Connection/Link of additional TS(s) to a TC

  • differentiating between new TC2 vs Additional TS on current TC1

// This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data


// Start looking for scripts on row 9
testscript.XLSStartRow=9

// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=C
testscript.precond=D
testscript.postcond=E
testscript.tcexpectedresults=F


// 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.title=B
testscript.steps.name=B
testscript.steps.description=H
testscript.steps.expectedResult=I
testscript.steps.property name="comment"=J


// 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 and set attributes
testcase.ID=testscript.XLSArtifactID
testcase.category term="Application".value=C1
testcase.category term="Function".value=C2
testcase.category term="Test Category".value=C3
testcase.category term="Release".value=C4
testcase.category term="Test Phase".value=C5
//testcase.category term="Weight".value="100"
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=D
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=E
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=F


// by referring 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

 

 

 I would appreciate any insight on this. Thank you.

Very Respectfully,

Michael Kuk

 

 

 

One answer



permanent link
Don Yang (7.2k2194127) | answered Dec 04 '17, 6:55 p.m.

Your answer


Register or to post your answer.