It's all about the answers!

Ask a question

I am getting following error message while importing testcase from excel to RQM? Can anyone help me!


Badrinath Venu (1132) | asked Sep 03 '13, 8:31 a.m.


I am using the following in config file.
//---Requirements
// Start looking for requirements after row 2
requirement.XLSStartRow=2
requirement.XLSArtifactID=A
requirement.dc:title=B
//requirement.dc:description=C

//---Test Scripts
// Start looking for scripts after row 2
testscript.XLSStartRow=2

// use the data in the first row of a found script's column B
// Test script is using the same XLSArtifactID as requirement
testscript.XLSArtifactID=A
testscript.dc:title=F
testscript.dc:description=G

// 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=J
testscript.steps.title=F
testscript.steps.name=F
testscript.steps.expectedResult=K

// Pre-Condition
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testcasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=H

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n

//--- Test Case
// Start looking for test case after row 2
testcase.XLSStartRow=2

// a new test case starts when we encounter an empty row
testcase.XLSDelimeter=\n

//Test case and requirement are having the same XLSArtifactID
// This is for the TestCaseUpdater Utility
testcase.XLSArtifactID=A
testcase.XLSArtifactID=E
testcase.ID=requirement.XLSArtifactID


//Link test case to requirement
//This line will link test case to all requirements in the xls file
//testcase.requirement=requirement.identifier

// Categories are defined in a special way
testcase.category term="Category".value=D
testcase.category term="Function".value=D

// Link test case to test script
// self referential links must be declared before also using column definitions
// Below lines will create test case and test script in same name but they can link each other
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description



REQUIREMENT ID REQUIREMENT NAME FUNCTION NAME CATEGORY NAME TEST CASE NAME TEST SCRIPT NAME TEST SCRIPT DESCRIPTION PRE-CONDITION TEST STEP NO TEST STEP DESCRIPTION EXPECTED RESULT

One answer



permanent link
Tory Jaskoviak (52015) | answered Sep 18 '13, 10:35 a.m.
JAZZ DEVELOPER
This looks like a duplication of RQM Export Error.

Chenyue provided the following response:

Hi Badrinath, I saw the configuration file in another post of you. Please add requirement.resourceShape="Requirement" in your configure file and try again. If it still doesn't work please send me your Demo.xlsx. Thanks

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.