Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

QVW Reload based on text file

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

7 Replies
deepakk
Valued Contributor III

QVW Reload based on text file

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







Not applicable

QVW Reload based on text file

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

Not applicable

QVW Reload based on text file

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

Not applicable

QVW Reload based on text file

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.

Not applicable

QVW Reload based on text file

Are you doing this in windows scheduler?

Not applicable

QVW Reload based on text file

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

Ramunas

Not applicable

QVW Reload based on text file

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

-Haneesh

Community Browser