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?
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.
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.