topic Re: Macros on server in QlikView

Macros on server

salezian — Mon, 26 Jan 2026 18:19:17 GMT

Hi Everyone

I'm trying to reload using scheduler QlikView document containing two macros. Macros are used to count files in folder and delete files. Here is example of macro's code:

public function DeleteFile(filePath)

Set objFSO = CreateObject("Scripting.FileSystemObject")

Dim retVal 'as Boolean

If objFSO.FileExists(filePath) Then

Call objFSO.DeleteFile(filePath)

retVal = true

Else

Set objFSO = nothing

retVal = false

End If

DeleteFile = retVal

end function

Locally those macros work fine. But when document is refreshed by scheduler I got general error as a result.

Is there any workaround to launch document on server ?

Regards.

Re: Macros on server

vikasmahajan — Thu, 09 Jan 2014 09:15:09 GMT

In scheduler macros never work , you need to run through batch file.

Vikas

Re: Macros on server

salezian — Thu, 09 Jan 2014 09:37:17 GMT

Thanks for answer. Should I schedule file using system scheduler ?

Re: Macros on server

jerrysvensson — Thu, 09 Jan 2014 09:42:54 GMT

If possible use an External program task.

Everything in one place and you can use depency also.

Re: Macros on server

salezian — Thu, 09 Jan 2014 10:06:14 GMT

Unfortunately still doesn't work. Reload is starting but macro doesn't work. It returns null.

Below is macro's code:

public function countFiles(directoryPath)

Dim noOfFiles,objFSO,objFolder

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objFolder=objFSO.GetFolder(directoryPath)

noOfFiles=0

for each file in objFolder.files

if LCase(objFSO.GetExtensionName(file)="xls") then

noOfFiles=noOfFiles+1

end if

countFiles=noOfFiles

end function

Would be grateful for any help.

Re: Macros on server

jerrysvensson — Thu, 09 Jan 2014 10:45:27 GMT

What is your inparams?

C:\<dir> or for instance z:\<dir> ?

When you run it in Publisher, it will run in service account that may not have the same drive mapping as your user.

Re: Macros on server

salezian — Thu, 09 Jan 2014 10:49:31 GMT

I run it using bat file (QV.exe /r path_to_qv_file)

In script I set folder name. Example below:

vFlatFilesPath='C:\ProgramData\QlikTech\Documents\Tesco\Data\FlatFiles'

Let vNoOfFiles=countFiles('$(vFlatFilesPath)');

Regards.

Re: Macros on server

jerrysvensson — Thu, 09 Jan 2014 11:34:03 GMT

Does your service account have a license?

What does the logfile say?

Re: Macros on server

salezian — Thu, 09 Jan 2014 12:11:26 GMT

Yes it has.

As I said I try to run it using batch file. Log says that variable vNoOfFiles is null (but when run locally it works fine).

Re: Macros on server

Bill_Britt — Fri, 10 Jan 2014 13:50:20 GMT

Hi,

Can you explain what you mean by "but when run locally it works fine". I would think this would have to be ran on the machine that you are wanting the work done on.

Bill

Re: Macros on server

salezian — Fri, 10 Jan 2014 15:37:14 GMT

When I reload it by opening document and hitting ctrl + R.

Re: Macros on server

whiteline — Fri, 10 Jan 2014 19:33:02 GMT

Hi.

Have you checked a simple function containing one line 'DeleteFile = true' ?

Re: Macros on server

rwunderlich — Fri, 10 Jan 2014 20:03:41 GMT

The CreateObject("Scripting.FileSystemObject") call requires your module to have System Access. To get System Access from the command line, you have to add the switch /NoSecurity.

QV.exe /r /NoSecurity path_to_qv_file

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Macros on server

salezian — Mon, 20 Jan 2014 14:59:56 GMT

Thanks Rob,

Now it works like a charm.