It's all about the answers!

Ask a question

RQM 6.0.2: Excel Importer: How to import multiple test suites that have mutiple test cases and each test case has a test script with mutiple steps?


Neeta Valera (45340) | asked Aug 29 '16, 8:56 a.m.
Hi,
I have an excel file that has a test plan that has multiple test suites and each test suite has multiple test cases and each test case has a test script with multiple test steps.

I am trying to write the config file for it as follows:

// this configuration file will create a static testplan and a testase object for each one listed
// and link all testcase to the testplan

testplan.dc:title=A1
testplan.XLSLink=testsuite

//Config for Test Suite
testsuite.dc:title= A4
testsuite.XLSArtifactID=A4
testsuite.XLSLink=testcase
testsuite.XLSWorksheetID="Function"
testsuite.jzalm:owner=B1
// a new Suite starts when we encounter two empty rows
testsuite.XLSDelimeter=\n\n

// 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 at row 6
testscript.XLSWorksheetID="Function"
testscript.XLSStartRow=6

// use the data in the first row of a found script's column D- Purpose
testscript.XLSArtifactID=A
testscript.dc:title=A
testscript.dc:description=A

// 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=C
testscript.steps.expectedResult=D
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.XLSWorksheetID="Function"
testcase.XLSStartRow=6

// 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.XLSArtifactID=A

This config file creates the test plan, and one test suite with test cases and test scripts but adds the second test suite as a test case under the first test suite :( I use two \n\n to signal the start of the next test suite and i don't think it likes it.

Any ideas, how to go about this?
Thanks.

One answer



permanent link
Mehul Patel (9695) | answered Sep 07 '16, 3:16 a.m.
FORUM MODERATOR
Neeta,

You got it right, '\n\n' is not supported syntax. 

Do you have testcases shared across testsuit? You might want to try creating separate excel for this individual testsuite.

Regards,
Mehul

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.