How to enable users to Reload data from time to time from the QV Acces Point?

[#1]

Hi all,

I have a case where a user can enter, for example, a foreign currency exchange rate to recalculate initialy calculated amounts. It is possible to reload it only from the QV application but not from the QV Access Point. I've tried to add a Button but was not able to find a proper action.

Maybe I can add macro, but have never worked with it.

Any idea is appreciated.

Thanks,

Nenad

[Miguel_Angel_Baeyens]

Hi Nenad,

Reload (and some other actions) are not allowed in a server environment. But you can work this around creating a BAT file that triggers the reload using the /r parameter to the command line:

"C:\Program Files\QlikView\qv.exe" /r "D:\Data\QlikView\Files\Document.qvw"

and give users permissions to run this BAT file.

Note that all users in the local group QlikView Administrators have access to the console (and not necessarily a license) so they can run a reload upon request.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[vgutkovsky]

In addition to what Miguel said, I've also occasionally used EDX to accomplish this (and then creating a button in the front end to trigger the EDX). This will only work if you're using the IE Plugin though.

Regards,

Vlad

[#4]

Thank Miguel. I've tried this workaround and further more I've tried to Launch the batch file from within QV document as an Action attached to a Button on the presentation layer. As we use the QV Access Point I was not able to make it work as I got an error "Failed to launch path\xy.bat".

How did you enable users to run this batch file?

Thx,

Nenad

[#5]

Hi Vlad,

as you could see from my answer to Miguel I tried something basic using an ordinary batch file but no luck for now. What is EDX and how/where I can find/use it? Is it possible to use it from the Access Point and IE Plugin?

Thx,

Nenad

[Miguel_Angel_Baeyens]

Hi,

Assuming you are using Windows, create a shortcut in the user's folder, or let the user run the batch file wherever it is stored, at least, that was my intention. You will not be able to launch it within the document.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[vgutkovsky]

Nenad,

See the attached code. You would need to change the variables at the top. Please also keep in mind the instructions at the very top of the file. You would then just associate a button with this macro.

Regards,

Vlad

[bnichol]

Vlad,

Thanks for your post.

It is exactly what I was looking for...  An excellent solution.

B

[doplear01]

I use this script but im getting the error "NoEDXTriggerFound"  what would be the error?

The script say

' Set "Server Performs Refresh Automatically Without Client Action" in Document Properties 

how can i configure this option?

[#10]

Hi

Miguel Angel, I'm trying to running a batch that contains this command

"C:\Program Files\QlikView\qv.exe" /r "D:\Data\QlikView\Files\Document.qvw"

The batch is called from another program and when I run the batch QV.exe remains in hang and doesn't reload the data on the server. Which is the best way to do that without using EDX trigger?

Thanks

Oronzo