It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,908

question asked: Jul 18 '19, 8:02 a.m.
question was seen: 1,429 times
last updated: Jul 30 '19, 4:50 a.m.

Related questions

FAQ - How this Forum works

How to import test cases inside the sections in RQM tool using RQM Excel importer.

0
Preetha T (27●2●25) | asked Jul 18 '19, 8:02 a.m.
edited Jul 18 '19, 8:04 a.m.

 Dear Team,


We are exporting the test cases from excel to RQM tool using RQMExcelImporter. We are having Multiple test cases & then each test case having test steps & expected result.

In web application RQM, we customised sections like Summary section which will have the attributes like Module name, test case description & another section called test steps(We modified section name Edit scripts inline to Test steps) which will have Manual test steps. So without creating test scripts we need test cases with test steps in a single page. 

When we are exporting test cases summary sections are importing but test steps are not importing.

Could you please tell me which syntax should use to import test steps inside the section. Please look into the below config file and please correct it if is wrong.

<o:p>   </o:p>

// Start looking for scripts after row 16 <o:p> </o:p>

<o:p>   </o:p>

testcase.XLSStartRow=17

<o:p>   </o:p> testcase.XLSArtifactID=D

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCase.edit.testscript","Test steps")=G

testcase.steps.type="execution"

testcase.steps.description=G <o:p> </o:p>

testcase.steps.expectedResult=H <o:p> </o:p>

<o:p>   </o:p>

// a new script starts when we encounter an empty row <o:p> </o:p>

testscript.XLSDelimeter=\n

testcase.dc:title=D

<o:p> </o:p>

// testcase.dc:description=testscript.dc:description <o:p> </o:p>

<o:p>   </o:p> testcase.category term="Module Name".value=C

testcase.category term="Priority".value="L1"

<o:p>   </o:p> testcase.customAttributes identifier="_5oHgsakrEem5MoDPCybrsg".name="Test Case ID".type="MEDIUM_STRING".value=D

<o:p> </o:p>

testcase.customAttributes identifier="_5pA4kKkrEem5MoDPCybrsg".name="Test Case Description".type="MEDIUM_STRING".value=E <o:p> </o:p>

testcase.customAttributes identifier="_5pKCgakrEem5MoDPCybrsg".name="Pre conditions".type="MEDIUM_STRING".value=F <o:p> </o:p>

testsuite.dc:title=C12

<o:p> </o:p>

testsuite.dc:description=C13 <o:p> </o:p>

testsuite.XLSLink=testcase <o:p> </o:p>


Please assist us.

Comments
Preetha T commented Jul 18 '19, 8:44 a.m.

 Can anyone reply to this question?

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
sreenath v (78●1●67) | answered Jul 19 '19, 2:35 a.m.

// 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 after row 2
testscript.XLSStartRow=13

// 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

// 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=D
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F
testscript.steps.comment=E

// 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
testcase.ID=testscript.XLSArtifactID

// 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
testcase.Section("com.ibm.rqm.planning.editor.section.testSuitePreCondition", " RQM-KEY-TSUITE-PRE-COND-TITLE")=L

Comments
Preetha T commented Jul 30 '19, 4:30 a.m.

 Dear Sreenath,


We have to import both test action & expected result (Manual steps) inside one section. For that what is the syntax to write config file.

0
permanent link
Bharath Rao (915●1●36) | answered Jul 30 '19, 4:50 a.m.

 Hi Preetha,


I haven't tried it but, you may be able to append the content of test action and expected result to a single section using the '&'

&  The ampersand symbol is used to add two or more bits of data to the same field. The data can be a mix of items such as: testcase.description=”my description:” & C4 & testscript.description

Reference:

Please let me know if you have any questions.

Regards,
Bharath

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.