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

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

 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?

0 votes



3 answers

Permanent link
Jesse,
Take a quick look at this RFE:

RFE 61703

There is an example in comment #3

Ara

0 votes


Permanent link
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.



0 votes

Comments

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
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.

0 votes

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.

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
× 10,944

Question asked: Jun 11 '14, 3:46 p.m.

Question was seen: 9,363 times

Last updated: Feb 14 '15, 8:48 a.m.

Confirmation Cancel Confirm