It's all about the answers!

Ask a question

Easy way to upload several categories, subcategories and the values in each of them


renuka vasudevan (138) | asked Aug 24 '15, 6:00 a.m.

I am using RQM 5.0.1 and i would like to create several categories/sub categories and i have multiple values in each of them. Is there an easier way to get these values created from excels.

Is it possible to achieve this thru RQMExcelImporter utility?

My category structure is

Solution

Release

Vertical

Locale

Module-submodule

Feature-subfeature

Business event

Business sub event.


Comments
renuka vasudevan commented Oct 06 '15, 7:40 a.m. | edited Oct 23 '15, 10:17 p.m.

can somebody help me with my query

3 answers



permanent link
Reshma Ratnani (1.1k1) | answered Aug 24 '15, 6:06 a.m.
JAZZ DEVELOPER
Yes Renuka it is possible using Excel Importer. Try below .cfg syntax

categoryType.XLSStartRow=2
categoryType.dc:title=A
categoryType.XLSArtifactID=A
categoryType.dependsOn=Link(C)
// case sensitive
categoryType.scope="TestCase"
categoryType.required="false"
categoryType.multiSelectable="false"

category.XLSStartRow=2
category.dc:title=B
category.XLSArtifactID=B
category.categoryType=link(A)


Comments
renuka vasudevan commented Aug 24 '15, 6:11 a.m.

Hi reshma ,

It would be nice if you could share the excel template also which i can use for this upload , for the category structure marked in my question.

Thanks

Renuka


permanent link
Reshma Ratnani (1.1k1) | answered Aug 24 '15, 6:19 a.m.
JAZZ DEVELOPER




Hi Renuka,

below is the screenshot of that .xls sample



Comments
renuka vasudevan commented Aug 26 '15, 9:44 a.m.

I have tried with this config file , and on and off i am getting this run time error during the export. The error message is "Unable to cast object of type 'System.String' to type 'Sytem.Collections.ArrayList'. Request your help in resolving this


permanent link
Reshma Ratnani (1.1k1) | answered Aug 24 '15, 6:21 a.m.
JAZZ DEVELOPER

Comments
renuka vasudevan commented Aug 24 '15, 7:32 a.m.

Hi reshma , thanks for the response , but if i have the category structure which involves 6 levels , can u give me one sample in excel which can help me understand.


renuka vasudevan commented Aug 24 '15, 9:19 a.m.

Hi ratani , thanks , i think i figured out the excel myself. i want to know what all values can this command have categoryType.scope

Please validate if the following is fine. I was not sure , as it is mentioned that it is case sensitive also and i could not find much documentation on this

categoryType.scope="TestPlan"

categoryType.scope="Keywords"

categoryType.scope="TestSuite"

categoryType.scope="TestScript"

For TCER can u tell what it would be.

Your answer


Register or to post your answer.