Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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.

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.

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


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

Creator
Creator

Hi Anatoly,

Thank you for your reply.

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

Regards,

Daniel

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

Specialist II
Specialist II

Hi Daniel

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

thanks.

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


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.