Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group

Batch file script to reload Qlikview Applications

Master II
Master II

Batch file script to reload Qlikview Applications

Hi Folks,

Recent days,I have seen some of them are asking on running Qlikview applications through windows scheduler in community.

Generally we follows 3 tier architecture in our project.

Assume we have 3 qvw files.

1.Raw QVD file generator (Raw_QVD_App.qvw)

2.Model QVD file generator (ModelQVD_App.qvw)

3.Qlikview Application.(QV_Application_Name.qvw)

We have QV_Application_Name.qvw file run reload the data daily in C:\QlikviewApplications\ and copy into destination folder C:\ProgramData\QlikTech\QlikView\Documents\

Here is the batch file script

"C:\Program Files\QlikView\qv.exe" /R "C:\QlikviewApplications\Raw_QVD_App.qvw"

"C:\Program Files\QlikView\qv.exe" /R "C:\QlikviewApplications\ModelQVD_App.qvw"

"C:\Program Files\QlikView\qv.exe" /R "C:\QlikviewApplications\QV_Application_Name.qvw"

copy "C:\QlikviewApplications\QV_Application_Name.qvw" "C:\ProgramData\QlikTech\QlikView\Documents\"

Exit

We can schedule by using windows task scheduler to run this batch file daily/weekly/monthly,...

Please review the script.

Best Regards,

QW

Attachments
Comments
Not applicable

Hi,

Usefull information which hasnt QV Server and Publisher.

without above many things we have missed to manage but testing purpose its fine to execute.

Regards,

Zain.

Master III
Master III

Thanks for sharing this. By any chance we can incorporate error handling in this? If first one loads successfully but not second layer one, it might cause data conflicts until we correct it. Let me know if I am missing something here.

Specialist
Specialist

Found really very much interesting!

Sreeni

0 Likes
Partner
Partner

Hi,

If you are running a Batch file, you can use the %ERRORLEVEL% variable between reloads to check if the previous task executed succesfully or not.

0 Likes
Not applicable

Thanx for the answer. If I already have a batch file which can download the data from AWS s3 browser to my system and then I want to schedule the data reload, how do I write the code for the first step , ie to call the batch file?

Step 1: Call the batch file that downloads the data from s3.

Step 2: Generate the QVDs of this data.

Step 3: Reload the QV app with these QVDs.

Please help.

Thanks

0 Likes
Not applicable

Can I have same source and destination location.

Thanks,

0 Likes
Specialist
Specialist

Excellent contribution!

Thanks a ton!

0 Likes
Master
Master

very informative

thanks a lot for your sharing

0 Likes
Not applicable

This is a nice little trick

0 Likes
Contributor III
Contributor III

Thanks for sharing....

Version history
Revision #:
1 of 1
Last update:
‎2015-07-20 01:32 AM
Updated by: