It's all about the answers!

Ask a question

need to set test script -type as "junit selenium" for all the test cases which i am importing .


kesav d (19115) | asked Jul 12 '17, 2:44 a.m.

 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


permanent link
Don Yang (7.7k21109138) | answered Jul 12 '17, 9:35 p.m.
edited Jul 12 '17, 9:35 p.m.

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.

kesav d selected this answer as the correct answer

2 other answers



permanent link
kesav d (19115) | answered Jul 13 '17, 12:07 a.m.

 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.


Comments
Don Yang commented Jul 13 '17, 12:17 a.m.

In your ExcelImporter install directory, you should be able to find a folder 'Samples' in which the samples are all there.


permanent link
satheesh kumar p (112) | answered Jul 13 '17, 1:31 a.m.
edited Jul 13 '17, 1:35 a.m.

 @ 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
Don Yang commented Jul 13 '17, 1:54 a.m. | edited Jul 13 '17, 1:55 a.m.

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)


satheesh kumar p commented Jul 14 '17, 2:35 a.m.

 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.

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.