Discussion Board for collaboration on QlikView Publisher.
I need your help.
I'll try to explain my situation...
Earlier we had one Qlikview server 9 and we triggered our EDX task with special macro (VB script). This macro used GET / POST method like this:
REQUEST = "<Global method=""RequestEDX"" key=""" & GetTimeLimitedRequestKey() & """>"
REQUEST = REQUEST & "<i_TaskIDOrTaskName>" & EDXTASK & "</i_TaskIDOrTaskName>"
REQUEST = REQUEST & "<i_Password>" & EDXPSWD & "</i_Password>"
REQUEST = REQUEST & "<i_VariableName /><i_VariableValueList />"
REQUEST = REQUEST & "</Global>"
' Submit request to the QDS via HTTP
Set xmlHttp = CreateObject("Microsoft.XMLHTTP")
xmlHttp.open "POST", QDS, false, Username, Password
xmlHttp.setRequestHeader "Content-Length", Len(REQUEST)
' show the response
' Load the Response into an XML object
set xml = createobject("Microsoft.XMLDOM")
xml.async = false
' Build an XSLT string to extract the TaskStartResult from the XML response
XSLT = "<xsl:stylesheet version=""1.0"""
XSLT = XSLT & " xmlns:xsl=""http://www.w3.org/1999/XSL/Transform"">"
XSLT = XSLT & "<xslutput method=""html"" omit-xml-declaration=""yes""/>"
XSLT = XSLT & "<xsl:template match=""/"">"
XSLT = XSLT & "<xsl:for-each select=""RequestEDX/RequestEDXResult"">"
XSLT = XSLT & "<xsl:value-of select=""TaskStartResult""/>"
XSLT = XSLT & "</xsl:for-each>"
XSLT = XSLT & "</xsl:template>"
XSLT = XSLT & "</xsl:stylesheet>"
' Load the XSLT into an XML object
set xsl = createobject("Microsoft.XMLDOM")
xsl.async = false
' Transform the XML result to extract the TaskStartResult
' then skip the first 40 bytes of XML Header
RESULT = xml.transformNode(xsl)
Select case RESULT
RC = 0
RC = 1
RC = 2
RC = 90
xsl = null
xml = null
xmlHttp = null
but now we upgraded to QlikView 11 and this approach doesn't support.
I know about this documentation: http://community.qlik.com/docs/DOC-2650
but there we have Visual Studio .NET project with c# programming code
and we have special EXE tool which can perform triggering.
But I can't use this EXE tool because I need perform trigger of my special EDX task from other QVW file (we use IE plugin on client side)
I can't understand how I can execute EXE tool (which exists on server side) with IE plugin.
Any applications try to execute on client side with IE plugin. So I think that I can't use this tool.
And I think that need a new macro which perform this functionality for QV11.
but I don't have very good skills in .NET scripting and I can't transform C# into VB script (for internal qlikview macro).
Moreover, I don't sure that it will be possible, but I hope
Somebody can help me?
Late response only for the benefit of others....
If you don't want to put the API code in QV module then you can create a macro that just does a command line call of the EXE tool, which would then call the EDX task.
We have the same problem, we need to reload the dada in QVW app. How to trigger EDX that use macro?
The last time I used the attached it worked. It is a VB script that you can use. I trigger it by using
cscript.exe c:\RequestEDX.vbs "test" "test"
Where the first test is the task name and the second is the Password.
You will need to remove txt from the end.
Could you please share you RequestEDX.vbs script for us? Thanks.
It should be attached to my post.
Your script is for QlikView 10, but I use QlikView 11.
Will prompt that access is denied when run RequestEDX.vbs script.
Whether we should log in with administrator? Or, we can update any setting only?
In Version 11, you need not go for vb script to run an EDX task.
you can try downloading qmsedx.exe file and it is just one line of script which you need to write to trigger a task through EDX.
Thank you for your response, do you have any solutions except use the above exe file?