Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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.

0 votes

Comments

can somebody help me with my query



3 answers

Permanent link
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)

0 votes

Comments

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




Hi Renuka,

below is the screenshot of that .xls sample


0 votes

Comments

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

0 votes

Comments

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.

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 log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,029

Question asked: Aug 24 '15, 6:00 a.m.

Question was seen: 3,013 times

Last updated: Oct 23 '15, 10:17 p.m.

Confirmation Cancel Confirm