Qlikview refresh via bat file

Tue, 15 Feb 2011 21:25:24 GMT

Hi Guys,

when I try to run a qvw file directly on the server via a bat file to refresh it qlikview prompts me with a dialog with two options which are...

1.) Temporarily use my leased license

2.) Enter my license information.

If I choose option one and click continue I get the file refeshed but since I'd like to schedule this job via Integration Service I don't want Qlikview to show that dialog. How can I make that happen?

Below is what I have in that bat file....

"c:\Program Files\QlikView\QV.exe" /r F:\SourceDocuments\ExecutiveDashboard_01_createQVDs_dev_DX.qvw

I might just need another switch but not sure which one...

Thx for any hint.

Ludwig

Qlikview refresh via bat file

Oleg_Troyansky — Tue, 15 Feb 2011 21:51:36 GMT

Generally speaking, reloading documents using QVS/Publisher is more robust than doing it in a bat file, so I'd highly recommend switching to the server instead.

The issue, however, is purely a licensing issue. When you reload using QVS, you are using the QVS license, and nothing else is needed. When you are reloading in a bat file, you are using QlikView Desktop (Developer) tool,which requires a license to run. In order to make it completely painles, you'd need to purchase another local license (it's the same price as a single Named User CAL) and apply it once and forever (that's the option 2 that you got). If you keep leasing license from the server, you'll have to tinker with it once in a while...

There is a way to do the same thing using the QVS, but it requires a VBScript macro to be executed, as a replacement for the bat file. Someone posted a macro like that on the forum, try looking it up.

topic Qlikview refresh via bat file in QlikView

Qlikview refresh via bat file

Qlikview refresh via bat file