Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Contributor III

Re: Reloading time

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
Honored Contributor II

Re: Reloading time

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

"LastReloadTimeISO"

HTH Peter

RonaldDoes
Contributor III

Re: Reloading time

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

Siva_Sankar
Honored Contributor

Re: Reloading time

Not applicable

Re: Reloading time

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
Honored Contributor

Re: Reloading time

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

Not applicable

Re: Reloading time

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
Honored Contributor

Re: Reloading time

is this helpful?

Aufnahme_2017_05_17_14_11_13_10.gif

Re: Reloading time

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.
Community Browser