Automatically reloading data

[danielnevitt]

Hi,

I am using the Qlikview Desktop version and would like to automatically reload the data files to our projects daily at 9:30am.

The files are created and saved in a folder daily (using the same file name each day).

Any help with how to do this would be much appreciated.

Thanks,

Daniel

[sparur]

you can use a QMS (QlikView Server) or if you haven't it, you could schedule a windows task. Where you can run a special command file, which will run a Qlikview desktop and reload your qvw.

[PhilippeMotillon]

You need to use the Windows Scheduler to do that.

Qlik Local does not come with an integrated scheduler.

You need to create a script that calls QlikView to  reload the data.

the line should be

QLIKVIEWPATH\qv.exe /r  abc.qvw

Hope that helps.

[danielnevitt]

Hi Philippe,

Thank you for your reply.

I don't have much experience using Windows Scheduler.  Assuming my project is called Test.qvw and is saved in the following location \\rosie\Qlikview\ProjectFiles.  How would I select that file and tell the scheduler to reload it?

Thanks,

Daniel

[sparur · Accepted solution]

Hi Daniel

you should create a command file (open Notepad.exe and save as a new file with CMD file extension, instead of txt) with one command: "C:\Program Files\QlikView\Qv.exe" /r "\\roise\Qlikview\ProjectFiles\test.qvw". Save this file with *.cmd file extension. After that you can schedule this CMD file fith windows task scheduller.

[danielnevitt]

Hi Anatoly,

Thank you for your reply.

That worked perfectly and it's solved the issue I had.

Regards,

Daniel

[danielnevitt]

Hi Anatoly,

Further to the above code for automatically reloading data, are you able to point me in the right direction to allow me to automate opening a document?

Are there notes available for other similar commands?

Thanks for your help.

Regards,

Daniel

[sparur]

Hi Daniel

What do you mean? Could you please explain more detailed?

thanks.

[danielnevitt]

Hi Anatoly,

Sorry if I wasn't clear.

I would like to open a specific file (name Swaps.qvw) and a specific tab (name Analysis >01/01/2012).

This should then be left open so that when I come login it is open on my screen.

Regards,

Daniel

[sparur]

I'm not sure that I right understand you...

As for open specific tab, you can use special Action, ehich should be assigned with OnOpen trigger.

Open document Properties -> Triggers tab -> OnOpen Even Trigger -> Add Action -> Add -> Layout -> Activate Sheet - OK -> enter your SheetID.