Re: Question: How to Reload from the Accesspoint w... - Qlik Community

Report Inappropriate Content · ‎2012-03-08

I've searched both the web and this forum for a solution on how to reload data in a application from the accesspoint. No straight forward solution did I find so my question is how to set this up? It should not include the publisher and the best solution would be if it was implemented so the user pressed a button in the application to make the document reload.

magavi_framsteg · ‎2012-03-08

Hi Ola.

> Goto QMC/QEMC

> Documents

> User Documents

> Browse to a document and choose reload schedule

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

magavi_framsteg · ‎2012-03-08

Sorry Ola.

I misread your question......

Disregard my former reply 😃

Report Inappropriate Content · ‎2012-03-13

i was asking for the same function a while ago.

At that time it was not possible in the current versions to reload data by using a button in the qv document which is displayed in the publisher.

the only option was to use a .bat or VB file on the local machine.

the file will start a remote execution on the server - not very safe if too many users have execution rights on the server.

a complete reload takes some time too, so other users might be blocked from using the qv file while reloading.

at the time, there was no option to start a partial reload from inside the .qvw by remote exec. only a bat file on the local machine.

this might have changed by now

Report Inappropriate Content · ‎2012-03-13

Ok, and how could such a .bat file look like? Do you have any good examples?

When researching on a solution I found the application called PsExec which you could use to remoteley execute a application. In this case it would be the qlikview program with the /r for reload for the specific file. The commandline for running PsExec could then be included in a .bat file that the user executes on his local PC.

Report Inappropriate Content · ‎2012-03-15

PsExec is one approach, but there is a built in Option since QV server v9 : EDX

PsExec needs FULL ADMIN RIGHTS on the Server, which should be avoided.

You can find more information in the server reference manual, which may be installed with the server.

But as usual, the reference manual has no examples which actually lead to a solution.

But there is a short Description of EDX in generall:

24 Triggering EDX Enabled Tasks
To start tasks that have an external event as trigger, the QlikView Management Service API (QMS API) must be used.
The user making the request calls must be a member of the QlikView Administrators local group or the
QlikView EDX local group. The QlikView Administrators group is set up during the installation of
QlikView Server, but the QlikView EDX group must be created manually in Computer Management.

Members of the QlikView EDX group only have the right to trigger EDX-enabled tasks.

The last part is crucial, because you dont want every user that can reload data (which should be limited anyway) to be an admin on your qv server.

The Remote Calls have come a longe way since QV9. The EDX Capability of your server greatly depends on which version you are using.

My recent test (Server v11) showed that its now possible to reload by using a button (macro) in the .qvw.

jpengiu :
File name startedx.bat
this file must contain for example:
C:\"Program Files"\QlikView\Qv.exe /NoSecurity C:\RUN_TASK_BY_EDX.qvw
in RUN_TASK_BY_EDX.qvw in Document/properties/Triggers(Eventi) OnOpen (su apertura) you set to run the macro "RunTask".

You can find more Information in this threat:

http://community.qlik.com/thread/15988

http://community.qlik.com/docs/DOC-2650 Using EDX in QlikView 11 "Using EDX in QlikView 11"

Here are only 2 Users here which have the right to reload Data by EDX.

Before that, Users had the strange idea to reload "their" reports before the first use each day - while other users were allready using these.

now there is a "reload person" in each group who uses qv, which can be contacted to reload the data.

Also, there is a texbox on each Report, that shows (aditionally to the AccessPoint Information), when the file was reloaded with new data.

='Last Reload: '&ReloadTime()

Report Inappropriate Content · ‎2012-03-21

"the best solution would be if it was implemented so the user pressed a button in the application to make the document reload."

RUN_TASK_BY_EDX.qvw does exactly this.

If this solves your Problem, please mark the question as soved and the appropriate Answer as the Solution, so other users can find it.

If your problem is not solved by this suggestion, feel free to give feedback and ask for more help.

Report Inappropriate Content · ‎2012-03-22

Hi Alexander,

I think your example is work in QV 10. But it doesn't work on QV 11 as QV 11 are not allowed to use HTTP POST anymore.

I am seeking for help on handling EDX trigger in QV11.

I have found a solution on it by using the QMS API. http://community.qlik.com/docs/DOC-2650

However, I failed to run the command through access point.

Do you have any idea?

Report Inappropriate Content · ‎2013-01-14

Hi Alexander,

I am using qlikview version 9. I tried your qvw file. But, it gave me error at

line 296 : xmlHttp.Send METHOD,

On button click, the cursor just stopped at this line.

What could be the possible reason?

Thanks,

Anju

fosuzuki · ‎2013-01-15

Anju, how are you accessing the app, via IE Plugin or AJAX?

Question: How to Reload from the Accesspoint without Publisher