Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You should be able to run it as a task in publisher as a Supporting Tasks!?
Dear Micheal,
thanx for your answer!
any suggestion, how i could achieve this another way?
my best wishes
leo
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
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.