topic macro is not sending CSV file while reloading it through QMC in QlikView

macro is not sending CSV file while reloading it through QMC

Wed, 11 Sep 2013 06:53:31 GMT

Hi all,

I m using QV 11.2 sr1. I created a macros to save a file in some folder and also triggered post reload too. If I run that application manually its sending my csv files. But if run the same appication through QMC its not sending my csv file. Anyone have any idea about this.

Thnx

Re: macro is not sending CSV file while reloading it through QMC

marcus_sommer — Wed, 11 Sep 2013 07:13:56 GMT

Macro-Execution through the server is generally difficult, many macros won't work. First you must enable the macro-execution in the settings from QEMC and second the user with which the server-services runs (is most often a special account) must have apprpriate access-rights to the file-system.

- Marcus

Re: macro is not sending CSV file while reloading it through QMC

abeyphilip — Wed, 11 Sep 2013 08:06:22 GMT

Hi,

Faced similar issues with QMC, we got around this by scheduling the reloads from windows task scheduler.

If you are taking that route, you may have to schedule batch job, with script something like this:

CALL "C:\PROGRAM FILES\QLIKVIEW\QV.EXE" /R "C:\Qlikview\xxx.qvw"

Regards,

Abey

Re: macro is not sending CSV file while reloading it through QMC

Wed, 11 Sep 2013 14:40:43 GMT

I guess this may be because of "allow system access"

anyone have any idea how to do this in register editor. my machine is WINDOWS 2008 SR2.

thnx

Re: macro is not sending CSV file while reloading it through QMC

marcus_sommer — Thu, 12 Sep 2013 07:11:18 GMT

You meant permissions on the windows file-folder? Go to the folder, choose properties / security and give the server-account access-rights. If you are no owner from folder or admin ask your admin.

- Marcus

Re: macro is not sending CSV file while reloading it through QMC

jerrysvensson — Thu, 12 Sep 2013 07:23:42 GMT

Publisher will not run any Post reload macro.

You will have to create an external program task using the syntax:

"C:\PROGRAM FILES\QLIKVIEW\QV.EXE" /R "C:\Qlikview\xxx.qvw" that Abey suggested.