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

Possible to export RQM Test Cases to xls, update 'Name' of Test Cases in xls, re-import into RQM ?

Questions
Tags
Users
Badges
Christophe Lucas
(862●3●49●48) Jun 26 '17, 11:38 p.m.

 I am struggling to find how to format the .xls and .cfg file used by RQMExcelImporter utility to address this use case:


1. Create 5 Test Cases in RQM
2. Export these 5 Test Cases in xls
3. Change the Name of these 5 Test Cases in xls
4. By using RQMExcelImporter, re-import these 5 Test Cases so that the 5 RQM Test Cases are updated with new Name (NO new Test Case should be created)

Issue really seems to be: How does RQMExcelImporter .cfg/.xls identify the Test Cases 'primary key' so the correct Test Case is updated, and NO new Test Cases are created.

Any help appreciated, thanks

0 votes

2 answers
2,693 views
0 votes

Accepted answer

Permanent link
Don Yang
(7.7k●21●114●139) Jun 27 '17, 1:45 a.m.

Hi, Christophe

So the key from your question is not to create new test cases. In that case, you can consider using
keyword XLSArtifactID in your cfg to specify the external id for test case. If the external id is the same, it would "update" the same test case in RQM without creating a new one.

There are many sample cfg/xls in ExcelImporter install in which you can find XLSArtifactID is used. You can try to use
those samples and import into your RQM and see what happens.

Christophe Lucas selected this answer as the correct answer

1 vote

One other answer

Permanent link
Christophe Lucas
(862●3●49●48) Jun 27 '17, 6:46 a.m.

Thanks Don !

So, I have used testcase.XLSArtifactID in my .cfg file.
IF I used RQMExcelImporter to originally create the 5 TCs, I can then indeed update these TC names in Excel, then re-import using the importer, and that will update the existing 5 TCs.
BUT
That's not yet what I was asking for, i.e. a case where (see 1. above) the 5 TCs were originally created in RQM (NOT via RQMExcelImporter). I have tested that, but the first import using RQMExcelImporter creates 5 new TCs all the time, i.e. does NOT update the 5 existing ones originally created in RQM.

So my question now is the same as in this forum post: XLSArtifactID Attribute for RQMExcelImporter i.e.: How to find(/assign) the XLSArtifactID attribute of(/to) existing Test Cases that were created in RQM (i.e. NOT via the RQMExcelWordImporter utility) ?

0 votes

Comments
Don Yang
Jun 27 '17, 8:14 p.m.

Sorry I misread your 1) Create 5 Test Cases in RQM.
If test case was created in UI, there is no external id concept for which you can use ExcelImporter to update anything on the same test case.
In your case, you may consider to use REST API to update the name. You can use any REST Client and PUT command to update the test case or try RQMURLUtility:
https://jazz.net/wiki/bin/view/Main/RQMURLUtility

There are a number of discussion in this area(using REST API to update test artifacts) in jazz.net. for example, the below discussion is to update custom attribute but the approach applies. As you want to update the name of test case, if you can GET xml file of test case in which a name is there, then change it and PUT it back to update.

https://jazz.net/forum/questions/166226/how-do-i-update-a-testcase-custom-attribute-using-rest-api

1 vote

Christophe Lucas
Jun 27 '17, 10:16 p.m.

Thanks again Don !

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,015

Question asked: Jun 26 '17, 11:38 p.m.

Question was seen: 2,693 times

Last updated: Jun 27 '17, 10:16 p.m.

Related questions
Confirmation Cancel Confirm