QVW Reload based on text file

[#1]

Hi,

We have to start reload of a QV document once the daily ETL load is completed. A text file will be created in QV server once the ETL jobs are completed. The QV server has to check for this file and when it is present the reload has to be started.

We do not have publisher available and so this has to be done in QV Management console. I have gone through few other discussion related to starting a reload based on external event but could not find any details. I can also find the option to reload a document on external event in the 'Reload' tab in the Management Console but no options available except password.

I hope someone should have already done this and it will be great if you van help me with this.

Thanks,

Haneesh

[deepakk]

hi haneesh,

You can have a work around on this.

Create a variable VTest in your reloading application use the below code

let VTest = filesize( 'xyz.xls' )

;

if

len(trim(VTest)) = 0 then

exit

script;

end

if

[#3]

Haneesh

In that case I prefer to use command line utility QlikviewDistributionService.exe - this is QVS reload command line utility.

example

"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="D:\QlikView\Production\Data\QVDReceipts.qvw" -out="D:\QlikView\Tasks\QVDReceipts.txt"

This utility could be used from ms sql server agent, windows scheduler or any other scheduler, therefore could be easilly synchronized with any other tasks.

Ramunas

[#4]

Thanks Ramunas.

Can you also clarify the following,

1. How this batch file should be scheduled so that this is executed once the file is available after the ETL load (the ETL jobs are run in a seperate server and a file will be saved in the QV server after the ETL job is completed)

2. Is it possible to reload multiple QV documents in a single batch file.

Thanks,

Haneesh

[#5]

See this screen shot - from qlikview server I start MS SQL ETL process on another server.

Regarding multiple Qv documents in single file - YES, its possible.

[#6]

Are you doing this in windows scheduler?

[#7]

No, this is in MS SQL Server Agent, but similar you can organize jobs in windows scheduler.

Ramunas

[#8]

ok..Thanks a lot. I will try this using Windows Scheduler

-Haneesh