topic Re: How to enable users to Reload data from time to time from the QV Acces Point? in QlikView

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

Tue, 04 Oct 2011 14:44:21 GMT

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

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

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 15:18:49 GMT

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

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

vgutkovsky — Tue, 04 Oct 2011 16:29:47 GMT

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

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

Wed, 05 Oct 2011 13:35:13 GMT

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

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

Wed, 05 Oct 2011 13:37:06 GMT

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

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

Miguel_Angel_Baeyens — Wed, 05 Oct 2011 17:03:21 GMT

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

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

vgutkovsky — Wed, 05 Oct 2011 18:02:25 GMT

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

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

bnichol — Tue, 01 Nov 2011 19:54:36 GMT

Vlad,

Thanks for your post.

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

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

doplear01 — Fri, 10 Feb 2012 15:10:28 GMT

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?

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

Fri, 02 Mar 2012 13:49:51 GMT

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

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

cjzimm76 — Tue, 03 Apr 2012 13:06:39 GMT

Vlad, does the EDX solution work if you don't have Publisher? Thanks.

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

bnichol — Tue, 03 Apr 2012 13:12:08 GMT

If you don't have Publisher, then the option 'External Event' appears under the 'User Documents > Reload' tab.

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

Wed, 19 Dec 2012 11:25:49 GMT

hello,

I am trying to use this. But, can you tell me how to fill these variables?

CONST USERNAME	= "" ' "domain\user"
CONST PASSWORD	= "" ' "password"
CONST EDXTASK	= "EDX Reload of QVW\Test.qvw"
CONST EDXPSWD	= "123456"
CONST QDS	= "http://tstqview01:4720/qtxs.asmx"

Here,

what is domain\user?

const password?

const edxpswd?

is const username and const password what we use to login to the server?

Thanks and Regards,

Anju Gopinath

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

Thu, 20 Dec 2012 05:06:01 GMT

Hi ,

I tried this on the desktop:

"C:\Program Files\QlikView\qv.exe" /r "D:\GvtTrunk\Server\Reports_Qlikview\RN60-ConsolidatedCostofProgrammingReport.qvw"

But, the reload did not happen though the window saying 'Script Execution in Progress' opened up..

I tried this on the server...

"C:\Program Files\QlikView\Server\qvs.exe" /r "C:\QlikViewMount\RN60-ConsolidatedCostofProgrammingReport.qvw"..

Again, nothing happened.

Kindly reply.

Thanks and Regards,

Anju

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

Thu, 20 Dec 2012 05:17:22 GMT

Hi,

I tried this script.But, nothing happens on the server.Not even the msgbox pops up.

-Anju

Sub RunTask

tp = MsgBox("Are you sure?", 1)

if tp=2 then

exit sub

end if

CONST SUCCESS = 0

CONST TASKNOTFOUND = 1

CONST TASKISALREADYRUNNING = 2

CONST NOEDXTRIGGERFOUND = 3

CONST OTHERERROR = 9

CONST WAITING = 0

CONST RUNNING = 90

CONST FINISHEDWITHWARNINGS = 91

CONST FINISHEDWITHERRORS = 92

dim xmlHttp

set xmlHttp = CreateObject("Microsoft.XMLHTTP")

set xml = createobject("Microsoft.XMLDOM")

set xmlObj = createobject("Microsoft.XMLDOM")

'***********************************************************************

' This ROWS must be modified

'***********************************************************************

url = "localhost:4780/qtxs.asmx"

doc = "RN60-ConsolidatedCostofProgrammingReport.qvw"

userID = "subexworld.org\optima.test"

pass = "rocpsgvtdice123"

'***********************************************************************

ITERATIONS=10000

DELAY=30

