topic Re: Macro don't run from server in QlikView

Macro don't run from server

realpixel — Fri, 22 Nov 2013 16:10:19 GMT

Macro on the server don't run, it's works fine from QV Desktop

On Macro:

Requested Module security = System Access
Current Local Security = Allow System Access

On server Secuity tab:

Allow macro execution on server is enable
Allow unsafe macro execution on server is enable also

somone have an idea?

I try from IE or Firefox is the same problem, nothing happens

Re: Macro don't run from server

Anonymous — Fri, 22 Nov 2013 19:41:52 GMT

Are you using the IE plugin ? I suspect not as you mention Firefox,

As macros don't work in Full Browser (Ajax) Mode.

Best Regards, Bill

Re: Macro don't run from server

Clever_Anjos — Fri, 22 Nov 2013 19:45:50 GMT

Plugin or Ajax?

Re: Macro don't run from server

montero91 — Fri, 22 Nov 2013 19:59:39 GMT

Recuerda que tenemos dos distintos accesos a qlikview,

uno es Ayax, el cual funciona con cualquier navegador de manera nativa el cual nos permite la coneccion desde los dispositivos moviles pero como esta coneccion es usuario - servidor la macro en teoria se ejecutaria en el servidor el cual qlikview no permite.

Y tenemos el Plugin que unicamente funciona con el IE, el cual nos ayuda a la ejecucion de macros desde el usuario. pero al abrir el documento al igual que en excel te pregunta que si quieres habilitarlos, si los habilitas nunca podras correrlos.

Si no te aparece esta ventana puedes teclear la opcion Ctrl + Shift + m y te aparecera un cuadro emergente indicando que si le permites acceso al sistema, con lo cual podras ejecutar tu macro.

Saludos...

-------------------------------

Remember that we have two different access to qlikview,

One is Ajax, which works with any browser natively which allows us the connection from mobile devices but this connexion is as user - server and the macro would run on the server which does not allow qlikview.

And we have Plugin that only works with IE, which helps us to the execution of macros from the user. but to open the document as in excel asks you if you want to enable them, if you enable'll never run them.

If this window does not appear you can type the option Ctrl + Shift + m and a popup box will appear indicating that if you allow access to the system , which you can run your macro.

Greetings ...

Re: Macro don't run from server

realpixel — Sat, 23 Nov 2013 08:45:30 GMT

Hello,

Thank you for your reply, how to check if plugin or ajax, on server or on Desktop?

Where I can find IE plugin? it must be installer on desktop or on server?

Regards

Re: Macro don't run from server

jagan — Sat, 23 Nov 2013 09:00:51 GMT

Hi,

If your URL contains Plugin at the end then it is IE plugin otherwise it is Ajax, If you want to download IE plugin use the link in Internet Explorer Accesspoint. IE Plugin works in server and internet Explorer.

Regards,

Jagan.

Re: Macro don't run from server

Tue, 04 Feb 2014 16:24:44 GMT

HI,

As per p.833 of the QV11 SR2 reference manual the following should be kept in mind:

In the client you have much greater freedom, while on the server the actions of the macros can be unexpected or missing all together =/

An alternative approach might be using an external process via a .bat file:

http://community.qlik.com/thread/64511

Or using Publisher's External Program option to manage it for you:

http://community.qlik.com/message/434200#434200

HIH,

Charles

Re: Macro don't run from server

Tue, 04 Feb 2014 17:16:34 GMT

Enable this Flag on QMC :

"Allow Unsecure Macro on Server"