Progress Bar when proccessing data in XBasic

[ferryk17]

Can I get a sample how to build progress bar when proccessing data that take a long time in Xbasic?

I can do A5.msgBox.show then hide it when proccess completed. But sometimes user not patient to wait it and want a progress bar. Thanks!

[ferryk17]

Progress Bar when proccessing data in XBasic

Can I get a sample how to build progress bar when proccessing data that take a long time in Xbasic?

I can do A5.msgBox.show then hide it when proccess completed. But sometimes user not patient to wait it and want a progress bar. Thanks!

edit :I have read this link too , but it doesn't fit my case i think..

What I need to do, for example :
Select xx from xxx, and it have 1000 rows
while flagloop

' proccessing data and show progress bar..

flagloop = rs.nextrow()
end

[pboomwork]

Re: Progress Bar when proccessing data in XBasic

Are you looking. For something to use for a web or windows appliciation. I have something quite nice for use with windows.

[ferryk17]

Re: Progress Bar when proccessing data in XBasic

Hi Paul,

I looking for web application. I have read this link too , but it doesn't fit my case i think..

What I need to do, for example :
Select xx from xxx, and it have 1000 rows
while flagloop

' proccessing data and show progress bar..

flagloop = rs.nextrow()
end

[Sparticuz]

Re: Progress Bar when proccessing data in XBasic

Can't to my knowledge, xbasic has no 'flush' command to push out data as it's processed.

[Davidk]

Re: Progress Bar when proccessing data in XBasic

You'd have to break the XBasic processing into chunks... if that's possible. At the end of the 1st part, you send back javascript which updates a progress bar and then fires off another callback with parameters to process the next chunk. At some point you're finished processing and so you send back just a progress bar update. Does mean a few callbacks, though... and not every process is right for it.

http://youtu.be/vMpK1NrIlCg?hd=1

[kkfin]

Re: Progress Bar when proccessing data in XBasic

Why not just use preloader gif until ready.

[ferryk17]

Re: Progress Bar when proccessing data in XBasic

You'd have to break the XBasic processing into chunks... if that's possible. At the end of the 1st part, you send back javascript which updates a progress bar and then fires off another callback with parameters to process the next chunk. At some point you're finished processing and so you send back just a progress bar update. Does mean a few callbacks, though... and not every process is right for it.

http://youtu.be/vMpK1NrIlCg?hd=1

Thnks David. I have tried this method.

- dim myend = mystart (ex: start from 1)
1. Select to my table, for example I have 100 rows.
2. create array to store my data , for example arr[].id, arr..].itemname
3. do my proccess with arr[myend].id and arr[myend].itemname
4. DoCallbackProcess = DoCallbackProcess + "$svs('mydiv','" + myend + " of " +mycount + " records completed...');"
DoCallbackProcess = DoCallbackProcess + "$('mybar').style.width = '" + percent + "%';"
5. DoCallbackProcess = DoCallbackProcess + "setTimeout(function(){{grid.Object}.ajaxCallback('G','{Grid.RowNumber}:all','DoCallbackProcess','','start=" + convert_type(myend+1,"C") + "');},100);"
6. repeat from 1 with myend variable = myend+1

it's work. But the ajax callback will start from first line again, select all data , create a whole array again although I only need to proccess the arr[myend+1] data. This make xbasic proccess very slow.

[ferryk17]

Re: Progress Bar when proccessing data in XBasic

Why not just use preloader gif until ready.

Ken, you mean something like a5w.messagebox('please wait....') when processing xbasic? I use this method until now. But my client not patient because it doesn't show the actual progress.

[Davidk]

Re: Progress Bar when proccessing data in XBasic

Thnks David. I have tried this method.


it's work. But the ajax callback will start from first line again, select all data , create a whole array again although I only need to proccess the arr[myend+1] data. This make xbasic proccess very slow.

Good lord... you're not doing a callback for each row... are you?

100 rows... 100 callbacks? That's just a really bad idea.

Without doing any of this... how long does your XBasic processing take? I remember re-working some email processing code where the original code was creating array after array of the essentially the same data... over and over and over. Took 20 mintues to process 3,000 rows. Once I finished removing all the crap I had it down to less than 20 seconds... and most of that was communication with the server.

So... I hope your example of 100 rows is just that... an example. You should be processing thousands of rows and sending back and message and then processing the next chunk of thousands of rows. Processing 100 rows does not qualify for a record by record progress bar update.

[kkfin]

Re: Progress Bar when proccessing data in XBasic

Ken, you mean something like a5w.messagebox('please wait....') when processing xbasic? I use this method until now. But my client not patient because it doesn't show the actual progress.

I mean animated gif.

If your client is only happy with progress bar you can do progress bar totally in client side and replace it with preload gif when your progress bar is in 80-90%. (progress bar has nothing to do with the actual server process)

[agillbb]

Re: Progress Bar when proccessing data in XBasic

you could check this out...
http://stackoverflow.com/questions/1...-ajax-response

However, note that for many processes, it is impossible to even calculate how long it will last or what % is complete.

[ferryk17]

Re: Progress Bar when proccessing data in XBasic

you could check this out...
http://stackoverflow.com/questions/1...-ajax-response

However, note that for many processes, it is impossible to even calculate how long it will last or what % is complete.

Thanks Andy, I got a new perspective now. I will not showing the actual proccess percentage.

[nxlcomputers]

Re: Progress Bar when proccessing data in XBasic

David,

Can you give an example of the javascript you return for the progress bar. I've been trying out a few different types of progress bars, some very simple...

var prog = '<div> <progress value="25" max="100"> </progress> </div>';
{dialog.Object}.setValue('PROGRESS_PERCENT',prog);

and some a little more slick looking....

{dialog.Object}.showContainerWindow(this,'WINDOW_1');
var prog = '<html><title>Bootstrap Example</title><meta charset="utf-8"><link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"><script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script><script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script></head><body><div class="container"><div class="progress"><div role=progressbar aria-valuenow  =0 class="progress-bar progress-bar-striped active" aria-valuemin=25 style="WIDTH: 25%" aria-valuemax=100> 25% </div></div></div></body></html>';
{dialog.Object}.setValue('PROGRESS_PERCENT',prog);

I just haven't gone to the next step of bringing the javascript back from the xbasic function and updating the progress bar. I'm currently just using a window container with a static text box that I'm injecting HTML into. Any suggestions?

Andrew

[Davidk]

Re: Progress Bar when proccessing data in XBasic

I'd probably do some things a bit differently today, but this still runs nicely. It's using jQuery for the progress bar.