Auto Reload from qvd's

[swiftfahad]

Hello Grus!

I am using Qlikview 11 with (server only). After going through different post I come to know that auto reload without server is not possible. I just wana confirm Am I right? if wrong then any body can suggest what to do to perform auto reload at the end of every month.

Though my Qlikview document is as simple as just selecting the data from oracle database and storing in qvd's. and then loading data from qvd's. No complex queries, no loops, no where clauses involved. just selecting and loading.

Can I scheduled my reload? plz guide

[tresesco]

You can create a batch file to reload your app and schedule it using windows scheduler. This works fine even on desktop. Check: Refresh qvd by batch file

[swiftfahad]

Will this work fine with user? I mean i wana give user the caution of reload. Can user load the document as per his requirement?

[tresesco]

'Automatic' and 'as per requirement' look contradictory. Could you explain your use case? Users means desktop users or browser users (deployed in server)?

[swiftfahad]

Actualy what I am doing is. I have place the qvw document on server and users are accessing it through IE.

If user required the new data to be append in qlikveiw doc. he used to email and request for data refresh and I simple reload it on my machine (because qvd's are on my local drive) and again replace the updated doc on server.

I wana know can I provide user the feasibility of refreshing the document?  or any scheduled can maintain for refreshing the document,so the process of emailing and refreshing can be avoided.

[tresesco]

I would have a shared drive in the network where the users would be asked to keep their data in proper format (may be a fixed format csv/xls..). Set your qv app in server to reload from the drive or get the files copied to server local folder (using a script may be). Schedule reload, may be (hourly or so) in the qv server. New files would be appended/refreshed in the dashboard whenever a new one is available every hour (the frequency you can decide).

You can allow users to reload app from front-end using EDX:Using EDX in QlikView 11. However, in general that's not recommended.

[swiftfahad]

idea of shared drive sounds good...but what if  qlikview is loading data from database using connecting string.?(no xls or csv)

Can we allow qlikview server to hit database using host, service or connector or dblink etc to reload qlikview doc?

[tresesco]

If your server can connect to the db server (using connection string, may be OLEDB or ODBC or anything specific) qv can reload it. If you have qv server you can schedule the reload using QMC/publisher.

[swiftfahad]

What If i have no publisher only server?

[qliksus]

You can enable the user to create a Confirmation file like (Confirmation_Username.txt) in a particular folder in the Qlikview server . Once the file is created you can run a File watcher program to look for the file named (Confimaion) and then run the Qlikview using the batch file  by this method you will run Qlikview only when its required instead of having a fixed schedule of running it every 1 hour