topic Re: Automatic Reload without server in QlikView

Automatic Reload without server

pgalvezt — Mon, 11 Jun 2012 13:16:26 GMT

Is there a way to automatize qlikview to do automatic reload? The idea is reload several sheets every day.

Thanks,

Re: Automatic Reload without server

magavi_framsteg — Mon, 11 Jun 2012 14:03:30 GMT

pgalvezt wrote:
Is there a way to automatize qlikview to do automatic reload? The idea is reload several sheets every day.
Thanks,

Hi pgalvezt.

You can use the standard Windows Scheduler to schedule a batch/command file with the following content:

%PROGRAMFILES%\QlikView\QV.exe /r D:\appz\myapp.qvw

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Automatic Reload without server

pgalvezt — Mon, 11 Jun 2012 15:45:44 GMT

My QV doesn´t reload.

This is my path in windows server 2003 is that correct?

C:\Program Files\QlikView 10\QV.exe /r E:\DD\ZZ\app.qvw

Re: Automatic Reload without server

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 15:48:04 GMT

Hi,

Are you using that line in a BAT file properly quoted?

"C:\Program Files\QlikView 10\QV.exe" /r E:\DD\ZZ\app.qvw

Hope that helps.

Miguel

Re: Automatic Reload without server

pgalvezt — Mon, 11 Jun 2012 16:12:12 GMT

I try first with:

"C:\Program Files\QlikView 10\qv.exe" //Qv was opened

Then

"C:\Program Files\QlikView 10\QV.exe" /r E:\DD\ZZ\app.qvw //Failed to open document

Re: Automatic Reload without server

Bill_Britt — Mon, 11 Jun 2012 16:28:54 GMT

You need to make sure that the user that the scheduler is set to run under has a license assigned to them. If not the reload will fail.

Re: Automatic Reload without server

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 16:47:06 GMT

Hi,

In addition, make sure that the mapped drive is available for the user that is running the batch file.

Miguel

Re: Automatic Reload without server

pgalvezt — Mon, 11 Jun 2012 16:49:04 GMT

Hi, I'm not using schudeler task yet. What I'm doing is execute the task with double clic. But the document thrown that error (Failed to open document).

Re: Automatic Reload without server

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 16:58:50 GMT

Hi,

Does the path really exists and the mapped drive is reachable? Try enclosing with double quotes the second parameter:

"C:\Program Files\QlikView 10\QV.exe" /r "E:\DD\ZZ\app.qvw"

Hope that helps

Miguel

Re: Automatic Reload without server

Mon, 11 Jun 2012 17:41:54 GMT

if you have security in your document, you will need to include the username and password at the end of that same line. i.e. at the end of the command have a space, then the username, a space and the password

Re: Automatic Reload without server

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 17:46:27 GMT

Hi,

That's a good point but, unfortunately that does not work that way. In section access you need to add the user that runs the batch file in the NTNAME field. Check here for further information.

Hope that helps.

Miguel

Re: Automatic Reload without server

pgalvezt — Mon, 11 Jun 2012 18:17:54 GMT

Hi Miguel, you know I did that but I have the same problem.