topic Re: MESSAGE WHEN RELOAD IS RUNNING in QlikView

MESSAGE WHEN RELOAD IS RUNNING

fkeuroglian — Wed, 19 Mar 2014 21:25:37 GMT

Hi all, i want to know if there is something that indicated that the reload is runing in the qmc if i enter to the acces point in this moment.

if i enter to the acces point, and the reload is running, get a message or a notice in the screen

thank you a lot

Fernando

Re: MESSAGE WHEN RELOAD IS RUNNING

Wed, 19 Mar 2014 21:47:19 GMT

The only thing I can think of is putting a Reload start time and Reload End time message in your app so that the user will be aware of when the reload usually happens/or new data will be available or when it was lastly reloaded.

The current reload process cant be captured as there could be multiple qvws which run sequentially to generate the final Front end with your reports.

Re: MESSAGE WHEN RELOAD IS RUNNING

fkeuroglian — Wed, 19 Mar 2014 21:50:01 GMT

Hi, Ajay, thank you for the answer, but i DO NOT have a time to reload, becausae my reload depens on an external events, and could happend at different time.

I DO NOT SET A TIME THAT ALWAYS RELOAD AT THE SAME TIME.

Re: MESSAGE WHEN RELOAD IS RUNNING

Wed, 19 Mar 2014 23:41:55 GMT

Why don't you add a variable into your load script

e.g

vReloadTime = now()

so when your reload happens by your external event it captures the date and time. In turn you could build an alert of the back of the variable.

Re: MESSAGE WHEN RELOAD IS RUNNING

stevedark — Thu, 20 Mar 2014 00:00:20 GMT

Hi Fernando,

An interesting problem. As the instance of the document is not changed until the point that the reload is finished I can't think of how you would do this natively in QlikView. Are your users using the Ajax client? If so what you could do is have an extension object in the document and have that showing a simple HTML page. That HTML page you could write to at the start and the end of your load script.

The script you could create by doing something like this:

Temp_Started:

LOAD

[<html>]

INLINE [

<html>

<head><title>Load Status</title></head>

<body>

<h2>Reload in progress</h2>

</body>

</html>

];

STORE Temp_Started INTO LoadStatus.html (txt);

DROP TABLE Temp_Started;

You could then do the same thing at the end of the load script, except to write out the fact that there was no reload in progress.

You should be able to find on-line how you set up a QlikView extension to show a basic HTML page.

I am sure there are other ways - but that is the one that springs to mind at the moment.

Steve

Re: MESSAGE WHEN RELOAD IS RUNNING

rwunderlich — Thu, 20 Mar 2014 01:05:17 GMT

As others have indicated, this is complex and may not actual provide much useful.

I'd like to take a step back and ask why you want to do this? Perhaps there is another solution to the business objective.

-Rob

Re: MESSAGE WHEN RELOAD IS RUNNING

fkeuroglian — Thu, 20 Mar 2014 12:59:40 GMT

Ross,Steve,Rob thank you for your time and your answer

Rob, the thing is that i not have a set time to reload every day, and mi cliente want to reload after his proccess sql, and they want if some user enter to the web acces point , that the document notice them and the user could know that the document is reloading right now.

Re: MESSAGE WHEN RELOAD IS RUNNING

sudeepkm — Thu, 20 Mar 2014 13:15:18 GMT

Do you want to reload the document when your end user opens it on Access Point?

I think running reload may not work from AJAX client.

If you have not setup a schedule to reload your document then how you are running the reload now. Is it a manual reload every time?