Want to overwrite existing test cases added earlier
I had difficultly in overwriting existing test cases/test scripts which were added earlier manually in RQM. I want to edit catagories, test steps etc.. in RQM test cases but whenever I'm importing using RQMExcelImporter tool then I doesnot overwrites test cases if those were added to RQM manually.
Please help explain a way to overwrite Test cases, Test script etc..
I'm using following cfg file. Kindly suggest changes required in this..
//Start looking for scripts after row 5
testscript.XLSStartRow=5
// use the data in the first row of a found script's column B
testscript.XLSArtifactID=L
testscript.dc:title=L
testscript.dc:description=M
testscript.alm:owner=B
//testscript.jzalm:state="Ready for review"
// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type=N
testscript.steps.description=P & " " & image(P)
testscript.steps.title=O
testscript.steps.name=O
testscript.steps.expectedResult=Q & " " & image(Q)
testscript.steps.comment=R
testscript.category term="Test Script Review Status".value=V
// a new script starts when we encounter an empty row
//testscript.XLSDelimeter=\n
// we want to use the data we got for each test script to create a test case
testcase.XLSStartRow=5
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=F
testcase.dc:description=H
//testcase.jzalm:state="Ready to Run"
testcase.weight=A
testcase.estimate=AJ
testcase.priority=G
testcase.alm:owner=B
//testcase.category term=" Product Catalog".value=AL
testcase.category term="Release".value=U
testcase.category term="Features Tested".value=W
testcase.category term="Execution Type".value=I
testcase.category term="Test Type".value=Y
testcase.category term="When to Run".value=AA
testcase.Section("com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=J
testcase.Section("com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=K
testcase.attachment=S
testsuite.XLSStartRow=5
//testsuite.XLSArtifactID=E
//testsuite.ID=testcase.XLSArtifactID
testsuite.dc:title=E
testsuite.dc:description=E
testsuite.alm:owner=B
testsuite.estimate=AK
testsuite.priority=AC
testsuite.XLSArtifactID=E
testsuite.attachment=AO
testsuite.XLSLink=testcase
|
Accepted answer
Deepak,
While creating test artifact manually using web UI, RQM uses ID in the format of "urn:com.ibm.rqm: <resource type>: (internal ID)" i.e. urn:com.ibm.rqm:testplan:2.
RQMWordExcel configuration file uses syntax 'XLSArtifactID' to specify the external ID of the artifact. If this external ID of the artifact exists then it will update the artifact otherwise it will create the new artifact.
In given example above, please check the column which specifies XLSArtifactID, You need to specify these IDs as per the one available in your repository then it will update it else will create new one.
Hope this helps.
Regards,
Mehul
Deepak Sharma selected this answer as the correct answer
Comments Thanks Mehul for the answer.
It worked for me for test cases but not for test scripts somehow.
I used
Then i get error as Bad Request.
Deepak,
It should work, could you check log if it captured more details related to failure?
Regards,
Mehul
Hi Mehul,
Still having trouble with test script overwrite thing. Below is my cfg file
testscript.XLSStartRow=5
testscript.XLSArtifactID=K2
testscript.dc:title=L
testscript.dc:description=M
testscript.steps.description=P & " " & image(P)
And this is log file generated.
2/23/2017 3:57:38 PM:
SESSION: 2/23/2017 3:57:38 PM
2/23/2017 3:57:38 PM: Getting artifacts from current document RQMTemplate_21Feb.xlsm
2/23/2017 3:57:38 PM: WARNING: <Unknown Caller Context>: Test script step1 was not found! Skipping attachment.
2/23/2017 3:57:38 PM: Created 1 artifacts, sending to server
2/23/2017 3:57:38 PM: INFO: <Unknown Caller Context>: ExportRepositoryDialog.reqUrl :
2/23/2017 3:57:38 PM: sending testscript0 named https://<....RQM...>/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<....Project....>/testscript/urn:com.ibm.rqm:testscript:88097
Continuing log to other answer as below........
|
One other answer
|
Continuing log from previous.......
2/23/2017 3:57:40 PM: ERROR: <Unknown Caller Context>: RQMConnector: PutToServer - Error putting resource: https://<....RQM...>/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<....Project....>/testscript/https%3A%2F%2Frqmclm.rockwellautomation.com%2Fqm%2Fservice%2Fcom.ibm.rqm.integration.service.IIntegrationService%2Fresources%2<....Project....>%2Ftestscript%2Furn%3Acom.ibm.rqm%3Atestscript%3A88097
2/23/2017 3:57:40 PM: ERROR: <Unknown Caller Context>: The remote server returned an error: (500) Internal Server Error.
2/23/2017 3:57:40 PM: EXCEPTION: : The remote server returned an error: (500) Internal Server Error.
2/23/2017 3:57:40 PM: at System.Net.HttpWebRequest.GetResponse()
at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)
2/23/2017 3:57:40 PM: ERROR: <Unknown Caller Context>: Error 500: Internal Server Error
2/23/2017 3:57:40 PM: Server returned code InternalServerError
2/23/2017 3:57:40 PM: Error sending to server https://<....RQM...>/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<....Project....>/testscript/urn:com.ibm.rqm:testscript:88097 of type testscript
2/23/2017 3:57:40 PM: Internal Server Error
2/23/2017 3:57:40 PM: ERROR: <Unknown Caller Context>: ExcelExportRepositoryDialog: Error saving to url https://<....RQM...> of type testscript
2/23/2017 3:57:40 PM: ERROR: <Unknown Caller Context>: With description: Internal Server Error with message Error 500: Internal Server Error
2/23/2017 3:57:40 PM: finished writing artifacts
|
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.