topic schedule/automate the data reload in QlikView

schedule/automate the data reload

Tue, 22 Dec 2009 19:16:19 GMT

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.

schedule/automate the data reload

dasilva — Tue, 22 Dec 2009 21:52:13 GMT

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!

schedule/automate the data reload

Tue, 22 Dec 2009 22:01:37 GMT

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.

schedule/automate the data reload

Wed, 23 Dec 2009 13:55:24 GMT

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!

schedule/automate the data reload

Wed, 23 Dec 2009 14:31:02 GMT

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!

schedule/automate the data reload

Wed, 23 Dec 2009 17:11:44 GMT

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.

schedule/automate the data reload

pkelly — Wed, 23 Dec 2009 18:29:53 GMT

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

schedule/automate the data reload

Wed, 23 Dec 2009 19:34:21 GMT

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.

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

schedule/automate the data reload

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 19:51:04 GMT

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.

schedule/automate the data reload

Wed, 23 Dec 2009 20:03:33 GMT

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.

schedule/automate the data reload

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 20:10:53 GMT

Your schedule.bat file should look like this:

cd c:\cd "Program Files\Qlikview\"qv.exe /r E:Qlikview\Application\VPDPL\VPDPL.qvw

schedule/automate the data reload

Wed, 23 Dec 2009 22:38:02 GMT

Hi Migueal!

I tried you method and it works fine. By may i know why below script which worked when executed manually but not worked when executed using scheduled tasks.

cd c:\
cd "Program Files\Qlikview\"
qv.exe /r E:Qlikview\Application\VPDPL\VPDPL.qvw

schedule/automate the data reload

Miguel_Angel_Baeyens — Wed, 23 Dec 2009 23:51:09 GMT

Hello,


dsjain wrote:<blockquote><pre>cd c:\cd "Program Files\Qlikview\"qv.exe /r E:\Qlikview\Application\VPDPL\VPDPL.qvw

You are missing a backslash in the code you have copied. Anyway, try something like

cd "\Program Files\QlikView\"pauseQv.exe /r "C:\Document.qvw"pause

So you can check where the script fails. In the code above, document reloads correctly.

Regards.

schedule/automate the data reload

Thu, 24 Dec 2009 11:54:47 GMT

Hi Miguel!

I am really sorry. I have wrongly copied the script in my previous post. Below mentioned script works fine.

cd c:\
cd "Program Files\Qlikview\"
qv.exe /r E:Qlikview\Application\VPDPL\VPDPL.qvw

Where as script which works manually but doesn't work when we schedule it. May i know the reason why?

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

schedule/automate the data reload

Miguel_Angel_Baeyens — Thu, 24 Dec 2009 15:12:15 GMT

I'm using Windows XP SP3. The script in my previous post works properly both in scheduled tasks or manually. You are missing again quotes where you have spaces in the command line.

In your post, there are two scripts. In the above one, you have quoted properly

cd "Program Files\Qlikview\"

however in your below script is unquoted.

Again, the script in my case works properly both ways.

schedule/automate the data reload

Thu, 24 Dec 2009 16:58:55 GMT

Hi Miguel!

I think you are confused. It true that this script cd "Program Files\Qlikview\" working fine both manually as well as scheduled. What my doubt was this script cd Program Files\QlikView\ which worked manually but it did not worked when it was scheduled?

Thanks in advance!

schedule/automate the data reload

Miguel_Angel_Baeyens — Thu, 24 Dec 2009 17:45:10 GMT

All right, Microsoft will answer you better than me here.