Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Automatically reloading data

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


1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

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.

View solution in original post

15 Replies
Highlighted
Specialist II
Specialist II

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.

Highlighted
Partner
Partner

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.

Highlighted
Creator
Creator

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


Highlighted
Specialist II
Specialist II

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.

View solution in original post

Highlighted
Creator
Creator

Hi Anatoly,

Thank you for your reply.

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

Regards,

Daniel

Highlighted
Creator
Creator

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

Highlighted
Specialist II
Specialist II

Hi Daniel

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

thanks.

Highlighted
Creator
Creator

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


Highlighted
Specialist II
Specialist II

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.