Execute cmd in server via AP

[jasonseril]

Good day all!

I want to execute a macro via Access Point (IE plugin client) a cmd/bat script in the QlikView Server, that loads a csv data to a DB server, is there a work around for this issue?  I used psexec to connect to qvserver and execute the script but i got a qlikocx macro parse error in the ie plugin:

Please help...thanks in advance..

jason

[Miguel_Angel_Baeyens]

Hello Jason,

Does your document allow to execute external programs via macro?

• Go to the Editor Script dialog, Settings tab on the bottom part, check "Can Execute External Programs".
• Check in the module editor that Requested module Security and Current Local Security allow "System Access".
• Besides make sure that you are allowing macro execution on server, go to the QEMC, System, Setup, QlikView Servers, click on your server, Security tab, Allow Macro and Unsafe macro execution on server.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[jasonseril]

Hi Miguel,

Thanks for this fast reply.  Actually, I did all the settings from your list, but unfortunately I still got the same error.

Jason

[Miguel_Angel_Baeyens]

Hi Jason,

Then it may be something related to the coding of the macro, NTFS permissions to run applications in the folder by the user...

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica