Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
qlikwiz123
Contributor

Schedule QVW file reload on local Windows Environment

Hi,

I would like to schedule my QVW reloads on my local machine on a timely manner (maybe using Windows Task Scheduler or any other available tool). I tried searching for appropriate topics but couldn't find them useful. How do I schedule QVW reloads on my local Windows environment using Windows Scheduler or any other Scheduler tool?

1 Solution

Accepted Solutions
rajivmeher
Contributor

Re: Schedule QVW file reload on local Windows Environment

Hi qlikwiz123

Thanks for your feedback.

Seems like you are missing the line for reload of the QVW file. Please see the code below and suggest if it matches your batch file.

"C:\Program Files\QlikView\qv.exe" /R "I:\FolderName\QVWFile.qvw"

copy "I:\FolderName\QVWFile.qvw" "I:\FolderName\"

 

Exit 


Just to give a breakdown on what this code is doing:

Line 1: Invokes Qlikview software installed in your machine from C:\Program Files\QlikView\qv.exe location (change it to the right location if its different in your machine). /R is to reload the model thats located in I:\FolderName\QVWFile.qvw location.

Line 2: copies the file from I:\FolderName\QVWFile.qvw and pastes it in I:\FolderName\ location. You don't need this line if you don't need to move the file to any other location.

Line 3: Exit: Closes the Program and the batch file.

Sorry if the explanation is too big and unnecessary.

Regards

Rajiv.

View solution in original post

5 Replies
rajivmeher
Contributor

Re: Schedule QVW file reload on local Windows Environment

Hi qlikwiz123

You can try creating a batch file to reload your QVW. Than you can create a task using WIndows Task Scheduler to run the batch file at your required time.

Please refer to the below link for detailed process on this:

Batch file script to reload Qlikview Applications

Regards

Rajiv.

qlikwiz123
Contributor

Re: Schedule QVW file reload on local Windows Environment

Hi Rajiv,

Thank you for sharing the link. I have seen it already before posting this question. The Task Triggers and opens the QVW file but doesn't actually reload the file. I am not sure why. I created the batch file that has the lines as below.

"I:\FolderName\QVWFile.qvw"

copy "I:\FolderName\QVWFile.qvw" "I:\FolderName\"

Exit


And adding this batch file as Basic Task in Windows Scheduler. Am I missing something here or anything wrong in the Batch Script?

Also tried with different Source and Destination Paths in Line 2 but nothing helps.

Any advice would be really appreciated.

rajivmeher
Contributor

Re: Schedule QVW file reload on local Windows Environment

Hi qlikwiz123

Thanks for your feedback.

Seems like you are missing the line for reload of the QVW file. Please see the code below and suggest if it matches your batch file.

"C:\Program Files\QlikView\qv.exe" /R "I:\FolderName\QVWFile.qvw"

copy "I:\FolderName\QVWFile.qvw" "I:\FolderName\"

 

Exit 


Just to give a breakdown on what this code is doing:

Line 1: Invokes Qlikview software installed in your machine from C:\Program Files\QlikView\qv.exe location (change it to the right location if its different in your machine). /R is to reload the model thats located in I:\FolderName\QVWFile.qvw location.

Line 2: copies the file from I:\FolderName\QVWFile.qvw and pastes it in I:\FolderName\ location. You don't need this line if you don't need to move the file to any other location.

Line 3: Exit: Closes the Program and the batch file.

Sorry if the explanation is too big and unnecessary.

Regards

Rajiv.

View solution in original post

qlikwiz123
Contributor

Re: Schedule QVW file reload on local Windows Environment

Thanks a lot Rajiv. The other link was missing the 'Reload' line in the batch file. This was really helpful. I really appreciate the way you explained each line

Cheers

rajivmeher
Contributor

Re: Schedule QVW file reload on local Windows Environment

Thanks qlikwiz123‌.

Glad it helped.