Import Test Plan with Category (Excel file) RQM 2
![](http://jazz.net/_images/myphoto/9813b1f7d8fa30047b6286c93aa36275.jpg)
Import Test Plan with an Excel File
When I Importe a list of Test Plans without Category, all test Plans in the Excel sheet are generated in an XML file.
(example of the Config file)
Test plan from Test Plan
testplan.XLSStartRow=3
testplan.dc:title=B
testplan.dc:description=C
When I Import a list of Test Plans with at least one Category, only the first test Plans in the Excel sheet is generated in an XML file.
(example of the Config file)
Test plan from Test Plan
testplan.XLSStartRow=3
testplan.dc:title=B
testplan.dc:description=C
testplan.category term="Product".value=D
testplan.category term="Release".value=E
testplan.category term="Test Phase".value=F
Someone know how to generate all the Test Plans with the Category ?
When I Importe a list of Test Plans without Category, all test Plans in the Excel sheet are generated in an XML file.
(example of the Config file)
Test plan from Test Plan
testplan.XLSStartRow=3
testplan.dc:title=B
testplan.dc:description=C
When I Import a list of Test Plans with at least one Category, only the first test Plans in the Excel sheet is generated in an XML file.
(example of the Config file)
Test plan from Test Plan
testplan.XLSStartRow=3
testplan.dc:title=B
testplan.dc:description=C
testplan.category term="Product".value=D
testplan.category term="Release".value=E
testplan.category term="Test Phase".value=F
Someone know how to generate all the Test Plans with the Category ?
3 answers
![](http://jazz.net/_images/myphoto/9813b1f7d8fa30047b6286c93aa36275.jpg)
Import Test Plan with an Excel File
When I Importe a list of Test Plans without Category, all test Plans in the Excel sheet are generated in an XML file.
(example of the Config file)
Test plan from Test Plan
testplan.XLSStartRow=3
testplan.dc:title=B
testplan.dc:description=C
When I Import a list of Test Plans with at least one Category, only the first test Plans in the Excel sheet is generated in an XML file.
(example of the Config file)
Test plan from Test Plan
testplan.XLSStartRow=3
testplan.dc:title=B
testplan.dc:description=C
testplan.category term="Product".value=D
testplan.category term="Release".value=E
testplan.category term="Test Phase".value=F
Someone know how to generate all the Test Plans with the Category ?
This appears to be a defect in the RQM Excel/Word Importer 2.x. I can import the following Excel data using your second configuration file into both RQM 2.0.1.1 iFix3 and RQM 3.0.1 using the RQM Excel/Word Importer 3.0.1 (https://jazz.net/downloads/rational-quality-manager/releases/3.0.1?p=allDownloads):
B C D E F
3 title1 description1 product1 release1 testPhase1
4 title2 description2 product2 release2 testPhase2
5 title3 description3 product3 release3 testPhase3