It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,944
×4,710

question asked: Jun 17 '16, 3:15 a.m.
question was seen: 2,060 times
last updated: Jun 21 '16, 3:41 a.m.

Related questions

Test case excel import attribute identifier

0
Vijayveer Reddy (17●6●27) | asked Jun 17 '16, 3:15 a.m.
Hi,

Request your help,

In RQM, i have created 4 costume attributes (text fields),

i want to import the data from the excel sheet to RQM to these costume attributes.

In cfg file it is asking for "testcase.customAttributes identifier=" ,

how to find the identifier of these attributes.

Please your help needs in this.

Thanks and Regards,
Vijay


2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Nigel Powell (1●1) | answered Jun 17 '16, 8:39 a.m.

You will need to download the RQMURLUtility I do not have the URL but just do a search of Jazz.net to find that.

Once you have the installation you use the DOS Command Line prompt to run the utility.  I have pasted an example of a Test Case command line you will use to get the custom attributes information you need:

java -jar RQMUrlUtility.jar -command GET -user **** -password "****" -filepath C:\\DownLoad_XML.txt -url "https://jts.ent.corp.xxxx.com:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/IM_CLM+%28Quality+Management%29/testcase/urn:com.ibm.rqm:testcase:15667"

Note you will need to change the above for the following:

**** - Insert your Admin user ID

**** - Insert your Admin user ID password

-filepath: Select where you want the output to be saved

Within the quotes "https..." you will need to:

1/ change the "jts.ent.corp.xxxx.com:9443" to match your companies URL

2/ change the project name, in the above example it is "IM_CLM+%28Quality+Management%29"

3/ change the number 15667 at the end to match the Test Case number you wish to extract.

Eventually the entry in your .cfg file should look something like this:

testcase.customAttributes identifier="__Subject_Area".name="1 Subject Area".value=K4

Comments
Vijayveer Reddy commented Jun 20 '16, 4:41 a.m.

Hi Powell,

Thanks for your reply.

When i am trying to access the project with the below command and URL:

java -jar RQMUrlUtility.jar -command GET -user <XXX> -password <XXX> -filepath C:\Test.txt -url "https://XXXXX:9443/jts/service/com.ibm.rqm.integration.service.IIntegrationService/resources/RQM:%20Mobily%20IBM%20QA%20Project%20Area+%28Quality+Management
%29/testcase/urn:com.ibm.rqm:testcase:15295"

I am getting below error:

Error 503: CRJAZ1168E The following service was requested but cannot run: com.ibm.rqm.integration.service.IIntegrationService

Can you please guide me on this.

and my project name is RQM: Mobily IBM QA Project Area,

How to give the Provide the project name in URL (EX: RQM:%20Mobily%20IBM%20QA%20Project%20Area+%28Quality+Management
%29) Is this name is correct/

Please help me in this.

Thanking You...!

0
permanent link
Joao Carusi (263●3●14) | answered Jun 20 '16, 9:21 a.m.
Hi  Vijayveer,

You can get the "Project alias" using an URL like this:
https://host:port/contextRoot/service/com.ibm.rqm.integration.service.IIntegrationService/projects
https://localhost:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/projects

For more information please refer to:
https://jazz.net/library/article/1376

Thank you
Comments
1
Vijayveer Reddy commented Jun 21 '16, 3:41 a.m.

Hi Carusi,


Thanks for the Reply.

Now i can able to access the TC's using REST API. 
i got customAttributes identifier:

Thank you...!

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.