Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following script that I am executing by through the Actions:
ActiveDocument.Reload
ActiveDocument.Save
strPrompt2 = "Script reload successfully completed"
msgBox(strPrompt2)
It works fine when I am running it through the QV desktop, but it skips Reload and Save parts and displays the "Script Completed" message immediattlly after I start it from the AccessPoint.
All necessary security settings in the document are turned on:
Reload
Partial Reload
Save Documents (Users)
Macro Override Security
Allow User Reload
Any suggestions are appreciated.
Best regards,
Vladimir
Hello Vladimir,
did you find a solution for that?
Kind regards
Peggy
Try to use EDX tasks instead.
Peggy, yes, I did.
QV simply is not allowing some actions / macros to be executed on the server. So there was nothing wrong with my settings, it simply does not work by design. It would be helpful for QV to display some kind of message, or put something in the log for this case, but these guys in Lund are not very concerned about this kind of issues, IMHO.
So the solution in my case was to use EDX load. It requires additional coding and task's settings update, but it's the only officially approved way to do this.
There is a ton of information on the forum and in documentation about this method (for example: Using EDX in QlikView 11), you should be able to find few articles about the process.
Good luck!
Regards,
Vladimir
Thanks a lot Vladimir!
The Reload action is not allowed when running in the server environment. If you want a sheet button, you'll have to use something that uses the EDX facility to trigger a task on the server. Here's one approach.
-Rob