18 January 2026:


This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.



Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.

How to use for loop

gunjangunjan Members
edited November 2011 in Sahi - Open Source
Hello
My name is gunjan
Can u plz tell me how to use for loop to submit multiple claims

my script is given below


function contactInfo($fname,$lname,$daytimephone1,$daytimephone2,$email,$year,$make,$model,$submodel,$color,$bodypanel,$dent,$glass_lamps,$damage,$int_comp,$ed,$tire1,$location,$zip,$street,$vqs,$ownershiptype,$ownername,$titleinstate,$referralid)
{

_setValue(_textbox("FirstName"), $fname);
_setValue(_textbox("LastName"), $lname);
_setValue(_textbox("idCellPhone1"), $daytimephone1);
_setValue(_textbox("idCellPhone2"), $daytimephone2);
_setValue(_textbox("idMail"), $email);
_setSelected(_select("YearID"), $year);
_setSelected(_select("MakeID"), $make);
_setSelected(_select("ModelID"), $model);
_setSelected(_select("SubModelID"), $submodel);
_setSelected(_select("idcolors"), $color);
_setSelected(_select("txtQ_VC_BodyPanel"),$bodypanel );
_setSelected(_select("txtQ_VC_Dent"), $dent);
_setSelected(_select("txtQ_VC_Glass_Lamps"), $glass_lamps);
_setSelected(_select("txtQ_VC_Damage"), $damage);
_setSelected(_select("txtQ_VC_Int_comp"), $int_comp);
_setSelected(_select("txtQ_VC_ED"), $ed);
_setSelected(_select("txtQ_VC_Tire1"), $tire1);
_setSelected(_select("idLocationType"), $location);
_setValue(_textbox("Zip"), $zip);
_setValue(_textbox("Street"), $street);
_setSelected(_select("vqs"), $vqs);
_setSelected(_select("idOwnershipType"), $ownershiptype);
_setValue(_textbox("txtRRQ_OWNER_NAME"), $ownername);
_setSelected(_select("idTitleInState"), $titleinstate);
_setSelected(_select("ReferralID"),$referralid);

}
for($i=0; $i<1; $i++)
{
try
{

contactInfo();
//_click(_row(69));
_click(_checkbox("chkMailingSameAs"));
//_click(_button("Submit"));
//_wait(15000);






// Get the DB instance
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\\Test Data\\Book3.xls;readOnly=false", "", "");

$rs = db.select("select * from [Sheet1$]");

contactInfo($rs[11]["FirstName"], $rs[11]["LastName"], $rs[11]["idCellPhone1"], $rs[11]["idCellPhone2"], $rs[11]["idMail"],
""+parseInt($rs[11]["YearID"]), $rs[11]["MakeID"],$rs[11]["ModelID"],$rs[11]["SubModelID"],$rs[11]["idcolors"],$rs[11]["txtQ_VC_BodyPanel"],$rs[11]["txtQ_VC_Dent"],$rs[11]["txtQ_VC_Glass_Lamps"],$rs[11]["txtQ_VC_Damage"],$rs[11]["txtQ_VC_Int_comp"],$rs[11]["txtQ_VC_ED"],$rs[11]["txtQ_VC_Tire1"],$rs[11]["idLocationType"],""+parseInt($rs[11]["Zip"]),$rs[11]["Street"],$rs[11]["vqs"],$rs[11]["idOwnershipType"],$rs[11]["txtRRQ_OWNER_NAME"],$rs[11]["idTitleInState"],$rs[11]["ReferralID"]);


_click(_button("Submit"));
_wait(15000);




}

catch(e)
{
//_logException(e);
}




try
{
contactInfo();
//_click(_row(69));
_click(_checkbox("chkMailingSameAs"));
//_click(_button("Submit"));
//_wait(15000);

// Get the DB instance
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\\Test Data\\Book3.xls;readOnly=false", "", "");

$rs = db.select("select * from [Sheet1$]");

contactInfo($rs[12]["FirstName"], $rs[12]["LastName"], $rs[12]["idCellPhone1"], $rs[12]["idCellPhone2"], $rs[12]["idMail"],
""+parseInt($rs[12]["YearID"]), $rs[12]["MakeID"],$rs[12]["ModelID"],$rs[12]["SubModelID"],$rs[12]["idcolors"],$rs[12]["txtQ_VC_BodyPanel"],$rs[12]["txtQ_VC_Dent"],$rs[12]["txtQ_VC_Glass_Lamps"],$rs[12]["txtQ_VC_Damage"],$rs[12]["txtQ_VC_Int_comp"],$rs[12]["txtQ_VC_ED"],$rs[12]["txtQ_VC_Tire1"],$rs[12]["idLocationType"],""+parseInt($rs[12]["Zip"]),$rs[12]["Street"],$rs[12]["vqs"],$rs[12]["idOwnershipType"],$rs[12]["txtRRQ_OWNER_NAME"],$rs[12]["idTitleInState"],$rs[12]["ReferralID"]);

_click(_button("Submit"));
_wait(15000);

}

catch(e)
{
_logException(e);
}

}
_click(_link("Logout"));


