Hello,

I thought I’d debugged a configuration file update to import test cases and scripts under one Excel tab honoring separate naming conventions for both the test script and test case.  All is working great with the exception that the test case is getting created with two new sections, one named ‘ID’ with text containing the test script name, and a section named ‘XLSArtifactID’ with the test case name.

My configuration file is below… any help greatly appreciated.

Scott

---------------------------------------------------------------------

//Start looking for assets after row 1
testscript.XLSStartRow=2
testcase.XLSStartRow=2

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

//Set the test script name and ID
testscript.XLSArtifactID=F
testscript.dc:title=F

//Test scripts are not required to be in an approved state in order to run the TER record.  Test cases are.
//Importing test scripts as Draft to allow for edits.
//set testscript state to "Draft"
testscript.alm:state ="com.ibm.rqm.planning.common.new"

//Step type is defined within the spreadsheet <== need to add step type column to support reporting steps, TBD
testscript.steps.type="execution"

//Set the test script description
testscript.dc:description=G

//Set the test steps description
testscript.steps.description=J

//Set the expected result
testscript.steps.expectedResult=L

//Set the test case ID to match the test script ID
testcase.ID=testscript.XLSArtifactID

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

//Set the test case name and ID
testcase.XLSArtifactID=A
testcase.dc:title=A

//Test Cases need to be in Draft in order to generate TER records from underneath the test plan. 
//After genrating TER records mass update test cacses to 'Approved.  Test cases must be in an approved state to run the TER.
//set testcase state to "Draft"
testcase.alm:state="com.ibm.rqm.planning.common.new"

//Set the test case description
testcase.dc:description=B

//Set the test case precondition
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=Pre(D2)

//Set the test case postcondition
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=Pre(E2)

//Set the Owner of the test case from Spreadsheet in Domain format (E.g.: AB92383)
//Owner must be entered as configured on the server, and must be a member of the RQM project which assets are being imported.
testcase.jzalm:owner=T

//Set test case weight = 100
testcase.weight="100"

//System/Subsystem category values should match Barometer IT/ClearQuest values.
//And the category values as defined in the Summary section of the Test Case
//Import valid test case Lean specific categories
testcase.category term="Priority".value=S
testcase.category term="Test Cycle".value=U
testcase.category term="Planview ID".value=V
testcase.category term="System".value=W
testcase.category term="Subsystem".value=X
testcase.category term="Test Type".value=Y
testcase.category term="Test Level".value=Z 

//Import valid test case project specific categories
//testcase.category term="YourCategoryName".value=TheColumnInSpreadsheet

//Link the test case and test script
testcase.XLSLink=testscript

//End of file