Downloading to a text-file by Publisher Reload Task

[#1]

Hello Pros,

i use the following vb-macro coding to download a table to a text-file:

tb.Export "\\xxxxx.fffff.xx\xxxxx\xx\xxxxxx\xxxx\xxxxxxxxxxxxxxx\PS\Bestände\Bestand ohne KA-Bezug-Werte_PS.txt",chr(9),0

But the file is not updated. When i reload the document manually - no problem. Does Publisher not see the rest of our network?

Is this a general problem?

Cheers

Leo

[#2]

Yes, its a general problem with publisher:

From manual:

QlikView Distribution Service does not execute any macros that may exist in the Source Document.

Regards

/Michael

[#3]

You should be able to run it as a task in publisher as a Supporting Tasks!?

[#4]

Dear Micheal,

thanx for your answer!

any suggestion, how i could achieve this another way?

my best wishes

leo

[#5]

Hello Kristofer,

thank you for your answer.

Actually, i don't really get to the bottom of your answer.

I checked the control panel - i couldn't find any supporting task option there - what exactly do you describe by 'supporting task'.

Cheers

leo

[#6]

Hi!

We use publisher 9.0 and it's quite different from 8.5. In Qlikview Enterprise Management Console under sheet "System" there is something called "Supporting Tasks" and "External program tasks". From here you could write a command line statement: that runs your qlikviewapplikation.

For exemple

"C:\Program Files\QlikView\QV.exe" /R /NoSecurity "\\server\Applikation.qvw"

For instance we use "Supporting Tasks" when we use macros that need to be "allow system access" in the source document to be loaded.