Automation of Export Document Layout of a QVW file

[varunqvmm]

Hi All ,

I need to export document layout of a QVW file automatically by scheduling in windows ,is this possible ?

Lets say  i have some QVW files in my workspace  i.e. D:/QlikView 

I need all the exports of document layouts of each QVW files in a folders for all QVW files located in my workspace  

Thanks ,

Varun

[rwunderlich]

The easiest way may be to create a -prj directory for each QVW and then the document layout will be automatically exported every time the document is saved. I don't recommend doing this with production QVWs though. 

You can write a VbScript using the QV automation API.  Open each document in turn and call ExportDocumentLayout on the doc object.

-Rob

[varunqvmm]

Hi Rob,

Thanks  for the response.

Can you please provide me the VbScript for ExportDocumentLayout of QVW  as am not aware of vbscript. Should i run the vbscript in Load Script of each document ? Will it be able export all the sheet objects of QVW  at a time by writing script?

And also can you provide the exact URL for QV automation API

Thanks

Varun

[rwunderlich · Accepted solution]

The QV Automation interface is documented here. 

https://help.qlik.com/en-US/qlikview-developer/April2019/Subsystems/Automation/Content/QV_Automation...

How about using the -prj directory?  That will give you the same output as ExportDocumentLayout.  My tool here:

Qlikview Cookbook: Prj Tool http://qlikviewcookbook.com/recipes/download-info/prj-tool/

will even build the -prj directory for you so you don't have to do it manually.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com