topic Re: Reloading time in QlikView

Reloading time

Tue, 25 Jul 2017 07:59:07 GMT

Hi Qlikers,

I would like to know how can i build a control panel to check the Reloading time of any Qlik file.

I've used the FileTime function on script to catch the Modified Time of every Qlik File located in a folder.

My purpose is catching the Reloading Time of a Qlik File because it's different from the Modified Time.

Have you any idea??

Thanks in advance.

Re: Reloading time

RonaldDoes — Tue, 25 Jul 2017 08:05:35 GMT

Hi Michele,

You could store the reloadtime into a single QVD in all your load scripts. That way you would just have to load the QVD to get all current (and past!) reloadtimes for your documents.

Hope this helps you.

With kind regards,

Ronald

Re: Reloading time

prieper — Tue, 25 Jul 2017 08:09:47 GMT

You may load only the xml-part of an application and then check for a variable like

"LastReloadTimeISO"

HTH Peter

Re: Reloading time

RonaldDoes — Tue, 25 Jul 2017 08:12:16 GMT

To this end, I've written the following code into a txt-file and include that into all my scripts with a single include statement.

SUB ReloadInfo (_Dashboard,_ReloadStart,_ReloadEnd,_DataSource,_DataSourceMaxTimeStamp)

Reloadinfo:
LOAD * INLINE [
    Dashboard, ReloadStart, ReloadEnd, DataSource, DataSourceMaxTimeStamp
    '$(_Dashboard)','$(_ReloadStart)','$(_ReloadEnd)','$(_DataSource)','$(_DataSourceMaxTimeStamp)'
];

Concatenate LOAD
    Dashboard,
    ReloadStart,
    ReloadEnd,
    DataSource,
    DataSourceMaxTimeStamp
FROM
[$(vQVDPath)ReloadInfo.qvd]
(qvd);

STORE Reloadinfo into [$(vQVDPath)ReloadInfo\ReloadInfo.qvd] (qvd);
DROP Table Reloadinfo;

END SUB

Start your script with:

$(Must_Include=..\Include\reloadtime.txt);

And call your sub when you're sure the reload was successful::

CALL ReloadInfo (DocumentName(),'$(vReloadStartTime)','$(vReloadEndTime)','somesourcesystem', 'maxsourcedate');

Re: Reloading time

Siva_Sankar — Tue, 25 Jul 2017 08:40:20 GMT

Dashboard Change Monitoring

https://qlikviewcookbook.com/2010/09/monitoring-the-reload-schedule/

Re: Reloading time

Tue, 25 Jul 2017 08:41:10 GMT

Thank you Ronald to your quick answer.

This solution has been the first way that I've tried but unfortunately not every user can store a QVD in the QVD folder.

There is a problem of security!!!

I need an external Control Panel that read the reloading time of any Qlik file.

Re: Reloading time

Siva_Sankar — Tue, 25 Jul 2017 08:45:24 GMT

You can refer the url mentioned in my thread. It will help to monitor the reload time.

Re: Reloading time

Tue, 25 Jul 2017 09:42:06 GMT

Thanks sivasankar,

i've looked on the URL but Rob use FileTime function like me.

I need to check the Reloading time that is different from FileTime.

The Scheduler launch the reload of each Qlik file but where something goes wrong the reload is stopped.

The Modified Time change but the Reloading Time remain unchanged.

I want to know when a reload doesn't work till the ending.

Re: Reloading time

Frank_Hartmann — Tue, 25 Jul 2017 09:46:51 GMT

is this helpful?

Re: Reloading time

PrashantSangle — Tue, 25 Jul 2017 09:56:51 GMT

did you try with reloading document log after reloading dashabord.

logic like below

1: your dashboard loading script

then

2: load document log of that file

Regards,

Prashant S.