Automating Load process

[#1]

Hi All,

Getting back on QlikView community after a year.

I am trying to automate the load process and would anyone please help me with the following scenario?

I have two QVWs

1. CreateQVDs.qvw and 2. MainApp.qvw

The CreateQVDs.qvw created 4 large qvds (each 2Gig)  and a 1 very tiny file that identifies the process completion

YYYYMMDD_FILE_01.qvd

YYYYMMDD_FILE_02.qvd

YYYYMMDD_FILE_03.qvd

YYYYMMDD_FILE_04.qvd

YYYYMMDD_Z_COMPLETE.qvd

The "MainApp.qvw" is the main application (2.5 GB), which is reads the QVDs and does tons of calculations.

This process takes approximately 6 hrs on my workstation. (i7 quad core 16GB)

Now the process is completely manual and I have to maintain these files including deletes.

What I would like to do is

1.Kick off the load process for CreateQVDs.qvw  at 12:15 AM Automatically - server schedulling

2. if there is a files by name YYYYMMDD_Z_COMPLETE.qvd , Start the load process for MainApp.qvw Automatically

3. Once the load is complete delete all the qvds in the load folder except QVDs for 5th of everymonth and today's

     Ex. Keep YYYYMM05_*.qvd and 20120816_*.qvd

If anyone has a better idea please post that.

Thanks in advance,

AP.

[#2 · Accepted solution]

Hi Aji:

First of all you need not have flat file to identify that first job is complete. You can have the second QVW reload when first is complete. Having said that if you dont need the old QVD's, in the first app  just save the qvd's with same name as they are before. This would replace the files and avioding the need to delete them.

If there is any particular reason to save qvd's and then delete them, you can use command prompt to executue the reload and delete files.

"C:\Program Files\QlikView\Qv.exe" -r "D:\Qlikview\Project\CreateQVDs.qvw"

"C:\Program Files\QlikView\Qv.exe" -r "D:\Qlikview\Project\MainApp.qvw"

Del *.qvd;

Kiran.

[#3]

You can use dependency (i,e) Refresh the second qvw when the first one is complete! Rest I will get back to you once you answer for Kiran

[#4]

Kiran, Thanks for the quick reply!

The reason I would like to keep the qvds are

1. Few times we had to go back and research for some account specific statuses

2. Easy back up

BTW you mentioned about the loadscript from command prompt how do I automate it?

Thanks,

Aji.

[#5]

Open a notepad and type the above code for reload. Save the file as "reload.bat". You can use windows scheduler to execute it on periodic basis. You can add CMD prompt commads to delete files.

Kiran.

[#6]

Thanks Kiran

We have qvs on the server. We do not have the desktop installed on server. Can we use qvs to load the files?

Or do we need to have Desktop installed on server?

BTW I am new to qlikview and haven't had the formal training yet. Trying to learn as much as I can 🙂

[#7]

Yes. In this case you need to have desktop client on the server.

Kiran.

[#8]

Thanks Kiran. Appreciate your help!

[#9]

Would you please provide some light on dependency?