Triggers that export data from a .qvw file

[#1]

Hello Community,

I have a QlikView file that I use to extract and manipulate data coming form an external database (in Jade).

I then export 3 charts on my model into 3 different  .csv files. To speed up the process, I've set up 3 buttons that do that, but I have to open the file and manually click on the buttons... Can I automatize that?

The script is reloaded automatically daily to refresh the data.

Is there a way to work with 'Triggers' so that I can automatize the export process? I've tried a trigger connected to Post Reload, but it doesn't seem to work.

Thanks and Regards,

Cristina

[#2 · Accepted solution]

you need not create straight tables or chart, you can directly use the store command

Store Field1, Field2, Field3 From File into Filename.CSV(txt);

create a  batch file command

"C:\Program Files\QlikView\Qv.exe"  /r File.qvw

and schedule this using windows scheduler

hope this helps

[vardhancse]

Try to give the action you gave to button in trigger->on open.

so that once we open the dashboard automatically it will export

[#4]

Thank you very much for your help, Venkita.

I am testing the task running the batch file and I think with some fine tuning I'll get what I need.

Regards,

Cristina

[#5]

Yes, I had tried that, but that works as long as I have to task to actually open the model.

Still playing with it.

Thanks and regards,

Cristina

[#6]

Apologies Venkita,

Another question: is there a batch command that will only open the .qvw file?

Thanks and Regards,

Cristina

[#7]

"C:\Program Files\QlikView\Qv.exe" File.Qvw

[#8]

Thank you very much.

That does the trick.

I have:

- a batch file that opens a .qvw

- the .qvw file runs a few tasks triggered on open, including closing the file.

BUT! both QlikView and the cmd screen remain open. When/if I close QlikView then the cmd screen closes as well.

Is there any way to get the both apps to close on conclusion of the batch file?

NOTE: the "STORE  into ... " script works for a few other extractions I do, but in this case, the output file is the result of some pivoting.... I find it's easier to do it exporting a chart so that I can check what the chart is showing and exporting as there are other processes running after mine...

Thanks so much!

[#9]

An alternate option would be to write a vbs file to do all the job and call it via batchfile

I have created a test file.

1. AutomationTestVBS.qvw

2. Test.VBS

3. Test.bat

Copy all the files to a folder called TMP

Edit the Test.VBS file in notepad change the path statement to point to the folder created.

save the file

run the batch file and that will invoke the vb script and the vb script will generate the excel file out of the pivot table.

Hope this helps