topic Automate Data Extraction from a QV application in QlikView

Automate Data Extraction from a QV application

Tue, 13 Apr 2010 14:50:00 GMT

Hello

Does anyone know of a way to automate the opening of a QV application, making a selection and extracting a table as a .CSV file or into Excel?

Can this be done with a batch (.BAT) file?

Thanks.

Automate Data Extraction from a QV application

d_pranskus — Tue, 13 Apr 2010 14:55:01 GMT

You should use macro for OnOpen document action and then loop through selections and export data from table to excel file. If you open it from bat file - it should work.

Cheers

Darius

Automate Data Extraction from a QV application

justinasp — Tue, 13 Apr 2010 15:08:52 GMT

1. Make *.bat: to reload file

"C:\QlikView\qv.exe (or similar)" /r "[your Qlik file with full path]"

2. Write macros and execute it OnPostReload

ActiveDocument.Fields("SomeField"). Select "SomeValue"

ect.

Set obj=ActiveDocument.GetSheetObject("CH01")
obj.ExportBiff "ExportFilePath"

Good luck,

Justinas

Automate Data Extraction from a QV application

Tue, 13 Apr 2010 16:28:31 GMT

Thanks

Is it possible to call the macro from the batch file?

Biff is an image format isn't it? Is it possible to export the actual figures?

Automate Data Extraction from a QV application

Tue, 13 Apr 2010 16:41:23 GMT

Ah, sorry, should have checked first. I can see it's an xls format. Can it output as csv?

Automate Data Extraction from a QV application

Tue, 13 Apr 2010 16:45:00 GMT

Doh! I've found that too now. I really should search the forum before posting my questions!

Automate Data Extraction from a QV application

Tue, 13 Apr 2010 16:47:56 GMT

Okay, so I've found out most of what I wanted. All I don't know is whether I can call the QV macro from a batch file (.BAT) can it be done? Or do I have to trigger the macro from a reload?

Automate Data Extraction from a QV application

justinasp — Wed, 14 Apr 2010 12:26:39 GMT

Here you go:

http://qlikviewmaven.blogspot.com/2008/08/qlikview-command-line-and-automation.html

Here you'll find some information about your issue. With *.bat file you open Qlik document and run macros OnOpen, then close application.

Take care,

Justinas