topic Automating Load process in QlikView

Automating Load process

Thu, 16 Aug 2012 21:04:56 GMT

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.

Re: Automating Load process

Fri, 17 Aug 2012 04:00:28 GMT

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.

Re: Automating Load process

Fri, 17 Aug 2012 05:55:56 GMT

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

Re: Automating Load process

Mon, 20 Aug 2012 14:11:03 GMT

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.

Re: Automating Load process

Mon, 20 Aug 2012 14:50:42 GMT

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.

Re: Automating Load process

Mon, 20 Aug 2012 22:49:09 GMT

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 🙂

Re: Automating Load process

Tue, 21 Aug 2012 02:33:21 GMT

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

Kiran.

Re: Automating Load process

Tue, 21 Aug 2012 14:46:55 GMT

Thanks Kiran. Appreciate your help!

Re: Automating Load process

Tue, 27 Nov 2012 00:02:26 GMT

Would you please provide some light on dependency?