need to set test script -type as "junit selenium" for all the test cases which i am importing .
hi
my regression suite contains 1k test cases ,so i am using rqm excel.importer,where i can feed information on test plan -test cases -test script name .in configuration file i have made the corresponding changes for other columns . To schedule and run all 1 k test scripts i need to set type as "junit selenium" and to pass few parameters like "Test class", "classpath", "java system properties " for each test case from xls .
the challenge here is i am unable to set the type as junit selenium for all test cases .
kindly help me in updating the code in configuration file which change the type as " junit selenium" while uploading for all test cases.
my configuration file
// this configuration file will create a configuration object for each one listed
configuration.XLSStartRow=2
configuration.dc:title=A
configuration.description=B & "<br/> OS:" & C & "<br/> Memory:" & D
configuration.XLSWorksheetID="Configuration"
configuration.XLSArtifactID=E
//Config for Testplan
testplan.dc:title=C1
testplan.XLSArtifactID=C1
testplan.Section("myns:com.ibm.rqm.planning.editor.section.planBusinessObjectives","RQM-KEY-TP-BUSS-OBJ-TITLE")=Div(C2)
testplan.Section("myns:com.ibm.rqm.planning.editor.section.planTestObjectives","RQM-KEY-TP-TEST-OBJ-TITLE")=Div(C3)
testplan.Section("com.ibm.rqm.planning.editor.section.planTestEnvDetails","RQM-KEY-TP-TEST-ENV-DETAIL-TITLE")=Div(C4)
testplan.XLSLink=testcase
testplan.configuration=Link(H3)
testplan.XLSWorksheetID="Testplan"
testplan.jzalm:owner="abc"
//Config for testphase
testphase.XLSWorksheetID="TestPhase"
testphase.XLSArtifactID=B1
testphase.dc:title=B2
testphase.dc:description=B3
testphase.expectedTotalPoints=B4
testphase.expectedDefects=B5
testphase.expectedValidityRate=B6
testphase.expectedStartDate=B7
testphase.expectedEndDate=B8
testphase.starttime=B9
testphase.endtime=B10
testphase.testplan=Link(B11)
// This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data
// Start looking for scripts after row 2
testscript.XLSWorksheetID="Test"
testscript.XLSStartRow=2
// use the data in the first row of a found script's column B
testscript.XLSArtifactID=C
testscript.dc:title=C
testscript.dc:description=D
// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type=x
testscript.steps.description=G
testscript.steps.title=H
testscript.steps.name=H
testscript.steps.expectedResult=L
testscript.steps.comment=N
// 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.XLSWorksheetID="Test"
testcase.XLSStartRow=2
// by referring to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
testcase.XLSArtifactID=E
testcase.Section("myns:InputData","InputData")=J
testcase.Section("myns:VerificationpointName","VerificationpointName")=F
testcase.Section("myns:ModuleName","ModuleName")=B
testcase.category term="InputData".value=J
testcase.category term="VerificationpointName".value=F
testcase.category term="ModuleName".value=B
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=D
//execution workitem
executionworkitem.XLSWorksheetID="Test"
executionworkitem.XLSStartRow=2
executionworkitem.XLSDelimeter=\n
executionworkitem.XLSArtifactID="executionworkitem_" & E
executionworkitem.dc:title=E
executionworkitem.testcase=Link(E)
executionworkitem.testplan=Link(S2)
executionworkitem.configuration=Link(T)
executionworkitem.testphase=Link(U2)
//execution result
executionresult.XLSWorksheetID="Test"
executionresult.XLSStartRow=2
executionresult.XLSDelimeter=\n
executionresult.dc:title=executionworkitem.dc:title
executionresult.er:details=G
executionresult.jzalm:state=N
executionresult.er:starttime=V2
executionresult.er:endtime=W2
executionresult.er:stepResults.steptitle=X
executionresult.er:stepResults.stepname=X
// executionresult.er:stepResults.vg:id=L
executionresult.er:stepResults.er:steptype=X
executionresult.er:stepResults.er:result=Y
executionresult.er:stepResults.er:description=G
executionresult.er:stepResults.er:expectedResult=L
executionresult.er:stepResults.er:actualResult=L
executionresult.testcase=Link(H)
executionresult.testscript=Link(E)
Accepted answer
Hi, Kesav
Junit Selenium is an automation script type hence you need to use remotescript for it.
You may want to refer to Samples Testcase with Remote Scripts 001.xls/Testcase with Remote Scripts 001.cfg for the syntax (Selenium is one type in the Sample)
I hope this helps.
2 other answers
thanks don. Could you pls give me the link from where I could download that xls... Couldn't find in the present zip file I downloaded.
Thanks for your help here.
@ Don Yang - same issue for me , i didn't find any "Remote script.xls and .cfg" in Samples folder. But remaining scripts are there. will you please share the download link for Remote scripts.
Comments
there is no such download link for the samples, they are a part of install. I remember "Testcase with Remote Scripts 001.xls/cfg" is in v5.x and 6.x ExcelImporter Samples(note the name of the files)
hi don
it will be very helpful if you can mail me the remote script cfg and sample test case xls to mail id : satheeshkumardmx@gmail.com
kindly consider i am in need of this to complete my work .
thanks in advance for you help.