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

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

johnhorneramllp — Sat, 16 May 2009 04:16:16 GMT

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

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

Anonymous — Sat, 16 May 2009 08:30:14 GMT

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.

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

johnhorneramllp — Sat, 16 May 2009 23:16:17 GMT

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

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

Anonymous — Sun, 17 May 2009 01:42:54 GMT

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.

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

Wed, 27 Jan 2010 20:30:29 GMT

John,

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

Greg

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

Thu, 25 Feb 2010 11:45:26 GMT

Hi,

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

Thanks

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

Tue, 12 Oct 2010 14:52:03 GMT

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

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

Anonymous — Thu, 14 Oct 2010 17:49:00 GMT

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...