Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro does not run in server but run in client

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.

4 Replies
avinashelite

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

Not applicable
Author

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

jerrysvensson
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

Dear Jerry,

Yes I am using IE QVplugin.