It's all about the answers!

Ask a question

Can I upload test scripts in Excel that contain RQM keywords that are already in the system?


Jesse Houldsworth (1811111) | asked Jun 11 '14, 3:46 p.m.
 I have a customer that has written some test scripts in Excel. In these test scripts, they reference a keyword that is already stored in RQM. Is there a way to import this test script and have it point to the keyword in RQM?

3 answers



permanent link
Ara Masrof (3.2k15) | answered Jun 11 '14, 4:18 p.m.
JAZZ DEVELOPER
Jesse,
Take a quick look at this RFE:

RFE 61703

There is an example in comment #3

Ara


permanent link
Diao Xian Feng (361) | answered Jun 12 '14, 3:16 a.m.
Hi Jesse,

If the keywords is existed in the QM server, then you can by follow steps:
1, get the existing keyword's internal id by REST API, keyword's internal id looks like "urn:com.ibm.rqm:keyword:3"

https://[IP]:[PORTS]/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/keyword

2, using .cfg file as follow format,

    testscript.XLSStartRow=2
    testscript.XLSArtifactID=C
    testscript.dc:title=B
    testscript.XLSWorksheetID="testscripts"
    testscript.steps.type="execution"
    testscript.steps.description=B
    testscript.steps.title=B
    testscript.steps.name=B
    testscript.steps.expectedResult=F
    testscript.XLSDelimeter=\n
    keyword.XLSStartRow=2
    keyword.XLSWorksheetID="keywords"
    keyword.testscript=Link(D)
    keyword.XLSArtifactID=E


3, using .xls file as follow.




Comments
Rajah Vedamurthy commented Jun 12 '14, 10:55 a.m.

Hi Diao,
The above looks like a possible solution, can you send me the template along with .cfg file, so that I can try the same in my dev environment. my id is rvedamurthy@bjs.com.


permanent link
Stephen Meehan (23144) | answered Feb 14 '15, 8:48 a.m.
Hi Diao,
I can't get this to work.  I get the following error in the logs: Error when getting testscript with the id "urn:com.ibm.rqm:keyword:22"
22 is the id of the keyword in RQM.  Can you let me know where I could be going wrong or post working example with some more detail.

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.