It's all about the answers!

Ask a question

Want to overwrite existing test cases added earlier


Deepak Sharma (158) | asked Feb 21 '17, 2:07 a.m.

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


permanent link
Mehul Patel (9545) | answered Feb 22 '17, 7:45 a.m.
FORUM MODERATOR

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
Deepak Sharma commented Feb 23 '17, 1:31 a.m.

 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.


Mehul Patel commented Feb 23 '17, 2:12 a.m.
FORUM MODERATOR

Deepak, 


It should work, could you check log if it captured more details related to failure?

Regards,
Mehul


Deepak Sharma commented Feb 23 '17, 3:05 a.m.

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)


Deepak Sharma commented Feb 23 '17, 3:06 a.m. | edited Feb 23 '17, 3:07 a.m.

 

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 : 




Continuing log to other answer as below........

One other answer



permanent link
Deepak Sharma (158) | answered Feb 23 '17, 3:06 a.m.
edited Feb 23 '17, 3:07 a.m.

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


Register or to post your answer.