My excel sheet is also given below:

No. FirstName LastName idCellPhone1 idCellPhone2 idMail YearID MakeID
11 reena roy 433 7865436 r@r.com 2001 Audi
12 pooja sen 578 9876543 P@s.com 2007 BMW

No. ModelID SubModelID idcolors txtQ_VC_BodyPanel txtQ_VC_Dent
11 A4 3.0 Black Yes Yes
12 3 Series 328i Blue Yes Yes


No. txtQ_VC_Glass_Lamps txtQ_VC_Damage txtQ_VC_Int_comp txtQ_VC_ED
11 Yes No Yes Yes
12 Yes No Yes Yes

No. txtQ_VC_ES txtQ_VC_ET1 txtQ_VC_Tire1 txtQ_VC_Tire2 idLocationType
11 Yes Residence
12 Yes Residence

No. Zip Street vqs idOwnershipType txtRRQ_OWNER_NAME
11 78727 india Front yard Documented heer
12 10010 test Back yard Documented heena


No. idTitleInState ReferralID
11 CO - Select affiliate -
12 FL - Select affiliate -







My log entry is given below:
Starting script
_setValue(_textbox("FirstName"), null); at Nov 1, 2011 11:59:19 AM
_setValue(_textbox("LastName"), null); at Nov 1, 2011 11:59:19 AM
_setValue(_textbox("idCellPhone1"), null); at Nov 1, 2011 11:59:20 AM
_setValue(_textbox("idCellPhone2"), null); at Nov 1, 2011 11:59:20 AM
_setValue(_textbox("idMail"), null); at Nov 1, 2011 11:59:20 AM
_setSelected(_select("YearID"), null); at Nov 1, 2011 11:59:20 AM
_setSelected(_select("MakeID"), null); at Nov 1, 2011 11:59:20 AM
_setSelected(_select("ModelID"), null); at Nov 1, 2011 11:59:20 AM
_setSelected(_select("SubModelID"), null); at Nov 1, 2011 11:59:20 AM
_setSelected(_select("idcolors"), null); at Nov 1, 2011 11:59:20 AM
_setSelected(_select("txtQ_VC_BodyPanel"),null ); at Nov 1, 2011 11:59:21 AM
_setSelected(_select("txtQ_VC_Dent"), null); at Nov 1, 2011 11:59:21 AM
_setSelected(_select("txtQ_VC_Glass_Lamps"), null); at Nov 1, 2011 11:59:21 AM
_setSelected(_select("txtQ_VC_Damage"), null); at Nov 1, 2011 11:59:21 AM
_setSelected(_select("txtQ_VC_Int_comp"), null); at Nov 1, 2011 11:59:21 AM
_setSelected(_select("txtQ_VC_ED"), null); at Nov 1, 2011 11:59:21 AM
_setSelected(_select("txtQ_VC_Tire1"), null); at Nov 1, 2011 11:59:21 AM
_setSelected(_select("idLocationType"), null); at Nov 1, 2011 11:59:21 AM
_setValue(_textbox("Zip"), null); at Nov 1, 2011 11:59:22 AM
_setValue(_textbox("Street"), null); at Nov 1, 2011 11:59:22 AM
_setSelected(_select("vqs"), null); at Nov 1, 2011 11:59:22 AM
_setSelected(_select("idOwnershipType"), null); at Nov 1, 2011 11:59:22 AM
_setValue(_textbox("txtRRQ_OWNER_NAME"), null); at Nov 1, 2011 11:59:22 AM
_setSelected(_select("idTitleInState"), null); at Nov 1, 2011 11:59:22 AM
_setSelected(_select("ReferralID"),null); at Nov 1, 2011 11:59:22 AM
_click(_checkbox("chkMailingSameAs")); at Nov 1, 2011 11:59:22 AM
_setValue(_textbox("FirstName"), "nish"); at Nov 1, 2011 11:59:23 AM
_setValue(_textbox("LastName"), "dadhania"); at Nov 1, 2011 11:59:23 AM
_setValue(_textbox("idCellPhone1"), "655.0"); at Nov 1, 2011 11:59:23 AM
_setValue(_textbox("idCellPhone2"), "1570564.0"); at Nov 1, 2011 11:59:23 AM
_setValue(_textbox("idMail"), "nisha@d.com"); at Nov 1, 2011 11:59:23 AM
_setSelected(_select("YearID"), "2005"); at Nov 1, 2011 11:59:23 AM
_setSelected(_select("MakeID"), "Honda"); at Nov 1, 2011 11:59:23 AM
_setSelected(_select("ModelID"), "Civic"); at Nov 1, 2011 11:59:23 AM
_setSelected(_select("SubModelID"), "EX"); at Nov 1, 2011 11:59:24 AM
_setSelected(_select("idcolors"), "Red"); at Nov 1, 2011 11:59:24 AM
_setSelected(_select("txtQ_VC_BodyPanel"),"Yes" ); at Nov 1, 2011 11:59:24 AM
_setSelected(_select("txtQ_VC_Dent"), "Yes"); at Nov 1, 2011 11:59:24 AM
_setSelected(_select("txtQ_VC_Glass_Lamps"), "Yes"); at Nov 1, 2011 11:59:24 AM
_setSelected(_select("txtQ_VC_Damage"), "No"); at Nov 1, 2011 11:59:24 AM
_setSelected(_select("txtQ_VC_Int_comp"), "Yes"); at Nov 1, 2011 11:59:24 AM
_setSelected(_select("txtQ_VC_ED"), "Yes"); at Nov 1, 2011 11:59:25 AM
_setSelected(_select("txtQ_VC_Tire1"), "Yes"); at Nov 1, 2011 11:59:25 AM
_setSelected(_select("idLocationType"), "Residence"); at Nov 1, 2011 11:59:25 AM
_setValue(_textbox("Zip"), "10001"); at Nov 1, 2011 11:59:25 AM
_setValue(_textbox("Street"), "tyt"); at Nov 1, 2011 11:59:25 AM
_setSelected(_select("vqs"), "Street"); at Nov 1, 2011 11:59:25 AM
_setSelected(_select("idOwnershipType"), "Documented"); at Nov 1, 2011 11:59:25 AM
_setValue(_textbox("txtRRQ_OWNER_NAME"), "heena"); at Nov 1, 2011 11:59:26 AM
_setSelected(_select("idTitleInState"), "FL"); at Nov 1, 2011 11:59:26 AM
_setSelected(_select("ReferralID"),"- Select affiliate -"); at Nov 1, 2011 11:59:26 AM
_click(_button("Submit")); at Nov 1, 2011 11:59:26 AM
_wait(15000); at Nov 1, 2011 11:59:41 AM
undefined: unterminated string literal (http://192.168.1.4/admin/admin_viewrequest.asp?claimid=154115:1)
No trace available
Click for browser script at Nov 1, 2011 11:59:54 AM
_setValue(_textbox("FirstName"), null); at Nov 1, 2011 11:59:54 AM
_setValue(_textbox("LastName"), null); at Nov 1, 2011 11:59:54 AM
_setValue(_textbox("idCellPhone1"), null); at Nov 1, 2011 11:59:57 AM
_setValue(_textbox("idCellPhone2"), null); at Nov 1, 2011 11:59:57 AM
_setValue(_textbox("idMail"), null); at Nov 1, 2011 11:59:57 AM
_setSelected(_select("YearID"), null); at Nov 1, 2011 11:59:57 AM
_setSelected(_select("MakeID"), null); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("ModelID"), null); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("SubModelID"), null); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("idcolors"), null); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("txtQ_VC_BodyPanel"),null ); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("txtQ_VC_Dent"), null); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("txtQ_VC_Glass_Lamps"), null); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("txtQ_VC_Damage"), null); at Nov 1, 2011 11:59:58 AM
_setSelected(_select("txtQ_VC_Int_comp"), null); at Nov 1, 2011 11:59:59 AM
_setSelected(_select("txtQ_VC_ED"), null); at Nov 1, 2011 11:59:59 AM
_setSelected(_select("txtQ_VC_Tire1"), null); at Nov 1, 2011 11:59:59 AM
_setSelected(_select("idLocationType"), null); at Nov 1, 2011 11:59:59 AM
_setValue(_textbox("Zip"), null); at Nov 1, 2011 11:59:59 AM
_setValue(_textbox("Street"), null); at Nov 1, 2011 11:59:59 AM
_setSelected(_select("vqs"), null); at Nov 1, 2011 11:59:59 AM
_setSelected(_select("idOwnershipType"), null); at Nov 1, 2011 11:59:59 AM
_setValue(_textbox("txtRRQ_OWNER_NAME"), null); at Nov 1, 2011 12:00:00 PM
_setSelected(_select("idTitleInState"), null); at Nov 1, 2011 12:00:00 PM
_setSelected(_select("ReferralID"),null); at Nov 1, 2011 12:00:00 PM
_click(_checkbox("chkMailingSameAs")); at Nov 1, 2011 12:00:00 PM
_setValue(_textbox("FirstName"), "Shushmita"); at Nov 1, 2011 12:00:00 PM
_setValue(_textbox("LastName"), "sen"); at Nov 1, 2011 12:00:00 PM
_setValue(_textbox("idCellPhone1"), "678.0"); at Nov 1, 2011 12:00:00 PM
_setValue(_textbox("idCellPhone2"), "4579321.0"); at Nov 1, 2011 12:00:01 PM
_setValue(_textbox("idMail"), "shush@s.com"); at Nov 1, 2011 12:00:01 PM
_setSelected(_select("YearID"), "1988"); at Nov 1, 2011 12:00:01 PM
_setSelected(_select("MakeID"), "Dodge"); at Nov 1, 2011 12:00:01 PM
_setSelected(_select("ModelID"), "Dakota"); at Nov 1, 2011 12:00:01 PM
_setSelected(_select("SubModelID"), "Base"); at Nov 1, 2011 12:00:01 PM
_setSelected(_select("idcolors"), "Purple"); at Nov 1, 2011 12:00:01 PM
_setSelected(_select("txtQ_VC_BodyPanel"),"Yes" ); at Nov 1, 2011 12:00:02 PM
_setSelected(_select("txtQ_VC_Dent"), "Yes"); at Nov 1, 2011 12:00:02 PM
_setSelected(_select("txtQ_VC_Glass_Lamps"), "Yes"); at Nov 1, 2011 12:00:02 PM
_setSelected(_select("txtQ_VC_Damage"), "No"); at Nov 1, 2011 12:00:02 PM
_setSelected(_select("txtQ_VC_Int_comp"), "Yes"); at Nov 1, 2011 12:00:02 PM
_setSelected(_select("txtQ_VC_ED"), "Yes"); at Nov 1, 2011 12:00:02 PM
_setSelected(_select("txtQ_VC_Tire1"), "Yes"); at Nov 1, 2011 12:00:02 PM
_setSelected(_select("idLocationType"), "Residence"); at Nov 1, 2011 12:00:03 PM
_setValue(_textbox("Zip"), "45454"); at Nov 1, 2011 12:00:03 PM
_setValue(_textbox("Street"), "rtr"); at Nov 1, 2011 12:00:03 PM
_setSelected(_select("vqs"), "Garage"); at Nov 1, 2011 12:00:03 PM
_setSelected(_select("idOwnershipType"), "Documented"); at Nov 1, 2011 12:00:03 PM
_setValue(_textbox("txtRRQ_OWNER_NAME"), "poonam"); at Nov 1, 2011 12:00:03 PM
_setSelected(_select("idTitleInState"), "TX"); at Nov 1, 2011 12:00:03 PM
_setSelected(_select("ReferralID"),"- Select affiliate -"); at Nov 1, 2011 12:00:03 PM
_click(_button("Submit")); at Nov 1, 2011 12:00:04 PM
_wait(15000); at Nov 1, 2011 12:00:19 PM
undefined: unterminated string literal (http://192.168.1.4/admin/admin_viewrequest.asp?claimid=154116:1)
No trace available
Click for browser script at Nov 1, 2011 12:00:30 PM
_click(_link("Logout")); at Nov 1, 2011 12:00:30 PM
Stopping script




In this condition
first it takes null value than it takes table value again takes null value and again takes table value

Can u plz help how to solve this problem?

I am using os: windows 7, Sahi : V3.5, Fire fox version 5
I want to capture data from excel sheet and send it on browser


Thanks,
Gunjan.

Comments

  • TheeranTheeran Members
    Hi gunjan,

    Try the following script,
    function contactInfo($fname,$lname,$daytimephone1,$daytimephone2,$email,$year,$make,$model,$submodel,$color,$bodypanel,$dent,$glass_lamps,$damage,$int_comp,$ed,$tire1,$location,$zip,$street,$vqs,$ownershiptype,$ownername,$titleinstate,$referralid)
{
_setValue(_textbox("FirstName"), $fname);
_setValue(_textbox("LastName"), $lname);
_setValue(_textbox("idCellPhone1"), $daytimephone1);
_setValue(_textbox("idCellPhone2"), $daytimephone2);
_setValue(_textbox("idMail"), $email);
_setSelected(_select("YearID"), $year);
_setSelected(_select("MakeID"), $make);
_setSelected(_select("ModelID"), $model);
_setSelected(_select("SubModelID"), $submodel);
_setSelected(_select("idcolors"), $color);
_setSelected(_select("txtQ_VC_BodyPanel"),$bodypanel );
_setSelected(_select("txtQ_VC_Dent"), $dent);
_setSelected(_select("txtQ_VC_Glass_Lamps"), $glass_lamps);
_setSelected(_select("txtQ_VC_Damage"), $damage);
_setSelected(_select("txtQ_VC_Int_comp"), $int_comp);
_setSelected(_select("txtQ_VC_ED"), $ed);
_setSelected(_select("txtQ_VC_Tire1"), $tire1);
_setSelected(_select("idLocationType"), $location);
_setValue(_textbox("Zip"), $zip);
_setValue(_textbox("Street"), $street);
_setSelected(_select("vqs"), $vqs);
_setSelected(_select("idOwnershipType"), $ownershiptype);
_setValue(_textbox("txtRRQ_OWNER_NAME"), $ownername);
_setSelected(_select("idTitleInState"), $titleinstate);
_setSelected(_select("ReferralID"),$referralid);
}
try{
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\\Test Data\\Book3.xls;readOnly=false", "", "");
$rs = db.select("select * from [Sheet1$]");
for(var $i=0;$i<$rs.length;$i++){
contactInfo($rs[$i]["FirstName"], $rs[$i]["LastName"], $rs[$i]["idCellPhone1"], $rs[$i]["idCellPhone2"], $rs[$i]["idMail"], 
""+parseInt($rs[$i]["YearID"]), $rs[$i]["MakeID"],$rs[$i]["ModelID"],$rs[$i]["SubModelID"],$rs[$i]["idcolors"],$rs[$i]["txtQ_VC_BodyPanel"],$rs[$i]["txtQ_VC_Dent"],$rs[$i]["txtQ_VC_Glass_Lamps"],$rs[$i]["txtQ_VC_Damage"],$rs[$i]["txtQ_VC_Int_comp"],$rs[$i]["txtQ_VC_ED"],$rs[$i]["txtQ_VC_Tire1"],$rs[$i]["idLocationType"],""+parseInt($rs[$i]["Zip"]),$rs[$i]["Street"],$rs[$i]["vqs"],$rs[$i]["idOwnershipType"],$rs[$i]["txtRRQ_OWNER_NAME"],$rs[$i]["idTitleInState"],$rs[$i]["ReferralID"]);
}
_click(_button("Submit"));
_wait(15000,_exists(element));
}
catch(e)
        {
            //_logException(e);
        }

    The element in the wait API,is the result element that appear on the result window.
    Use the code tags to give script.

    Regards
    Theeran.
  • gunjangunjan Members
    Thank u so much it really works nice thank once again
This discussion has been closed.