It's all about the answers!

Ask a question

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


Jorge Zingg (111) | 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 (111) | 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.