How to generate qvd automatically monthly.?

[#1]

Dear all,

I have a oracle server and a qv server. I wanna use ole db to get data from oracle server.

New data generate monthly. And I want to get qvd file after the new data comes out. How to do this automatically?

I have no idea about this. Could I use command line and bat file in windows os task scheduler? If yes, what is the command in qv.

Thanks

[maneshkhottcpl]

Hi,

One way to use the batch file to create a qvd. and schedule the batch file monthly once.

[#3]

hi, How can I write this batch file? How can I use qv command in command line.

[matt_crowther · Accepted solution]

In a .bat file (Inc the ") - write in Notepad and save as .bat:

"C:\Programs\Qlikview\Qv.exe" /r "C:\My Documents\MyFile.qvw"

The first part is the path to where your Qlikview .exe is located, the '/r' is the reload and save command and the final part is the path to the .qvw you wish to reload.

As an alternative if you're running server edition or reload manually everyday is to put an It...Else statement in the load script that looks to see if today() is equal to monthend(month(today())) and if so stores out the qvds.

Hope that helps,

Matt - Visual Analytics Ltd

[suniljain]

is there any updation in previous month's data in current month.

e.d : Sales Order,Purchase Order of previous month can be change in currewnt month.

so according you have to set the procedure.

for more information just search "append" in Qlikview help . you will get more details on ETL.

[#6]

Hi Sunil,

There is no updating of previous month in current month.

[#7]

Hi Matt,

I have almost understood, but there is still sth. need to be cleared. Could you please explain me how to use comand line of qv, or any referance documents avail from you? Is there any other parameters such as /r ? Thanks.

matt.crowther wrote:
In a .bat file (Inc the ") - write in Notepad and save as .bat:
"C:\Programs\Qlikview\Qv.exe" /r "C:\My Documents\MyFile.qvw"
The first part is the path to where your Qlikview .exe is located, the '/r' is the reload and save command and the final part is the path to the .qvw you wish to reload.
As an alternative if you're running server edition or reload manually everyday is to put an It...Else statement in the load script that looks to see if today() is equal to monthend(month(today())) and if so stores out the qvds.
Hope that helps,
Matt - Visual Analytics Ltd<div></div>