Reload On Open Macro using QV Internet Explorer Plugin on Server environment

[johnhorneramllp]

We have several qlikview documents that include either of the 2 macro's (see below) which are assigned to the On Open Document Event Trigger in Settings / Document Properties / Macros. These work ok when using QlikView Developer but do not appear to work when deploying through server and using the QlikView for MS Internet Explorer plugin. I have found some other forum posts that seem to agree that this is a problem but i cannot seem to find a definitive answer for how we can automatically reload a document using QlikView Server with the MS Internet Explorer plugin.

Does anybody have a solution for this?

Regards, John H.

SUB Reload

ActiveDocument.Reload

END SUB

SUB ReloadPrompt

Answer = MsgBox("Reload again?", 4+ vbQuestion, "Reload Question")

IF Answer = 6 THEN

ActiveDocument.Reload

ELSE

END IF

END SUB

[Anonymous]

I think that this question arises again and again simply because of misunderstanding. In general, when a QV application is based on server, user is not supposed to reload it. It is not a "problem". Server based applications are supposed to be reloaded by QV Publisher, and this is the reason that Publisher comes free with the Server license.
Having said that, I should add that it is possible to create a solution that allows reload server-based applications by user request. You can find it here on QlikCommunity.

[johnhorneramllp]

Thanks Michael, I understand the role of Publisher and certainly we could set the reload to happen every 5 minutes to keep the documents as refreshed as possible (without being real time). However we are talking about a customer who has about 100 QlikView documents who have only just acquired server / publisher and we are trying to avoid the admin overhead associated with removing the Macro's from all documents and also minimize any changes perceived by the users.

I will continue my search for a solution.

Thanks. John H

[Anonymous]

John,
I believe there is no need to remove these macros since they don't do anyhting any way in this archtecture.
Second, there is a solution for 'by request reload.'. I'ts rather comlicated, you can find it somewhere here.
And, the good news that in QV 9, as far as I know, there wil be a possibility to push real time data from database to QV apps. We'll going to see soon.

[#5]

John,

Did you ever find an answer on this. I have the same requirement for a user intiated reload on the server.

Greg

[#6]

Hi,

I also look the way a user can start to reload a document on the server.

Thanks

[#7]

Hi Michael,

I have been trying to find a solution to this issue for several months. You refer to a solution that we can find "here on QlikCommunity", but I have been unable to finding it despite searching for several hours. Can you please post a url to the solution.

Thanks,

Graham

[Anonymous]

Hi Graham,
I've defenitely seen it, and it is not in Forums. I thought it was in Wiki, but cannot find now. Try to look in the blogs. Or submit a fresh post, so more eyes will read...