It's all about the answers!

Ask a question

3 Way Linking works but get DUPLICATE test script Links


tina fusari (3643) | asked Jun 16 '11, 9:28 a.m.
I got my Test Plan, Test Case & Test Script to finally link together in one load using the Excel Import Utility for RQM. The only problem is that each test case created, links to ALL test scripts in the file. Is it possible to get that 1:1 relationship with the Test Case and Test Script in one load while everything is still linked together?

My Excel file will always have 1 Test Plan, and a lot of Test Scripts that will create its corresponding Test Case (1:1 relationship).



My Config file Below:



//----------------------------------------------------------------
//---Test Plan---
// Start looking for test plan after row 2
testplan.XLSStartRow=2
testplan.dc:title=A
testplan.dc:description=B
// Add additional categories by copying the line above and mapping to the appropriate column(s).
testplan.XLSLink=testcase

//----------------------------------------------------------------


//----------------------------------------------------------------
//---Test Scripts---
// Start looking for scripts after row 2 - row 1 is headers
testscript.XLSStartRow=2
testscript.dc:title=C
testscript.dc:description=D
testscript.steps.type="execution"
testscript.steps.title=E
// The item above refers to Step titles, 'i.e. 1, 2, 3'
testscript.steps.description=F
testscript.steps.name=E
testscript.steps.expectedResult=G
testscript.XLSDelimeter=\n
//----------------------------------------------------------------



//----------------------------------------------------------------
//---Test Case---
// Start looking for test case after row 2
testcase.XLSStartRow=2
testcase.dc:description=D
testcase.dc:title=C
//testcase.category term="Application".value=K
// Add additional categories by copying the line above and mapping to the appropriate column(s).
testcase.XLSDelimeter=\n
testcase.XLSLink=testscript
//----------------------------------------------------------------

2 answers



permanent link
Paul Slauenwhite (8.4k12) | answered Jun 20 '11, 8:59 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
I got my Test Plan, Test Case & Test Script to finally link together in one load using the Excel Import Utility for RQM. The only problem is that each test case created, links to ALL test scripts in the file. Is it possible to get that 1:1 relationship with the Test Case and Test Script in one load while everything is still linked together?

My Excel file will always have 1 Test Plan, and a lot of Test Scripts that will create its corresponding Test Case (1:1 relationship).



My Config file Below:



//----------------------------------------------------------------
//---Test Plan---
// Start looking for test plan after row 2
testplan.XLSStartRow=2
testplan.dc:title=A
testplan.dc:description=B
// Add additional categories by copying the line above and mapping to the appropriate column(s).
testplan.XLSLink=testcase

//----------------------------------------------------------------


//----------------------------------------------------------------
//---Test Scripts---
// Start looking for scripts after row 2 - row 1 is headers
testscript.XLSStartRow=2
testscript.dc:title=C
testscript.dc:description=D
testscript.steps.type="execution"
testscript.steps.title=E
// The item above refers to Step titles, 'i.e. 1, 2, 3'
testscript.steps.description=F
testscript.steps.name=E
testscript.steps.expectedResult=G
testscript.XLSDelimeter=\n
//----------------------------------------------------------------



//----------------------------------------------------------------
//---Test Case---
// Start looking for test case after row 2
testcase.XLSStartRow=2
testcase.dc:description=D
testcase.dc:title=C
//testcase.category term="Application".value=K
// Add additional categories by copying the line above and mapping to the appropriate column(s).
testcase.XLSDelimeter=\n
testcase.XLSLink=testscript
//----------------------------------------------------------------


The XLSLink keyword (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Keywords_and_special_cases) links <b>all</b> artifacts of the specified type in the worksheet. As such, each test case will be linked to <b>all</b> of the test scripts in the worksheet.

To import a 1:1 relationship between resources, use self referenced links (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Data_locations_and_self_referent). Note, self referenced links cannot be used with the XLSLink keyword. For example:

Configuration:
testscript.XLSStartRow=1
testscript.dc:title=C

testcase.dc:description=testscript.dc:title
testcase.XLSStartRow=1
testcase.dc:title=B

testplan.dc:description=testcase.dc:title
testplan.XLSStartRow=1
testplan.dc:title=A

Excel:
A B C
1 testplan1 testcase1 testscript1
2 testplan2 testcase2 testscript2

permanent link
Paul Slauenwhite (8.4k12) | answered Jun 20 '11, 9:03 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
I got my Test Plan, Test Case &amp; Test Script to finally link together in one load using the Excel Import Utility for RQM. The only problem is that each test case created, links to ALL test scripts in the file. Is it possible to get that 1:1 relationship with the Test Case and Test Script in one load while everything is still linked together?

My Excel file will always have 1 Test Plan, and a lot of Test Scripts that will create its corresponding Test Case (1:1 relationship).



My Config file Below:



//----------------------------------------------------------------
//---Test Plan---
// Start looking for test plan after row 2
testplan.XLSStartRow=2
testplan.dc:title=A
testplan.dc:description=B
// Add additional categories by copying the line above and mapping to the appropriate column(s).
testplan.XLSLink=testcase

//----------------------------------------------------------------


//----------------------------------------------------------------
//---Test Scripts---
// Start looking for scripts after row 2 - row 1 is headers
testscript.XLSStartRow=2
testscript.dc:title=C
testscript.dc:description=D
testscript.steps.type=&quot;execution&quot;
testscript.steps.title=E
// The item above refers to Step titles, 'i.e. 1, 2, 3'
testscript.steps.description=F
testscript.steps.name=E
testscript.steps.expectedResult=G
testscript.XLSDelimeter=\n
//----------------------------------------------------------------



//----------------------------------------------------------------
//---Test Case---
// Start looking for test case after row 2
testcase.XLSStartRow=2
testcase.dc:description=D
testcase.dc:title=C
//testcase.category term=&quot;Application&quot;.value=K
// Add additional categories by copying the line above and mapping to the appropriate column(s).
testcase.XLSDelimeter=\n
testcase.XLSLink=testscript
//----------------------------------------------------------------


The XLSLink keyword (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Keywords_and_special_cases) links <b>all</b> artifacts of the specified type in the worksheet. As such, each test case will be linked to <b>all</b> of the test scripts in the worksheet.

To import a 1:1 relationship between resources, use self referenced links (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Data_locations_and_self_referent). Note, self referenced links cannot be used with the XLSLink keyword. For example:

Configuration:
testscript.XLSStartRow=1
testscript.dc:title=C

testcase.dc:description=testscript.dc:title
testcase.XLSStartRow=1
testcase.dc:title=B

testplan.dc:description=testcase.dc:title
testplan.XLSStartRow=1
testplan.dc:title=A

Excel:
A B C
1 testplan1 testcase1 testscript1
2 testplan2 testcase2 testscript2

You could also use the Link() keyword to link to existing resources with the RQM Excel/Word Importer 3.0.1 (see https://jazz.net/downloads/rational-quality-manager/releases/3.0.1?p=allDownloads), which is compatible with a RQM 2.x server. See https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/51360 for the documentation.

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.