Hi, after uploading a zipfile, it has to be unzipped resulting in a list of files that have to be processed before the user can check their contents and report on it. Since these are relatively long running operations, I would like to tell the user what is happening, in a regular fashion. This can be anything from showing a log entry for every file that is processed, a 'night-rider' activity indicator (that does not really tell anything), a progress-bar or a status field that is updated for every file. What methods are available in Formspider to show this progress? FWIW: I thing about using Oracle Scheduler to do the heavy lifting. |
Hi Ronald, In this case, you can log the job progress into a db table. In your formspider application, create a datasource from this log table (named "LOG1" in the example below). When you run your job, start a Formspider timer (named "jobProgress" in the example below) which regularly queries (with an interval of 10 seconds for example) your log datasource in its timerExpired event. You can bind this log datasource to a Formspider grid to display the progress. As an example, the procure which runs your job may be as following:
Then, you can call the following procedure on timerExpired event of the "jobProgress" timer:
Hope this helps, thanks, I will experiment with it.
(23 Feb '13, 10:34)
ik_zelf
|
Hi Ronald,
Are you aiming to prevent the user interaction with your Formspider application during this process or the users should be able to continue to use your Formspider application during this process? Also, do you have any chance of inserting rows into a db table from the code called by your job (to log the job progress)?
Regards,
Ibrahim
Hi Ibrahim, in the database I can do anything I want. The user will be waiting for a process that can be monitored using v$session_longops, if I code it that way. There is no reason to prevent user interaction, just make the user aware of the fact that 'something' has not yet been completed.