METHOD = "<Global method=""RequestEDX"" key=""" & GetTimeLimitedRequestKey(url, doc, userID, pass) & """>"

METHOD = METHOD & "<i_TaskIDOrTaskName>" & doc & "</i_TaskIDOrTaskName>"

METHOD = METHOD & "<i_Password>" & pass & "</i_Password>"

METHOD = METHOD & "<i_VariableName></i_VariableName><i_VariableValueList></i_VariableValueList>"

METHOD = METHOD & "</Global>"

DIM AsAt

AsAt = Now()

' Submit request to the QDS via HTTP

xmlHttp.open "POST",url,false, userID, pass

xmlHttp.setRequestHeader "Content-Type","text/xml"

xmlHttp.setRequestHeader "Content-Length", Len(METHOD)

xmlHttp.Send METHOD

select case xmlHttp.Status

case 200:

' Load the Response into an XML object

xml.async = false

xml.loadXML(xmlHttp.responseText)

' Parse the XML Response extracting Status, Log, etc

TaskStartResult = ""

set xmlObj = xml.SelectNodes("//RequestEDX/RequestEDXResult/*")

for node = 0 to (xmlObj.length -1)

select case xmlObj.item(node).nodeName

case "TaskStartResult":

TaskStartResult = xmlObj.item(node).text

select case TaskStartResult

case "Success":

TaskStartResultCode = SUCCESS

case "TaskNotFound":

TaskStartResultCode = TASKNOTFOUND

case "TaskIsAlreadyRunning":

TaskStartResultCode = TASKISALREADYRUNNING

case "NoEDXTriggerFound":

TaskStartResultCode = NOEDXTRIGGERFOUND

case "OtherError":

TaskStartResultCode = OTHERERROR

case else

TaskStartResultCode = OTHERERROR

end select 'TaskStartResult

RC = TaskStartResultCode

case "TaskStartResultCode":

select case xmlObj.item(node).text

case "0":

TaskStartResultCode = SUCCESS

case "1":

TaskStartResultCode = TASKNOTFOUND

case "2":

TaskStartResultCode = TASKISALREADYRUNNING

case "3":

TaskStartResultCode = NOEDXTRIGGERFOUND

case "9":

TaskStartResultCode = OTHERERROR

case else

TaskStartResultCode = OTHERERROR

end select 'TaskStartResultCode

RC = TaskStartResultCode

case "Log":

Message = Split( xmlObj.item(node).text, chr(9))

end select 'nodeName

next 'iteration

case 401:

msgbox "ERROR: The credentials for QDS (" & url & ") are incorrect."

exit sub

case 403:

msgbox "ERROR: User is not authorised to request EDX tasks."

exit sub

case 404:

msgbox "ERROR: The URL for QDS (" & url & ") is incorrect."

exit sub

case 503:

msgbox "ERROR: The QDS (" & url& ") is unavailable."

exit sub

case 12029:

msgbox "ERROR: The QDS (" & url & ") is not accessible."

exit sub

case else

msgbox "ERROR: An error (" & xmlHttp.Status & ") occurred trying to access the QDS."

end select 'xmlHttp

'-----------------------------------------------------------------------------

'- GetTaskStatus

'-----------------------------------------------------------------------------

i = 0

Finished = False

WAIT = true

do while (TaskStartResultCode = SUCCESS) AND (WAIT = True) AND (i < ITERATIONS) AND Finished=False

' sleep( DELAY * 1000)

METHOD = "<Global method=""GetTaskStatus"" key=""" & GetTimeLimitedRequestKey(url, doc, userID, pass) & """>"

METHOD = METHOD & "<TaskNameOrId>" & doc & "</TaskNameOrId>"

METHOD = METHOD & "</Global>"

AsAt = Now()

' Submit request to the QDS via HTTP

xmlHttp.open "POST",url,false, userID, pass

xmlHttp.setRequestHeader "Content-Type","text/xml"

xmlHttp.setRequestHeader "Content-Length", Len(METHOD)

xmlHttp.Send METHOD

select case xmlHttp.Status

case 200:

xml.async = false

xml.loadXML(xmlHttp.responseText)

set xmlObj = xml.SelectNodes("//GetTaskStatus/GetTaskStatusResult/TaskStatus/*")

for node = 0 to (xmlObj.length -1)

select case xmlObj.item(node).nodeName

case "Status":

GetTaskStatus = xmlObj.item(node).text

select case GetTaskStatus

case "Waiting":

Finished = True

RC = WAITING

Msgbox AsAt & chr(9) & "[Waiting.........]"

case "Running":

Finished = False

RC = RUNNING

Msgbox AsAt & chr(9) & "[Waiting.........]"

case "FinishedWithWarnings":

Finished = True

RC = FINISHEDWITHWARNINGS

Msgbox AsAt & chr(9) & "[" & GetTaskStatus & "]"

case "FinishedWithErrors":

Finished = True

RC = FINISHEDWITHERRORS

Msgbox AsAt & chr(9) & "[" & GetTaskStatus & "]"

case else

Finished = True

RC = OTHERERROR

Msgbox AsAt & chr(9) & "[Errore!]"

end select

case "LastLogMsg":

LastLogMsg = xmlObj.item(node).text

if ShowMessages = True then

Msgbox " "

Msgbox LastLogMsg

Msgbox " "

end if

end select 'nodeName

next 'node

case 401:

Msgbox "ERROR: The credentials for QDS (" & url & ") are incorrect."

exit sub

case 403:

Msgbox "ERROR: User is not authorised to Get Task Status....."

exit sub

case 404:

Msgbox "ERROR: The URL for QDS (" & url & ") is incorrect."

exit sub

case 503:

Msgbox "ERROR: The QDS (" & url & ") is unavailable."

exit sub

case 12029:

Msgbox "ERROR: The QDS (" & url & ") is not accessible."

exit sub

case else

Msgbox "ERROR: An error (" & xmlHttp.Status & ") occurred trying to access the QDS."

exit sub

end select

i = i + 1

Loop

xmlObj = null

xml = null

xmlHttp = null

end sub

'-----------------------------------------------------------------------------

'- GetTimeLimitedRequestKey

'-----------------------------------------------------------------------------

Function GetTimeLimitedRequestKey(dsURL, document, userID, password)

set xmlHttp = CreateObject("Microsoft.XMLHTTP")

set xml = createobject("Microsoft.XMLDOM")

set xmlObj = createobject("Microsoft.XMLDOM")

DIM METHOD '

METHOD ="<Global method=""GetTimeLimitedRequestKey"" />"

xmlHttp.open "POST",dsURL,false, userID, password

xmlHttp.setRequestHeader "Content-Type","text/xml"

xmlHttp.setRequestHeader "Content-Length", Len(METHOD)

xmlHttp.Send METHOD

select case xmlHttp.Status

case 200:

xml.async = false

xml.loadXML(xmlHttp.responseText)

set xmlObj = xml.SelectNodes("//GetTimeLimitedRequestKey")

for node = 0 to (xmlObj.length -1)

if xmlObj.item(node).nodeName = "GetTimeLimitedRequestKey" then

GetTimeLimitedRequestKey = xmlObj.item(node).text

end if

next 'node

case 401:

msgbox "ERROR: The credentials for QDS (" & dsURL & ") are incorrect."

exit function

case 403:

msgbox "ERROR: User is not authorised to interact with QDS."

exit function

case 404:

msgbox "ERROR: The URL for QDS (" & dsURL & ") is incorrect."

exit function

case 503:

msgbox "ERROR: The QDS (" & dsURL & ") is unavailable."

exit function

case 12029:

msgbox "ERROR: The QDS (" & dsURL & ") is not accessible."

exit function

case else

msgbox "ERROR: An error (" & xmlHttp.Status & ") occurred trying to access the QDS."

end select

End Function

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

Thu, 20 Dec 2012 05:42:40 GMT

Hi ,

I tried this.

"C:\Program Files\QlikView\Management Service\Qlikview Management Service.exe" /r "C:\QlikViewMount\RN60-ConsolidatedCostofProgrammingReport.qvw".

But, it gave me the following error: Please see the attached image.

-Anju

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

Thu, 20 Dec 2012 09:12:59 GMT

Hi,

I am able to reload by executing the batch file. First we need to close the .qvw file.

I tried to integrate this into a button and launch it via Internet Explorer. But, it gives me 'access denied' error.

I tried changing properties of file 'cmd.exe' by adding the user name to Security tab and granting full access to the user.

But, it still shows me the same error.

Kindly suggest ideas.

Thanks and Regards,

Anju Gopinath

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

Miguel_Angel_Baeyens — Fri, 21 Dec 2012 10:35:38 GMT

Hello Anju,

Make sure that the Security tab in the Document Properties is set up according to your needs, and that if you use some macro that needs filesystem access, this is granted in the Module Editor dialog.

Check as well Security tab in the User Preferences in the Settings menu logging on the computer with the same user that will run the CMD.exe

Hope that helps.

Miguel

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

Thu, 24 Jan 2013 07:34:28 GMT

Hi All,

This issue is fixed!.

Please see this thread!

http://community.qlik.com/message/293671#293671

Regards,

Anju

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

Thu, 24 Jan 2013 12:10:26 GMT

Hi Anju,

Looking good . I am not a C# programmer, etc.

Does this work when there is no Publisher licensed, but only QV Server? If yes, what exactly I need to do?

Thx