Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Downloading to a text-file by Publisher Reload Task

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

5 Replies
Not applicable

SV:Downloading to a text-file by Publisher Reload Task

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



Not applicable

SV:Downloading to a text-file by Publisher Reload Task

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

Not applicable

SV:Downloading to a text-file by Publisher Reload Task

Dear Micheal,

thanx for your answer!

any suggestion, how i could achieve this another way?

my best wishes

leo

Not applicable

SV:Downloading to a text-file by Publisher Reload Task

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

Not applicable

SV:Downloading to a text-file by Publisher Reload Task

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.

Community Browser