It's all about the answers!

Ask a question

XLSArtifactID attribute for RQMExcelWordImporter


Andrew Trobec (49712144139) | asked Jun 01 '10, 2:25 a.m.
Hello,

I know that the attribute XLSArtifactID can be used to assign a sort of keyword to records so that the can be identified and updated with the RQMExcelWordImporter utility.

My question is:

How can I manually assign the XLSArtifactID attribute to existing records or new records that weren't created via the RQMExcelWordImporter utility so that they can be updated?

Thank you and best regards,

Andrew

Comments
Christophe Lucas commented Jun 27 '17, 3:31 a.m.

Have you received an answer to this question ? 

I have the exact same question (CLM 604), 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)
Thanks

2 answers



permanent link
Mehul Patel (9695) | answered Jun 28 '17, 1:00 a.m.
FORUM MODERATOR
Christophe,

XLSArtifactID specifies the external ID of the artifact, If artifact with that external ID exist in the repository then it updates the artifact otherwise it creates the artifact with provided ID.

You can refer 'Scripts that create testcases' file from sample folder where they have used column B to specify artifact ID. If you need to update the existing artifact then you need to retrieve the artifact ID from RQM repository and specify in that particular column. I've found some article describing how to access RQM artifact using REST API, please refer it. Detailed RQM REST API is documented at RQM API Wiki.

To retrieve testcases from repository you can refer below format to build your URL

https://<jazz server>:<port>/<application context i.e. qm>/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<project>/testcase

It will list available testcase URLs and you can extract testcase ID from those URLs.

Regards,
Mehul

Comments
Christophe Lucas commented Jun 28 '17, 1:05 a.m.

Thanks Mehul !


permanent link
Paul Slauenwhite (8.4k12) | answered May 27 '15, 7:28 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Note: This post is 4+ years old.

Please upgrade to the latest version of RQM (see https://jazz.net/downloads/rational-quality-manager/) and review the product documentation (see https://jazz.net/help-dev/clm/topic/com.ibm.help.common.jazz.calm.doc/com.ibm.help.common.jazz.calm.doc_eclipse-gentopic1.html) and jazz.net resources (see https://jazz.net/help).  If your issue persists, please ask a new question (https://jazz.net/forum/questions/ask), open a defect (see https://jazz.net/mystuff/#tab=workitems), or open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).

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.