Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
varunqvmm
Contributor II
Contributor II

Automation of Export Document Layout of a QVW file

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

1 Solution

Accepted Solutions
rwunderlich
Luminary Alumni
Luminary Alumni

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

View solution in original post

3 Replies
rwunderlich
Luminary Alumni
Luminary Alumni

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
Contributor II
Contributor II
Author

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
Luminary Alumni
Luminary Alumni

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

View solution in original post