It's all about the answers!

Ask a question

Remove TC section ID using testcase.ID=testscript.XLSArtifactID


Welborn Smith (144) | asked Aug 22 '12, 5:22 p.m.

Hello,

My spreadsheet has multiple cases and scripts on one tab for 1x1 linking as users do not care for multiple tabs.

Our naming convention needs to be retained as we start test cases with 'TC_' and test scripts with 'TS_'

My issue is that the test case is getting created with one new section, one named ‘ID’ with text containing the test script name.

From reading Hao’s reply to my previous post it sounds like this new section is being created in support of that one-to-one linking with different names  Is that correct?

If so is there any way to programmatically remove these sections after they are created?  I am able to update it with informative text but would rather remove it altogether if possible.

It appears that all is okay when I manually remove it so to clean things up  I'd like to include removing this new section in this process after linking the artifacts if at all possible.

Or am I still missing something...  An updated config is below.

Thanks again,

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

//Link the test case and test script.
//Note: This will create a new section in the test case named 'ID' to store the XLSArtifactID during import.
//This test case section (ID) may be removed after import.
testcase.ID=testscript.XLSArtifactID

//Inform the user about the ID section created above.
testcase.Section("myns:ID","ID")="This section was created in support of the Excel import.  You may remove this section."

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

//Set the test case title.
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 cases 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="System".value=V
testcase.category term="Subsystem".value=W
testcase.category term="Test Type".value=X
testcase.category term="Test Level".value=Y 

//Import valid test case project specific categories.  Do not alter columns A - Y.
//Uncomment the next line to use. Custom categories may start with column Z.
//testcase.category term="YourCategoryName".value=TheColumnInSpreadsheet

//End of file

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

Test Script ID Test Script Description Req # Test Script Step # Test Script Step
Description
Test Data Expected Results Actual Results Pass/Fail Test Script Status Iteration# Defect # Comments Priority Owner Test Cycle System Subsystem Test Type Test Level
TS_Test_Script1 Test_Script1_Description_1   1 Test_Script1_Step_Description_1
  Test_Script1_Expected_Results_1             2-High ABXXXXX Functional WGS Member SIT User Acceptance Test
      2 Test_Script1_Step_Description_2
  Test_Script1_Expected_Results_2                          
      3 Test_Script1_Step_Description_3
  Test_Script1_Expected_Results_3                          
      4 Test_Script1_Step_Description_4
  Test_Script1_Expected_Results_4                          
      5 Test_Script1_Step_Description_5
  Test_Script1_Expected_Results_5                          
      6 Test_Script1_Step_Description_6
  Test_Script1_Expected_Results_6                          
      7 Test_Script1_Step_Description_7
  Test_Script1_Expected_Results_7                          
      8 Test_Script1_Step_Description_8
  Test_Script1_Expected_Results_8                          
      9 Test_Script1_Step_Description_9
  Test_Script1_Expected_Results_9                          
      10 Test_Script1_Step_Description_10
  Test_Script1_Expected_Results_10                          
      11 Test_Script1_Step_Description_11
  Test_Script1_Expected_Results_11                          
      12 Test_Script1_Step_Description_12
  Test_Script1_Expected_Results_12                          
      13 Test_Script1_Step_Description_13
  Test_Script1_Expected_Results_13                          
                                       
TS_Test_Script2 Test_Script2_Description_1   1 Test_Script2_Step_Description_1
  Test_Script2_Expected_Results_1
            1-Urgent ABYYYYY Regression WGS Member SIT Subsystem Test
      2 Test_Script2_Step_Description_2
  Test_Script2_Expected_Results_2                          
      3 Test_Script2_Step_Description_3
  Test_Script2_Expected_Results_3                          
      4 Test_Script2_Step_Description_4
  Test_Script2_Expected_Results_4                          
      5 Test_Script2_Step_Description_5
  Test_Script2_Expected_Results_5                          
      6 Test_Script2_Step_Description_6
  Test_Script2_Expected_Results_6                          
      7 Test_Script2_Step_Description_7
  Test_Script2_Expected_Results_7                          
      8 Test_Script2_Step_Description_8
  Test_Script2_Expected_Results_8                          
      9 Test_Script2_Step_Description_9
  Test_Script2_Expected_Results_9                          
      10 Test_Script2_Step_Description_10
  Test_Script2_Expected_Results_10                          
      11 Test_Script2_Step_Description_11
  Test_Script2_Expected_Results_11                          
      12 Test_Script2_Step_Description_12
  Test_Script2_Expected_Results_12                          
      13 Test_Script2_Step_Description_13
  Test_Script2_Expected_Results_13                          

One answer



permanent link
Hao Wan (1.5k35) | answered Aug 28 '12, 11:18 p.m.
JAZZ DEVELOPER
Hi Welborn,
please refer to the comment in the post
https://jazz.net/forum/questions/85665/remove-tc-section-id-xlsartifactid-after-creating-link-with-testcaseidtestscriptxlsartifactid

Your answer


Register or to post your answer.