Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

montubhardwaj
Contributor III

Not creating text file when run using publisher.

Hi All,

I have an application in which I have created a list box from a variable. Now, Using Macro, I am exporting this list box to a text file. I am triggering this Macro(which contains the code to export list box to text file) on Post reload. This is working all fine when I am running my application manually and creating a text file as desired. But when I am running the same application using publisher, the text file is not getting created. Can someone please let me know where it is going wrong ?

Regards,

Sharma

6 Replies
chauhans85
Esteemed Contributor

Not creating text file when run using publisher.


I believe u need to added urself as distributed user or authenticated user using publisher.

thanks

Sunil Chauhan

danielrozental
Honored Contributor II

Not creating text file when run using publisher.

Publisher doesn't run macros.

What you can do is trigger a reload through publisher. You should look around the forum as I believe this topic has been discussed several times before.

chauhans85
Esteemed Contributor

Not creating text file when run using publisher.

i believe it should run.because i have a application in 9.0.

and has a macro.after reload its working properly.

or

If i not understand correctly then please make clear.

thanks

Sunil

danielrozental
Honored Contributor II

Not creating text file when run using publisher.

I think it was clear enough but if you need further explanation.

Macro's will not work when a document is reloaded through qlikview publisher and triggered "on post reload". That trigger will only work when being run in qlikview developer "qv.exe".

montubhardwaj
Contributor III

Not creating text file when run using publisher.

Hi Sunil, thanks for looking into this. The problem is that trigger is being fired on post reload but its not creating the text file   But If I reload the qvw manually, it works all fine.

Hi Daniel,

Below is the macro which I have written for exporting List Box to text file.

sub test

set lb = ActiveDocument.GetSheetObject("LB01")

lb.Export "C:\Documents and Settings\USER\Desktop\test.txt" , ";"

end sub

This macro is fired on Post Reload. But when the file is reloaded using publisher, its is not working. Any workaround for this ?

montubhardwaj
Contributor III

Not creating text file when run using publisher.

I also tried to export the field directly using triggers(without macro) on post reload as below but that also did not work.

Document Properties=> Triggers => on post reload => add actions => Exoprt

but this did not work. 

Community Browser