topic QVW Reload based on text file in QlikView

QVW Reload based on text file

Mon, 26 Jan 2026 18:19:17 GMT

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

QVW Reload based on text file

deepakk — Wed, 09 Mar 2011 11:35:02 GMT

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' )

;

len(trim(VTest)) = 0 then

exit

script;

end

QVW Reload based on text file

Wed, 09 Mar 2011 11:42:14 GMT

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

QVW Reload based on text file

Wed, 09 Mar 2011 12:52:56 GMT

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

QVW Reload based on text file

Wed, 09 Mar 2011 13:23:03 GMT

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.

QVW Reload based on text file

Wed, 09 Mar 2011 14:57:15 GMT

Are you doing this in windows scheduler?

QVW Reload based on text file

Wed, 09 Mar 2011 15:00:23 GMT

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

Ramunas

QVW Reload based on text file

Wed, 09 Mar 2011 15:11:25 GMT

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

-Haneesh