Qlik Community

QlikView Documents

Documents for QlikView related information.

Batch file script to reload Qlikview Applications

Arjunarao
Honored Contributor 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

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.

Digvijay_Singh
Honored Contributor 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.

jaaldurgam
Valued Contributor

Found really very much interesting!

Sreeni

alexdataiq
Contributor III

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.

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

Not applicable

Can I have same source and destination location.

Thanks,

santiago_respane
Valued Contributor

Excellent contribution!

Thanks a ton!

beck110979
Valued Contributor III

very informative

thanks a lot for your sharing

Not applicable

This is a nice little trick

usamabinsadiq
New Contributor II

Thanks for sharing....

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