you need to include the library to use the ajax Request object, also the $('id') is the same as writing document.getElementById('id')
the whole idea of the mootools library is to make things simplier.  it is called a wrapper library

You are right with your comments about the update_div function. it is NOTHING to do with mootools and is just javascript code for the new request.

mootools also provides some very good fade in / out effects, which i use to prevent the "flashing' that happens normally when things reload.

What i will do is provide a webpage that will load 5 excel files, one at a time after 5 seconds and have them fade in when they load

Could you send other two files to me that you said it is  working correctly
and no problem to you. Just example for demo and testing

But why you mention i need to include the library  ?


<script type='text/javascript' src="https://ajax.googleapis.com/ajax/libs/mootools/1.3.0/mootools-yui-compressed.js"></script>
<script>

The Excel is not too big, you can create simple row and col data
and plot simple chart and saveas htm in Excel that will create
a folder to store all sheet and image from chart

So your function, updata_div si nothing to mootools

that is just javascript code for new Request , RIght ?

to answer your questions:


This is my function, nothing to do with mootools. it is in the header of the html file

i've attached the loading image.

all of what i've provided works for me quite well.  i'd say it has something to do with your setup.

How large will the excel file be?

The new refresh is not wokring both Firefox and IE, I never
see any refresh  since last three days.

Could we use back  this as follows ?
window.setInterval("refreshPage()", 120000); //refresh every 10 sec
 function refreshPage()
{
window.location.reload(true);
}

Anyway, could you give me your complete three file

1-Image anminated file
2- file in URL in update_div such as test.html
3- your javascript /html for all togother including refresh,, item-1 and item-2

Otherwise, a piece code and not completed code will create a lot of issue or bug.

Could you provide update_div function in mootools document,
how it specifiy the syntax for update_div , there is no reason
that is such unstable, just one case working means for all case working

also note that the progress is not supported in IE so in that instance you could use a loading animated gif

sorry i don't understand your last comment... are you saying that mootools has many bugs?

Please don't trust over much in the website provided you library of javascript there is
a lot bug for people helping to debug

After I test it, some html can load with the image and some is not and giving blank wbepage.
SOmetimes some html load is better in Firefox but some html is same as IE not working at.

Above just say for the first time click only.

And it never doing rehresh for both firefox and IE, it seems the library is not stable at all
 and the code your provide  for refresh that is never worked ,window.addEvent('domready', function() {
update_div.periodical(30000); // 2 min
} )

Probably, please give me your  image file and html loading file , so I can test it
and what browser are you using.

Anyway, we might report to mootools ther is a bug, just one case is working is also not working

Duncan

Here I have a better test for you:

Please click here and save this as test.txt -> https://www.yousendit.com/download/dklvc2ZObTg5bEJjR0E9PQ

I've attached a new html file.  this should indicate better than a loading image as it will show the % progress of the file being loaded.

let me know how it goes

yes that's right you don't need the http://www...

it might be not neccessary to specify
'http://www.mywebsie.com/test.html' with "http:www.."
just '/test.html' will be better since I am trying other ajax code
it run if without "http://www.."

I don't see any 2 min refresh running , please advise

When I delete .send(), the image is coming back and appear but no date alert box.
When I add back .send(),  data alert box is coming back  but no image of water.jpg come out

The target we want to see the alert date box and after 2 minutes, the image will comes out until
I close the alert date box, Right ?

it works half,
now the date dialog alert box is shown out with time and date when I click sbmit
but the image.jpg is not shown up and it is loading and
IE message is reporting  "now loading the image http://www.mywebsite.com/water.jpg "
and IE window is waitng . I already add .send()  from your code.


Please advise

Duncan

