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

Questions
Tags
Users
Badges
renuka vasudevan
(13●1●9) 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.

0 votes

Comments
renuka vasudevan
Oct 23 '15, 10:17 p.m.
can somebody help me with my query

3 answers
5,723 views
0 votes

3 answers

Permanent link
Reshma Ratnani
JAZZ DEVELOPER (1.1k●1) Aug 24 '15, 6:06 a.m.
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
renuka vasudevan
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
JAZZ DEVELOPER (1.1k●1) Aug 24 '15, 6:19 a.m.




Hi Renuka,

below is the screenshot of that .xls sample


0 votes

Comments
renuka vasudevan
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
JAZZ DEVELOPER (1.1k●1) Aug 24 '15, 6:21 a.m.

0 votes

Comments
renuka vasudevan
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
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 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.

Ask a question
Guidelines
FAQ
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,143

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

Question was seen: 5,723 times

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

Confirmation Cancel Confirm