schedule/automate the data reload

[#1]

Hi All,

Can anyone help me to schedule/automate the data reload in qlikview document. If you can give me answer i have some other doubt once you clear this.

[dasilva]

Hi!

I assume that you don't have a QlikView Server/Publisher??

Then I'd recommend you to create a cmd-file, something like :

"D:\Program Files (x86)\QlikView\Qv.exe" /r "D:\QlikView Server Documents\Private Data\Data\qvd\QVDLoader.qvw"

and create a scheduled task in Windows task scheduler that triggers your cmd file

Good luck!

[#3]

Just to repeat Ulrika the script I previously used was

cd c:\
cd Program Files\QlikView\
Qv.exe /r C:\Qlikview\FileName.qvw

and then use a scheduled task to run this.

I would suggest for performance that you use the free version of Publisher 8.50. The free version does not give you all the functionality as the full version but it is very good for document management such as refreshing.

[#4]

Hi Ulrika!

Thanks for your reply! Yes you are correct. I don't have either Server/Publisher. Thankful to you if you can explain me how to create the cmd-file and other rest of the things. Step by step solution will be lot better. Waiting for you reply!

[#5]

Hi Carneyfm,

Thanks for you reply. I used your idea to open qlikview application and then open the required document and also reload happened automatically. Let me how to schedule this task.

Also it asks for userid and password when it opens up the document as that document need userid and password to open it. Is there is any other way to reload the data into qlikview document with opening the application. As document which require useirid and password to open will always require someone to enter the userid and password to load the data.

More help will be appreciated!

[#6]

Open a notepad file and save the following script

cd c:\
cd Program Files\QlikView\
Qv.exe /r C:\Qlikview\FileName.qvw

Select File----Save As--- Give it a Name with extension .bat and save it in the location C:\Qlikview

How to create a scheduled task http://support.microsoft.com/kb/308569

To avoid being prompted for a user id and password on the document select

Settings ---- Document Properties ---- tab Opening --- uncheck strict exclusion and Prohibit Binary Load

I assume you are using section access for security, if so ten look at the following link http://community.qlik.com/forums/t/22614.aspx

I have switched to user the free publisher download to loading my documents (as discussed above) so I am afraid I cannot help you anymore with this as I have never passed and username and password through a scheduled task in qlikview.

[pkelly]

Hi

Can you please post the link to download the free version of publisher?

[#8]

Open a notepad file and save the following script

cd c:\
cd Program Files\QlikView\
Qv.exe /r C:\Qlikview\FileName.qvw --> This is done. As per my system document i have written like this.

cd c:\
cd Program Files\QlikView\
Qv.exe /r E:Qlikview\Application\VPDPL\VPDPL.qvw

Select File----Save As--- Give it a Name with extension .bat and save it in the location C:\Qlikview --> Saved it in C:\Program Files\QlikView\Schedule.bat.

How to create a scheduled task http://support.microsoft.com/kb/308569.

--> I have scheduled it as per windows task. But it is able to open only the command prompt and not the one which i have wrote. I mean script which i wrote in the cmd prompt has not being executed.It just had opened the command prompt like this.

Also when i do this manually in the cmp prompt. It works fine. It automatically opens the qlikview document. After entering the userid and password it loads the data then document gets closed automatically. How it is getting closed automatically. We didn't such things in the script. Then how it is getting closed automatically.

To avoid being prompted for a user id and password on the document select

Settings ---- Document Properties ---- tab Opening --- uncheck strict exclusion and Prohibit Binary Load --> This i will later on. Lets the document opens up first.

I assume you are using section access for security, if so ten look at the following link http://community.qlik.com/forums/t/22614.aspx

--> This also i will later on. Lets the document opens up first.

I have switched to user the free publisher download to loading my documents (as discussed above) so I am afraid I cannot help you anymore with this as I have never passed and username and password through a scheduled task in qlikview. --> Send me the link to download free server/publisher.

Thanks in advance. Hope i will get the answer very soon.

[Miguel_Angel_Baeyens]

Hello,

In your Schedule.bat file, quote the path to QlikView folder, as it contains spaces.

cd "Program Files\QlikView\"

It will work now.

As far as downloads concerns, the publisher is available in english in the download link in the top of the page or here.

[#10]

Hi Miguel A. Baeyens

I didn't get you. Can you modify which i wrote in cmd prompt? It will be easy for me to understand. My doubt is when it can work while doing manually why it is not getting executed in the scheduled task. Please help me out. Below is the screen shot of my script.