topic Re: Configuring an automatic reload twice a month with the QlikView Management Console? in QlikView

Configuring an automatic reload twice a month with the QlikView Management Console?

caccio88 — Tue, 14 Jun 2016 13:26:54 GMT

Hi guys,

what I would like to do is to set that my app will be reloaded on the 1st day of the month and on the 15th of the same month.

On the management console I don't have this chance, but only every day, week, month...

So I thought to set the reload every day and change something in my script that doesn't really reload the app if is not the 1st day of the month and on the 15th of the same month, but I simply don't know how...

Any idea?

Thank u all.

Filiberto

stalwar1‌swuehl‌gwassenaar‌

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

sasikanth — Tue, 14 Jun 2016 13:36:49 GMT

HI,

Please check the option daily and make it as

For every 15 days and start time .

Please check it once

Thanks

Sasi

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

swuehl — Tue, 14 Jun 2016 13:41:48 GMT

You can also use the EDX trigger mechanism

Using EDX in QlikView 11

and use a command line script triggered by Windows task scheduler to fire the EDX trigger.

The Windows task scheduler can be set up to fire on 1./ 15. each month.

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Clever_Anjos — Tue, 14 Jun 2016 13:45:02 GMT

Configure to reload daily

Use this script

IF Day(Today()) = 1 or Day(Today()) = 15 then

// Put your script here

ENDIF

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Anonymous — Tue, 14 Jun 2016 13:54:53 GMT

Hi Filiberto.

Don't have this options?

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Clever_Anjos — Tue, 14 Jun 2016 13:57:07 GMT

This screen only shows if you´re using a Publisher (not sure if it´s the case)

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Colin-Albert — Tue, 14 Jun 2016 13:59:02 GMT

Manuel's screen shows the Trigger options if you have a publisher licence.

If you just have server and no publisher then you can only have one trigger per reload task and do not have this flexibility.

cleveranjos‌ has suggested a workaround.

Set the task to load daily at the time you require, and then add his IF statement around the whole of your load script, so the load only occurs on days 1 and 15.

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

caccio88 — Tue, 14 Jun 2016 13:59:09 GMT

I think that could work for me.

Thank you so much cleveranjos‌

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

swuehl — Tue, 14 Jun 2016 14:00:50 GMT

Just take care that you don't end up with an empty data model in your dashboard on all other days

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Anonymous — Tue, 14 Jun 2016 14:01:23 GMT

Hi Colin,

Filiberto don't specify if he has Publisher or not, and I am answering if he has this option or not.

I know that this option is only for Publisher.

Thanks.

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

caccio88 — Tue, 14 Jun 2016 14:03:45 GMT

You're right Manuel. But I haven't got a publisher.

Thank you so much anyway.

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Colin-Albert — Tue, 14 Jun 2016 14:04:28 GMT

Another way to achieve the same result is to add this at the start of your load script so the script exits cleanly on the "wrong" days.

// Abort reload if day <> 1 or Day <> 15

If not match(day(Today(), 1, 15) then

trace === Not Day 1 or 15 Reload not run === ;

exit script ;

end if ;

trace === Reload Data === ;

<< Your Reload Script Continues here... >>

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Clever_Anjos — Tue, 14 Jun 2016 14:07:51 GMT

swuehl‌ is correct as always.

If the script does not execute, the model will be empty.

This version will force an error, so DistributionTask will rollback last data

IF Day(Today()) <> 1 and Day(Today()) <> 15 then

STORE nonexistingtable into foobar.qvd(qvd);

ENDIF

// your script goes here

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

caccio88 — Tue, 14 Jun 2016 14:14:32 GMT

One question cleveranjos‌:

If I use your solution and the reload starts today (June 14), the app loads anything , but in this way I can't display what I've loaded at the 1st of June. Is it clear what I'm talking about?

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

caccio88 — Tue, 14 Jun 2016 14:15:04 GMT

Yep. I think that's my scenario...

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

caccio88 — Tue, 14 Jun 2016 14:15:27 GMT

Solutions?

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Anonymous — Tue, 14 Jun 2016 14:15:40 GMT

Don't worry, but with the IF solution you will lost your data model.

Other way is create a task on Windows, and reload with a bat.

Other way too, you can do binary reloads, with one app for the model and other file with app. In this case, you can get failed model on days that aren't 1 or 15, but your app don't will be affected.

Regards!

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

swuehl — Tue, 14 Jun 2016 14:17:51 GMT

I've used something similar in the past, but then ended up with failed tasks in the status bar and email alerts.

Maybe it's possible to work around the empty data model using a partial reload (is this even possible without the publisher?).

I am now using EDX tasks for these kind of requests. It's pretty simple to setup using the command line executable and the windows scheduler offers more options than the non-publisher QMC.

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

Colin-Albert — Tue, 14 Jun 2016 14:20:05 GMT

Store all your tables to QVD on completion of a successful reload on the 1st & 15th.

On other days just load the data from the existing QVDs.

This avoids having errors which will indicate a failed load tasks in the QMC and possibly generate failure emails.

Re: Configuring an automatic reload twice a month with the QlikView Management Console?

caccio88 — Tue, 14 Jun 2016 14:47:52 GMT

When you talk about binry reloads, what do you mean exactly? Do Do you mean to create 2 apps?