topic Reloading in QlikView

Reloading

Thu, 22 Sep 2011 17:19:29 GMT

Hi,

Is there any way to check the QVD is reloading or getting refreshed. I am looking forward to lock the QVD when it is getting refreshed.Nobody should access the QVD.

Reloading

Jason_Michaelides — Thu, 22 Sep 2011 17:27:28 GMT

You could use the Execute command to run a .bat file at the start and end of your script that writes a status somewhere to check?

Reloading

Thu, 22 Sep 2011 17:48:11 GMT

Hi Jason,

Thanks for your response. Do you have any example QVW file for the same?

Reloading

Jason_Michaelides — Thu, 22 Sep 2011 17:55:30 GMT

At the start of your script put something like:

Execute cmd.exe /C LoadStarted.bat;

then, at the end:

Execute cmd.exe /C LoadEnded.bat;

The .bat files might send an email, or write to a file or anything that tells a person or system that the load has started/ended. Or the .bat files might move the QVD file to a secret location at the start of the reload and move it back again at the end.