topic Trigger EDX Qlikview 10 in QlikView

Trigger EDX Qlikview 10

Tue, 01 Feb 2011 15:52:04 GMT

I used to run the trigger edx function posted by bbt (http://community.qlik.com/forums/t/18961.aspx) on Qlikview 9 perfectly.

However, I can't make it work on Qlikview 10. It stops at the command

objHttp.Send strKeyRequest

I read that the services have been merged. I am connected to http://myserver:4720/qtxs.asmx.

Any help on this topic?

Regards,

Marco

Trigger EDX Qlikview 10

Bjorn_Wedbratt — Wed, 02 Feb 2011 13:01:41 GMT

Hi Marco,
Attached is a vbs file for version 10. I cannot take credit for this, it was written by a QT collegue (thanks Michael).

You could also look into the QlikView SDK on how to use the full QMS API.

Regards,
Bjorn

Trigger EDX Qlikview 10

Wed, 09 Feb 2011 22:59:02 GMT

Thanks Bjorn! That was really helpfull!!!

I could make it run again, the Username and Password were missing... However, I had to enter a specific username and password, the null value did not work out for me.

Thanks for your help!

Marco

Trigger EDX Qlikview 10

Tue, 19 Apr 2011 16:26:48 GMT

Hi,

I have a requirement where in I have to refresh the Qlikview documents as soon as my Datawarehouse loads are completed. I am planning to use the VB script provided to call the individual tasks (tasks will be tiggered by External event)

I have used the vb script to test the same through the command line by giving teh required parameters (task name and task password). My output in command line shows nothing and document is not refreshing.

Please provide some inputs on how to use the script.

Thanks

Narasimha

Trigger EDX Qlikview 10

Tue, 19 Apr 2011 19:50:06 GMT

Hi,

I am using the same file to trigger an EDX from the command line. I am receiving the following error.

Could you please help me.

Thanks

Narasimha

Trigger EDX Qlikview 10

Jason_Michaelides — Sun, 17 Jul 2011 17:22:53 GMT

Hi,

I'm sorry to be such an idiot, but can you please explain how I run this script from a command line? I can't see where I need to enter my specific taskname etc details.

Thank you!

Jason

Trigger EDX Qlikview 10

Mon, 25 Jul 2011 14:40:36 GMT

Hi Jason,

I've been experimenting with EDX for a week or so. Here's how to run it -

Save text file attached above with a file type of .vbs
open a command prompt (Start... Run... and type cmd then enter.)
Type the following -

cscript "{Enter path to your .vbs script file here}\RequestEDX10.vbs" /t:"{Enter your full task name as it appears in QEMC here}" /p:{Enter password for task here}

Please note

The user making the EDX request must be a member of the 'QlikView Administrators' or 'QlikView EDX' groups.
If you need to specify a particular user, change the CONST USERNAME and CONST PASSWORD lines in the script (I added extra flags to the script to allow me to enter these as parameters when I called it).
Unless you specify a different url for the QlikView Distribution Service, it'll default to http://localhost:4720/qtxs.asmx so you may need to add /u:"http://{Your QV Server Name here}:4720/qtxs.asmx" to the call above.
You have to set the document to reload 'On external event' in the reload tab in QEMC.
You don't need Publisher to make an EDX request, as I thought initially.

I hope that helps get you started.

Ben

Trigger EDX Qlikview 10

Jason_Michaelides — Mon, 25 Jul 2011 14:43:46 GMT

That looks fantastic thanks Ben - I will try it asap and report back here.

Jason

Trigger EDX Qlikview 10

Anonymous — Tue, 26 Jul 2011 13:33:05 GMT

Could you please explain me how to create a button which execute this EDX request ?

Thanks.

Alex.

Trigger EDX Qlikview 10

jpengiu — Wed, 27 Jul 2011 19:10:10 GMT

On server , with cscript, all works fine. (thanks Ben)

But I don't know how create a button on client CAL for EDX request.

I think that Open url on server is the right way. Users work with IE plugin.

Help Help Help and thanks

Re: Trigger EDX Qlikview 10

jpengiu — Fri, 29 Jul 2011 07:39:52 GMT

I merge VBS script that I found in this forum.

Button work fine.

I hope that help you.

Trigger EDX Qlikview 10

jeremy_fourman — Tue, 27 Sep 2011 19:31:32 GMT

Wanted to sya thanks for posting this script, I do not know if I will use it yet but I may soon as this request just came up but thanks for sharing!

Trigger EDX Qlikview 10

Thu, 08 Dec 2011 16:30:13 GMT

Thank you for sharing this file Bjorn Wedbratt and for the detailed process thanks to Ben Thomas.

I know this sounds stupid but can you(jpengiu) tell me how can I use the QVW that you posted above? I am trying to kick off all the tasks right after our Tidal services are done with. I have managed to create the batch file to run the VBS file in turn running all the dashboards but how can this batch file be automated , I mean how can we run this batch file right after our Tidal jobs are done automatically ? Please help.

Regards,

Abha

Trigger EDX Qlikview 10

jeremy_fourman — Thu, 08 Dec 2011 16:35:48 GMT

Within your job scheduler (Tidal) after its task is complete it would execute your batch file.

Trigger EDX Qlikview 10

jpengiu — Sat, 10 Dec 2011 17:32:59 GMT

I'm Italian and now I'm on holiday and not in office.

I think it's possible.

If you create a window batch file like this:

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".

best regards

jpengiu

Trigger EDX Qlikview 10

comunico — Mon, 12 Dec 2011 12:08:27 GMT

Hi Jpengiu your macro is very intersting, but I have a problem, when i try to run this i received the error "invalid sintax" on send method.

I don't have publisher but only server

I have changed the parameters of http:\\ and the name of task (no password) and user and password to login on server.

Can you explain better the step to run the macro? It needs configuartion in the server?

Thank You

Trigger EDX Qlikview 10

jpengiu — Mon, 12 Dec 2011 14:02:38 GMT

This is my server security setting but I don't know if they are important for EDX.

-NTFS Authorization

-Allow macro execution on server

-Allow unsafe Macro execution

-Enable server push over http.....

url = "http://servername.serverdomain.com:4720/qtxs.asmx"

The server url is the same of QlikView Enterprise Management Console/System/Setup/Distribution Services/General/Url

User must be on server in group "QlikView Administrators" and "Qlikview EDX" (on Server Windows)

Trigger EDX Qlikview 10

comunico — Mon, 12 Dec 2011 15:23:18 GMT

We have the same configuration, but in my environment the macro not run properly.

I don't understand if the error depends of parameters or method.

I try to run the macro from my client with Qlikview desktop

Trigger EDX Qlikview 10

tduarte — Thu, 22 Dec 2011 16:33:24 GMT

Hi all,

In Publisher 8.5 we could trigger the jobs with EDX and just calling a URL:

http://myserver/ControlPanel/Job/RequestEDX.aspx?JobIdOrJobName=myjob&QueueIfRunning=True&RedirectUrl=&EdxPassword=

Is this method also possible in QV10?

Thanks.

Trigger EDX Qlikview 10

Anonymous — Thu, 22 Dec 2011 19:16:10 GMT

No. That call is no longer possible in QV10.