Hi,
My name is Gunjan.
i am using windows 7 sahi V 3.5 and fire fox 5

in my case
when i enter claim id and click on load button the necessary information like
year,make, model,sub model,zip,city,state,county are automatically fill up

and after click on load button when i click in calculate button result should display proper output.

And i want to capture data from excel sheet and send it in browser.

But when i fill up the claim id textbox and click on load button it should not display automatic information

my script is given below

function asvcalc ($claimid)
{
_popup("JunkMyCar")._setValue(_textbox("txtClaimId"), $claimid);
_wait(15000,_exists(elememt));
_popup("JunkMyCar")._click(_submit("Load"));
_wait(35000,_exists(elememt));
_popup("JunkMyCar")._click(_submit("Calculate"));
_popup("JunkMyCar")._assertExists(_select("cboMake"));
_popup("JunkMyCar")._assert(_isVisible(_select("cboMake")));
_popup("JunkMyCar")._assertEqual("txtClaimId ", _getSelectedText(_select("cboMake")));
_popup("JunkMyCar")._click(_submit("Load"));
_popup("JunkMyCar")._click(_submit("Calculate"));


}
// 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\\Book7.xls;readOnly=false", "", "");

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

for(var $i=0; $i<$rs.length; $i++)
{
asvcalc($rs[$i]["txtClaimId"]);
}
// _wait(10000,_exists(elememt));

my excel sheet is given below

txtClaimId
1008891
1008892
1008893
1008894

and error message is given below

Starting script
_popup("JunkMyCar")._setValue(_textbox("txtClaimId"), "1008891.0"); at Nov 4, 2011 10:49:20 AM
_wait(15000, "_exists(elememt)"); at Nov 4, 2011 10:49:35 AM
_popup("JunkMyCar")._click(_submit("Load")); at Nov 4, 2011 10:49:35 AM
_wait(35000, "_exists(elememt)"); at Nov 4, 2011 10:50:10 AM
_popup("JunkMyCar")._click(_submit("Calculate")); at Nov 4, 2011 10:50:10 AM
_popup("JunkMyCar")._assertExists(_select("cboMake")); at Nov 4, 2011 10:50:10 AM
_popup("JunkMyCar")._assert(_isVisible(_select("cboMake"))); at Nov 4, 2011 10:50:10 AM
_popup("JunkMyCar")._assertEqual("txtClaimId ", _getSelectedText(_select("cboMake")));
Assertion Failed.
Expected:[txtClaimId ]
Actual:
at asvcalc (scripts/asv.sah:10) at Nov 4, 2011 10:50:20 AM
_popup("JunkMyCar")._click(_submit("Load")); at Nov 4, 2011 10:50:22 AM
_popup("JunkMyCar")._click(_submit("Calculate")); at Nov 4, 2011 10:50:22 AM
_popup("JunkMyCar")._click(_submit("Load")); at Nov 4, 2011 10:50:23 AM
_popup("JunkMyCar")._click(_submit("Calculate")); at Nov 4, 2011 10:50:23 AM
_popup("JunkMyCar")._click(_submit("Load")); at Nov 4, 2011 10:50:23 AM
_popup("JunkMyCar")._click(_submit("Calculate")); at Nov 4, 2011 10:50:23 AM
Stopping script



Can u plz help me how to solve this problem?


Thanks,
Gunjan.