topic Re: Scheduline export to Excel in QlikView

Scheduline export to Excel

amars — Tue, 23 Jul 2013 09:56:46 GMT

Hi all,

I wish to know what is the best possible way to implement export to excel in an environment like below

1. Have No publisher

2. Qlikview Server is not accessible to any developer (i.e. Qlikview Service account is not accessible)

Currently we have a batch file which runs at regular interval's and a post reload macro will do the job of export to excel.

Now I have some change to be migrated to the server, as the batch file runs with QV.exe it needs a file which is created using the service account (i.e. account used to run Qlikview Services). The issue that happens here is the personalized version of Qlikview Developer doesn't recognise any other files that a developer wish to migrate and the batch job start's giving error.

Is there a way so that the Qlikview Developer licence on Qlikview Server doesn't expires? just like Qlikview 8.5.

Please let me know. Thanks in Advance.

Amar

Re: Scheduline export to Excel

marcus_sommer — Tue, 23 Jul 2013 11:37:08 GMT

I'm not really sure what do you meant with "file which is created using the service account"? QVW's from other user could not open with a personal edition, but you could generate in the same process an appropriate data-output which the user could then load.

- Marcus

Re: Scheduline export to Excel

amars — Wed, 24 Jul 2013 00:54:04 GMT

Hi Marcus,

Service Account is the one which runs all the Qlikview Services. We do not have access to this account as a policy. But when we use QV.exe in a batch reload it gives error as "The Qlikview file is being created by another Qlikview Personal Edition user".

Now I don't know how I can avoid the Qlikview Developer on our Qlikview Server from expiring (1 month duration of licence lease after using Open in Server).

Kindly suggest.

Thanks

Re: Scheduline export to Excel

amars — Wed, 24 Jul 2013 02:53:06 GMT

Just to share with you all, found a way to licence lease on a scheduled basis. One can schedule a job using a command like below

qv.exe /r qvp://servername/MyQlikviewFile.qvw

Link below

http://community.qlik.com/message/217363#217363

Thanks

Amar