html><script type='text/javascript' src="https://ajax.googleapis.com/ajax/libs/mootools/1.3.0/mootools-yui-compressed.js"></script><script>function update_div() {    // change the text in the div to an animated gif such as a loading circle  $('test').innerHTML = "<img src='http://www.mywbesite.com/water.jpg' alt='loading...' />";  var myRequest = new Request.HTML({       url: 'http://www.mywebsie.com/test.html',       method: 'get',       update: $('test')	   }).send();}Window.addEvent('domready', function() {update_div.periodical(30000); // 2 min} )</script><body><input type='button' onclick='update_div();' value='click me' /><div id='test'>loading</div></body></html>                                          

1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:25:26:27:28:29:30:

ok it works for me...  it won't work if you just double click the html file.  you need to be running it on the server

eg. this won't work

file:///C:/inetpub/wwwroot/screen_update/index.html

BUT this will (assuming you have IIS installed locally)

http://localhost/screen_update/index.html

I tested it, and javascript error, the error at

 <script type='text/javascript'>
      alert(new Date().toString());
</script>

Anyway, please test it at your side first , and have a good and time to sleep for last 15 minutes

Duncan

Okay , I am still not sleeping but I will try as final one today

That is why I like you but it is really  tired.
Programming means exhausted to people but sometims it is a fun


Anyway, Hava a good day ,see you tomorrow.

Duncan

that's right, if it's not in the same domain it won't work.  Always busy (at work) but I'll help you till we get this working ok?

Time to sleep and I will sleep half hour and go to my work at 4:45PM at your time ,see you tomrrow

I see you reply through EE mobile, are you busy  or in a car ?
Why not go home and reply me that will be efficient

What you mean  same domain, if not in same domain doesn't work

So the URL is just working for php file not common webiste ?

why suddenly, it will have test.php ?

I will try it and won't disappoint you again

Yes, it is going to be on the same server.

At this moment, forget the excel first, I want to
test your code first. So please give me simple example
for update div. And send me your eaxmple  file if possible to
verify the mootools is good

Please advise

Duncan

That won't work (without a lot of stuffing around) because it is an across domain call and a potential security risk.

is the excel file going to be on the same server as your webpage?

I add it  and change URL as www.yahoo.com for simpfliy process , the image is coming  out ,"water.jpg" but  the www.yahoo.com webpage is not shown up and reload is not activated

Could you send me your working me code for testing at my side ?

<html>

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/mootools/1.3.0/mootools-yui-compressed.js"></script>

<script>
function update_div() {
   // change the text in the div to an animated gif such as a loading circle
  $('test').innerHTML = "<img src='file:///D:/image/water.jpg' alt='loading...' />";
  var myRequest = new Request.HTML({
     url: "http://www.yahoo.com",
     method: 'get',
      update: $('test')
   });
}
Window.addEvent('domready', function() {
update_div.periodical(5000); // 2 min
} )

</script>

<body>
<input type='button' onclick='update_div();' value='click me' />

<div id="test">loading</div>
</body>
</html>

Dear taquit

now I understood what you are doing, at thismoment  forget Excel sheet first, so
I edit new html, test.html  and put  your code first update_div for testing
both example.html and water.jpg is at the same  directory at D:workdir  with  test.html
After I click 'click me' button there is no any response at all even loading example.html, jusk blank webpage
with showing only "loading" from (div> tag and click button"
THere is no any javascript error report.Could you run it at your side? I also try it  both  fail in  IE and Firefox

Do you think there is wrong with $('test), and should be replaced by document.getElementById("test") ?

If that is passed, I think it also work for exel.htm files

Please advise
Duncan

*******test.html for update_div()*****************<html><script type='text/javascript'>function update_div() {    // change the text in the div to an animated gif such as a loading circle  $('test').innerHTML = "<img src='water.jpg' alt='loading...' />";  var myRequest = new Request.HTML({       url: 'example.html',       method: 'get',       update: $('test')    });}Window.addEvent('domready', function() {update_div.periodical(5000); // 2 min} )</script><body><input type='button' onclick='update_div' value='click me' /><div id='test'>loading</div></body></html>                                          

1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:

Yes, this  the link I want to reload
document.all.item("shLink")[g_iSh].href

Please advise

Duncan

Yes it is already in Excel sheet htm format,  As we know there is a lot sheet in Excel file and
you also see it in web hen you save the file in htm format,and i put "shlink" to let window.frames["frSheet"].location.reload(true) to recognize the sheet  and refresh excel sheet I select and I am veiwing at .
Otherwise, it will refresh and go back to the begining sheet(like sheet001) regardless which sheet you
are looking at
 

is this the link you want to reload?
document.all.item("shLink")[g_iSh].href

i notice you are still using the frameset, this isn't required

I added your code to replace my refresh fuction  and it failed

<html>
<head>
....
<script type='text/javascript'>
function update_div() {
    // change the text in the div to an animated gif such as a loading circle
    $('test').innerHTML = "<img src='loading.gif' alt='loading...' />";
    var myRequest = new Request.HTML({
        url: 'my_excel_file.htm',
        method: 'get',
        update: $('test')
    });
}
Window.addEvent('domready', function() {
    update_div.periodical(120000); // 2 min
}
</script>
</head>
<body>
<div id='test'>loading...</div>


<script language="JavaScript">
 var g_iSh = 0;


var c_lTabs=21;

 var c_rgszSh=new Array(c_lTabs);
 c_rgszSh[0] = "Data";
 c_rgszSh[1] = "IntraHS";
 c_rgszSh[2] = "DailyHS";
 c_rgszSh[3] = "Intra5";
 c_rgszSh[4] = "Daily5";
 c_rgszSh[5] = "Intra13";
 c_rgszSh[6] = "Daily13";
 c_rgszSh[7] = "Intra16";
 c_rgszSh[8] = "Daily16";
 c_rgszSh[9] = "Intra388";
 c_rgszSh[10] = "Daily388";
 c_rgszSh[11] = "Intra939";
 c_rgszSh[12] = "Daily939";
 c_rgszSh[13] = "Intra857";
 c_rgszSh[14] = "Daily857";
 c_rgszSh[15] = "Intra1088";
 c_rgszSh[16] = "Daily1088";
 c_rgszSh[17] = "Intra2628";
 c_rgszSh[18] = "Daily2628";
 c_rgszSh[19] = "Intra981";
 c_rgszSh[20] = "Daily981";



 var c_rgszClr=new Array(8);
 c_rgszClr[0]="window";
 c_rgszClr[1]="buttonface";
 c_rgszClr[2]="windowframe";
 c_rgszClr[3]="windowtext";
 c_rgszClr[4]="threedlightshadow";
 c_rgszClr[5]="threedhighlight";
 c_rgszClr[6]="threeddarkshadow";
 c_rgszClr[7]="threedshadow";

 var g_iShCur;
 var g_rglTabX=new Array(c_lTabs);

function fnGetIEVer()
{
 var ua=window.navigator.userAgent
 var msie=ua.indexOf("MSIE")
 if (msie>0 && window.navigator.platform=="Win32")
  return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
 else
  return 0;
}

function fnBuildFrameset()
{
 var szHTML="<frameset rows="*,18" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=""+document.all.item("shLink")[g_iSh].href+"" name="frSheet" noresize>"+
  "<frameset cols="54,*" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src="" name="frScroll" marginwidth=0 marginheight=0 scrolling=no>"+
  "<frame src="" name="frTabs" marginwidth=0 marginheight=0 scrolling=no>"+
  "</frameset></frameset><plaintext>";

 with (document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }
</body>
</html>



Toggle HighlightingOpen in New WindowSelect All