It's all about the answers!

Ask a question

How to import TCER and TER from excel for existing test cases


Jorge Zingg (112) | asked Jun 14 '18, 9:08 a.m.

I have test cases in RQM for which I would like to import execution records and results from Excel. I cannot figure out how to link the excel results with the test cases in RQM, without having to use the RQM ID's. Is this possible? If not, is there a way to export the RQM ID's / titles to xls?


Comments
Jorge Zingg commented Jun 14 '18, 11:16 a.m. | edited Jun 14 '18, 11:18 a.m.

I put some more infos on the answer below, I am trying at least to get a TCER linked to one single test case...

<bold> I get this error: ExcelExportRepositoryDialog: Error saving </bold>

One answer



permanent link
Jorge Zingg (112) | answered Jun 14 '18, 11:15 a.m.

I am a bit further, I can use "LinkExisting", but still get error messages...

My cgf File:

executionworkitem.XLSStartRow=2
executionworkitem.XLSDelimeter=\n
executionworkitem.XLSArtifactID=J
executionworkitem.dc:title=C
executionworkitem.testcase=LinkExisting(K)

My ErrorLog:

6/14/2018 5:13:51 PM: ERROR: <Unknown Caller Context>: ExcelExportRepositoryDialog: Error saving to url https://bt-clmserver01.hqs.sbt.siemens.com/qm of type executionworkitem


6/14/2018 5:13:51 PM: ERROR: <Unknown Caller Context>: With description: Internal Server Error with message <?xml version="1.0" encoding="UTF-8" standalone="yes"?><ns2:Error xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns:ns1="http://schema.ibm.com/vega/2008/" xmlns:ns4="http://jazz.net/xmlns/prod/jazz/process/0.6/" xmlns:ns3="http://purl.org/dc/elements/1.1/" xmlns:ns6="http://purl.org/dc/terms/" xmlns:ns20="http://jazz.net/xmlns/alm/qm/styleinfo/v0.1/" xmlns:ns5="http://jazz.net/xmlns/alm/v0.1/" xmlns:ns8="http://jazz.net/xmlns/alm/qm/v0.1/testscript/v0.1/" xmlns:ns7="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ns13="http://www.w3.org/2002/07/owl#" xmlns:ns9="http://jazz.net/xmlns/alm/qm/v0.1/executionworkitem/v0.1" xmlns:ns12="http://jazz.net/xmlns/prod/jazz/rqm/process/1.0/" xmlns:ns11="http://open-services.net/ns/qm#" xmlns:ns10="http://open-services.net/ns/core#" xmlns:ns21="http://www.w3.org/1999/XSL/Transform" xmlns:ns17="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1" xmlns:ns16="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns15="http://jazz.net/xmlns/alm/qm/qmadapter/task/v0.1" xmlns:ns14="http://jazz.net/xmlns/alm/qm/qmadapter/v0.1" xmlns:ns18="http://jazz.net/xmlns/alm/qm/v0.1/tsl/v0.1/"><ns2:statusCode>500</ns2:statusCode><ns2:message>Internal server error</ns2:message></ns2:Error>


6/14/2018 5:13:51 PM: Server returned code: OK

6/14/2018 5:13:51 PM: Sending pooled link request for urn:com.ibm.rqm:testcase:45462

6/14/2018 5:13:51 PM: Server returned code: OK

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.