topic Automatic Scheduled Re-Load QV Models in QlikView

Automatic Scheduled Re-Load QV Models

Wed, 01 Sep 2010 14:11:09 GMT

Hi,

I would like to make my models do an automatic reload with schedule, i.e. I want to do them in sequence. I do understand this should be done as per administration level, plus with the QV management console, which I have full access.

Any help would be highly appreciated.

Many thanks in advance.

Mauriccio

Automatic Scheduled Re-Load QV Models

suniljain — Wed, 01 Sep 2010 15:42:04 GMT

In which sequence , You want to do reload

Automatic Scheduled Re-Load QV Models

Wed, 01 Sep 2010 15:49:32 GMT

Dear Sunil,

Well, I want to re-load the QVD first, like one at 7am, then other at 7.30am... and then the models which use those QVD at 8am.

Mauriccio

Automatic Scheduled Re-Load QV Models

Wed, 01 Sep 2010 15:56:36 GMT

Sunil,

You only have to configurate your schedule in the Management Console on the Qlikview Server, i dont have acces right now to put some pictures of where you can do it, but is in the second tab, you can put the hour of your reload and even the order. Check the Reference Manual and you will see there.

Orlando Martinez

Automatic Scheduled Re-Load QV Models

Wed, 01 Sep 2010 19:49:38 GMT

Estimado Orlando,

Gracias por la ayuda, pero desafortunadamente busque en todas las lenguetas y no he encontrado.

Mauriccio

Automatic Scheduled Re-Load QV Models

Wed, 01 Sep 2010 21:08:46 GMT

Esta calendarizacion debes hacerla en la consola de administracion del servidor Qlikview, en cada uno de los documentos en la parte derecha encontraras la pestaña Reload, aqui le puedes decir cual debe comenzar primero y que una vez terminada esa actualizacion se realize la siguiente.

Por favor, avisame si aun no encuentras la pestaña para enviarte via mail algunas capturas de pantalla

Alfredo Sanchez V.

Novatech.

asanchez@gyenovatech.com.ec

Automatic Scheduled Re-Load QV Models

Wed, 01 Sep 2010 22:19:24 GMT

Estimado Alfredo,

Muchas gracias.

Afirmativo, agradeceria que me enviaras algunas pantallas.

Agradecido de antemano

Mauriccio

Automatic Scheduled Re-Load QV Models

suniljain — Fri, 03 Sep 2010 07:56:55 GMT

Dear Martinez,

We are using window schedule since last 3 yrs to reload application.

I am agree with you that it is possible with the help of QMC. But Window scheduler is another option that we have.

Regards

Sunil.

Automatic Scheduled Re-Load QV Models

Fri, 03 Sep 2010 13:59:33 GMT

Dear Sunil,

Good day.

Can you give me a tip how you do in windows scheduler ??

Many thanks in advance

Mauriccio

Automatic Scheduled Re-Load QV Models

suniljain — Mon, 06 Sep 2010 12:12:53 GMT

Dear Mauriccio,

Just make .bat file of reload script and add in window schedule task and set schedule day and time.

Regards

sunil Jain;

Automatic Scheduled Re-Load QV Models

suniljain — Mon, 06 Sep 2010 12:14:52 GMT

Can you tell me one thing . your second re-load is dependent on first or not ? pls send me path of application and qlikview .

I will send you .bat file of scheduling.

Automatic Scheduled Re-Load QV Models

Mon, 06 Sep 2010 13:30:42 GMT

Hi Mconcha,

Let us say that you have two .qvw files like "QVD Generator for Sales.qvw" and "Sales Dashboard.qvw" which is saved in C:\ Drive under QlikView folder and you have QlikView installed on C:\ Drive by default.

You need to write the following code in notepad

"C:\Program files\QlikView\Qv.exe" /r "C:\QlikView\QVD Generator for Sales.qvw"

"C:\Program files\QlikView\Qv.exe" /r "C:\QlikView\Sales Dashboard.qvw"

and save it with reload.bat file name.

Go to Windows Scheduler and create a task and browse this .bat file and put your windows userid and password and set the suitable time whenever you want to reload these files.

These files will get executed in same manner as you have mentioned in .bat file. Similarly, you can add other files as well.

Now, the same functionality has been added to QMC directly but you need to predict the timing how much first task will take and make the same difference between first and second task to achieve this.

Hope, it would helpful for you.

Thanks, Raj Kishor

Automatic Scheduled Re-Load QV Models

Tue, 07 Sep 2010 15:42:26 GMT

Dear Raj,

Many thanks for your great help.

Mauriccio

Automatic Scheduled Re-Load QV Models

Tue, 07 Sep 2010 17:24:20 GMT

Sunil, many thanks.

Mauriccio

Automatic Scheduled Re-Load QV Models

suniljain — Wed, 08 Sep 2010 06:04:32 GMT

its ok dear