It's all about the answers!

Ask a question

RQM Excel Importer: How to link new TCER to existing Test Plan from Excel to RQM?


Lionel Zocli (112) | asked Apr 25 '19, 12:01 p.m.
Hello,
I would like to link new TCER to an existing Test Plan. But I am facing an issue with the iteration (Testphase).
What instruction should be used for the RQM External ID? Is this expression correct?: executionworkitem.testphase=LinkExisting(C3)
in C3 cell, I have defined my Test Plan ID (urn:com.ibm.rqm:testplan:8354).

I am getting an error for the export of the testphase.

Thanks for your support.

One answer



permanent link
Miles Thompson (1824) | answered Apr 25 '19, 12:15 p.m.

 You write that you're trying to link a TCER to an existing Test Plan, but executionworkitem.testphase=LinkExisting() would like the TCER to a test schedule that may or may not be part of the test plan.


To link to an existing Test Plan by just the ID (e.g. 8354), try this:
executionworkitem.testplan=LinkByExistingID(C3)


Comments
Lionel Zocli commented Apr 26 '19, 6:20 a.m.
Thanks for the reply.

your suggestion is not working. I get this failure:

Initializing.....
Reading Configuration File....
Getting artifacts from document - "Initial_RQM_Import_test.xlsx".....
Error: Configuration File, Line 63, Found a value that reduced to "LinkByExistingID(C3)", but was expecting a value equivalent to a column, cell, or literal.

*** Exporting Aborted: Errors found! ***

I can link the test case to an existing test plan wihout problem by using this:
testcase.testplan.link=C3 where C3 cell contains urn:com.ibm.rqm:testplan:8354

But to link new TCER to an existing test plan, it is not working and no failure message (executionworkitem.testplan=LinkExisting(C3). I thought the problem was the testphase. This is why I also tried to associate the TCER to the related testphase of the testplan (executionworkitem.testphase=LinkExisting(C3))


Miles Thompson commented Apr 26 '19, 10:43 a.m.

That's unfortunate. I would have thought either the way I wrote it or the way you wrote it (executionworkitem.testplan=LinkExisting(C3)) would work. I have had success with executionworkitem.testplan=Link(C3) when simultaneously importing the TCER and the Test plan. This should work when C3 contains the XLSArtifactID, not the URL. I'm not sure why testcase.testplan.link=C3 is working with the URL, but maybe the syntax is different than testcase.testplan=Link(C3).


Recapping what you've tried:
  • executionworkitem.testphase=LinkExisting(C3) --  Error for exporting
  • executionworkitem.testplan=LinkByExistingID(C3) -- Error, didn't understand that C3 was a cell
  • executionworkitem.testplan=LinkExisting(C3) -- No linking and no error
My suggestions to try:
  • executionworkitem.testplan=Link(C3)
  • executionworkitem.testplan.link=C3
Let us know how it goes!

 


Lionel Zocli commented May 03 '19, 7:08 a.m.
Hi,
Unfortunately the suggestions do not work :( .
  • executionworkitem.testplan=Link(C3)
    • No failure from the tool but the testplan is not updated.
  • executionworkitem.testplan.link=C3
    • No failure from the tool but the testplan is not updated.
Do you have any other idea?
Thanks

Lionel Zocli commented May 03 '19, 10:49 a.m. | edited May 03 '19, 11:38 a.m.
Hi,
executionworkitem.testplan=Link(C3) is working !!! I made one mistake in my excel as I am generating many TCERs for a same test case in the same excel sheet..
I have now the test case (with testcase.testplan=Link(C3) ),TCERs and the TCRs in the given existing test plan.
But I can still not see the Iteration along with the TCER in my test plan. No error during the import. I am using the syntax executionworkitem.testphase.link=H3 with H3 = urn:com.ibm.rqm:testphase:R7 is my iteration.
Thanks

Your answer


Register or to post your answer.