topic Macro does not run in server but run in client in QlikView

Macro does not run in server but run in client

Mon, 28 Mar 2016 15:32:42 GMT

I have a macro that run a batch file , the bat file use psftp to upload the output of macro into sftp server. when I press the button in client version everything is work perfect, but when I try to use the same macro using access point (using IE browser) the psftp does not upload the file (Red colour line).

(I try to use UNC, but it does not work )

The macro code :

Dim obj

Set obj = CreateObject("WScript.Shell")

obj.Run "\\ServerSharedFolder\sftp\C1t.bat " & vFilePath & " " & vFileName ,1 , TRUE

The .bat file content :

@echo put %1 > C:\Users\myuser\Desktop\SFTP\%2.src

C:\Users\myuser\Desktop\SFTP\psftp.exe abc@ServerIP -b C:\Users\myuser\Desktop\SFTP\%2.src

del C:\Users\myuser\Desktop\SFTP\%2.src

I believe my macro code need some change.

Re: Macro does not run in server but run in client

avinashelite — Tue, 29 Mar 2016 06:29:54 GMT

*Make sure you are granting System Access to your macros in the server through QEMC (System, Setup, QlikView Servers, expand and click, Seucrity tab in the right pane "Allow unsafe macro execution on server" and "Allow macro execution on server" ticked) and in the Macro editor, (Ctrl + M, bottom left drop downs)

*If they are creating some filesystem object (such an excel file) make sure you are using the IE Plugin.

Hope that helps.

Re: Macro does not run in server but run in client

Tue, 29 Mar 2016 06:41:50 GMT

Dear Avinash, Thanks for reply,
I already have done all of these configurations before and I am using IE but it does not work.

Re: Macro does not run in server but run in client

jerrysvensson — Tue, 29 Mar 2016 06:50:23 GMT

Are you using plugin or WebView (Ajax) as client? This will only work with plugin.

Re: Macro does not run in server but run in client

Tue, 29 Mar 2016 06:59:04 GMT

Dear Jerry,

Yes I am using IE QVplugin.