It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×11,923
×10,907

question asked: Aug 24 '15, 6:00 a.m.
question was seen: 2,392 times
last updated: Oct 23 '15, 10:17 p.m.

Related questions

FAQ - How this Forum works

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

0
renuka vasudevan (13●8) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Reshma Ratnani (1.1k●1) | 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

0
permanent link
Reshma Ratnani (1.1k●1) | 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
0
permanent link
Reshma Ratnani (1.1k●1) | 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.


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.