Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reloading time

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.

9 Replies
RonaldDoes
Partner - Creator III
Partner - Creator III

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

prieper
Master II
Master II

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

"LastReloadTimeISO"

HTH Peter

RonaldDoes
Partner - Creator III
Partner - Creator III

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');

Not applicable
Author

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.

Siva_Sankar
Master II
Master II

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

Not applicable
Author

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.

Frank_Hartmann
Master II
Master II

is this helpful?

Aufnahme_2017_05_17_14_11_13_10.gif

PrashantSangle

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.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