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

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

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

 

 

 

0 votes



One answer

Permanent link

Hi, Michael

Please find the info I shared here:

https://jazz.net/forum/questions/243495/rqm-tips-sharing-exporting-multiple-test-cases-with-test-scripts-by-rqmexcelimporter

Hopefully this helps.

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,017

Question asked: Dec 01 '17, 1:29 p.m.

Question was seen: 3,429 times

Last updated: Dec 04 '17, 6:55 p.m.

Confirmation Cancel Confirm