[Closed] EXCEL Import customization to import TestPlan, Test case and Test suite
I have installed RQMExcelImporter.
I went through the installation folder and found some excel formats for below options-
1. Exporting TestPlans with Test cases to RQM.
2. Exporting Testsuits with Test cases to RQM. etc.
I am looking for an option to customize the RQMExcelImporter to get below options.
1. Importing Testcases and Testsuits under single Test Plan.
2. Importing Testsuits and Linking existing test cases.
Please support,
Thanks,
Regards,
Chethan Kumar R
Accepted answer
There is no existing cfg file which would work for your use case 1.
Since you tried example of importing test case and test plan and link them, similar thing can be done for test suite and test plan, you may need to trial and error to find a working cfg file. Make a copy of the existing cfg example and add some similar commands for testsuite and test plan and see how it works.
There are questions to ask though in use case1:
- whether you want to import test plan, test suite and test cases at the same time or any of them already exist.
whether test case will be a part of test suite as well etc
- for the use case 2: you can try testsuite.testcase=link(xx)
xx can be cell(cells) with the existing test case internal id or external id.
Comments
I am creating a new set of requirement, New Test Plan, New set of Test cases and New set of Test suits.
I need to export all to RQM. Create new Requirement NQ set in Doors, Create new testplan A, Create new Test cases TC under the Test Plan A.
Create new multiple Test suits Under test plan A and link to the already created Test cases TC.
I need to do all this at one shot with one Excel sheet import.
Kindly let me know the possibility.
Thanks,
the sample provides importing test plan and test case and linking them, also there is a sample for test suite and test cases and linking them. you need to combine both of them into one confiig file and add test suite to the test plan as well(similar to how to add test cases into a test plan).
If requirements are in Doors, then it is not supported in ExcelImporter, it only supports requirements in Doors Next Generation.
Hello Yang,
Using sample configuration If I try to create requirements, it throws an new window asking login for RM. Linked RM project drop down contains the option: Contact admin/ No RM project linked. RM Server is empty.
Not able to login could you please support
I am working on the Merging part but struck with this requirement export.
Thanks,
What version of QM and RM are you using?
As said, ExcelImporter only supports Doors Next Generation(RDNG) as requirements provider. If you are using DNG, the RM project should be associated with QM project area(like the same JKE Banking project areas, QM, RM and CCM are all associated).
I am using Doors Next Generation 6.0.1 and Quality management 6.0.1
Both are associated.
Still I have this problem :(
is your DNG and QM projects associated in your environment?
Yes as for my understanding associated.
RM as the RQM link and RQM as the RM link.
Is there any other way we can see, is it associated or not?
we need to create multiple testsuits how can it be handled?
Eg- Cell (6,B), Cell(7,B) and Cell(8,B) sometimes more than 3.
How can I generalize and create multiple test suits and link to testplan
Have tried something like this
testplan.dc:title=C1
testplan.Section("myns:com.ibm.rqm.planning.editor.section.planBusinessObjectives","RQM-KEY-TP-BUSS-OBJ-TITLE")=C2
testplan.XLSLink=testcase
testcase.XLSStartRow=7
testplan.XLSWorksheetID="TestPlan"
testcase.dc:title=B
testcase.dc:description=E
testcase.jzalm:owner=C
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=F
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=L
testsuite.XLSStartRow=7
testsuite.XLSWorksheetID="TestSuite"
testsuite.dc.title=B
but it creates additional test cases in the name of Testsuites.
it's better you can create a new post if you have multiple questions so that we can make it clear or someone else in the community may answer your questions.
1) for QM-RM association
you can go to QM project's admin and overview > Association field and under 'Uses"
it should have "Requirements Requirement project area name " entry there
in QM project's admin > overview > Association field, under "provides",
it should show "Requirements QM project area name" entry there.
In a short, if you manually go to a test case and try to add a requirement link, it should bring up a dialog for selecting a requirement from your RM project.
2) creating multiple test suites
the way you create multiple test cases applied to test suites
I notice you use testsuite.XLSWorksheetID="TestSuite"
so you have a sheet named TestSuite in which you will get the TestSuite details from?
"testsuite.dc.title=B " does not seem to correct, it should be testsuite.dc:title=B
if you have title details for each testsuite in column B
In the above comment 'Uses" and "provides" both need to be configured in QM project but I am not finding that option.
So I have configured as below -
QM project's admin and overview > Association field and under 'Uses"
has "Requirements Requirement project area name " entry.
RM project's admin and overview > Association field and under 'provides"
has "Requirements QM project area name " entry.
* In Test case, try to add a requirement link. it's brings up a dialog for selecting a requirement from your RM project
But If I try requirement export with excel still its giving me the same window saying check with admin.
if the association is set properly, make sure the user is the member of RDNG project area and license for RM is allocated to the user.
There is a known defect in v6.0 but it is fixed in v6.0.1 as I know. As you are with v6.0.1, it should have the fix built-in.
I am one of the admin in RDNG. License is also available but Not able to understand why its not allowing me to export requirements.
Comments
Lily Wang
Aug 10 '16, 4:54 a.m.The samples provided are as-is. You can refer to https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter about how to write a config file.