Re: Reloading document on QlikView Access Point - Qlik Community

shyamcharan · ‎2015-04-16

Hi Experts,

I am trying to create a reload button on the dashboard where the Users can reload the document anytime when on Access Point.

I have done bit of research and now approaching you guys with confusion. Please accept my apologies if these are already answered elsewhere and if my questions are too basic.

A few details on the environment setup we have. We have installed QlikView server on the our machines.

In my research I found that I could achieve my requirement with quite a few ways.

-EDX method

-QMS API method

-Shell Scripting or .bat file

-VB Scripting method.

I have tried Shell and VB scripting methods but nothing happens and not sure whats wrong.

Do I need to install anything apart from the QlikView server to get any methods work? I don't think I could see anything related EDX or QMS API related files or apps on my machine.

Can someone please help me finding the solution. Thanks heaps in advance.

Regards,

Shyam.

danieloberbilli · ‎2015-04-16

Also make sure that the checkboxes are ticked in Document Properties > tab Security > 'Reload' and/or 'Allow User Reload'

Anonymous · ‎2015-04-16

I used EDX according to Using EDX in QlikView 11

Worked well.

shyamcharan · ‎2015-04-16

Thanks Daniel.

Yes those options are already ticked.

To take the EDX approach do I need to have ETL tool of Visual Studio set up on the server machine?

I dont think its feasible with my end client. Please suggest.

Also, is there any other method that works without the EDX method to reload the dashboards.

Regards,

Shyam.

shyamcharan · ‎2015-04-16

Thanks Michael for the response.

What do I need to set up to get the EDX method working? Do I need to have Visual Studio and/or ETL tool?

Also, Do I need to install anything related to EDX? We are having QlikView 11.2 version server installed.

Regards,

Shyam

Anonymous · ‎2015-04-16

Shyam,

Read the document, give it a try. You certainly don't need anything like Visual Studio or another tool, everything is pretty much ready to use and well described there. Yes, you need EDX-related files, you can download them from that document as well.

Regards,

Michael

shyamcharan · ‎2015-04-16

Thanks Michael.

Sure will give a try.

The document says that I need QMS API, is it an extra installation that need to do?

Also, we do not have a publisher license will that be a problem?

Regards,

Shyam.

Anonymous · ‎2015-04-17

All the need files are right there. No installation, just copy the files in a folder you're going to use.

Publisher license... I used it, but the document says (see at the very end:

"EDX can be used without a QlikView Publisher license...".

I did not try this.

If you have more questions, I suggest to ask tle‌, who is the author of the document, he knows better.

shyamcharan · ‎2015-04-22

Hi Experts,

Finally I was able to reload the task/dashboard using the QMSEDX.exe with a combination of a batch file command as follows:

C:\QlikView\Mac\02_Code\Published\Reports\QMSEDX_CommandLine\QMSEDX.exe -task="TestQVSource.qvw" -password=edx

However, this works only on the Desktop client of Qlikview but not on the QlikView Access point.

The following the code in the QMSEDX.exe configuration file:

<?xml version="1.0" encoding="utf-8" ?>

<system.serviceModel>

<binding name="BasicHttpBinding_IQMS" closeTimeout="00:01:00"

openTimeout="00:01:00" receiveTimeout="00:10:00" sendTimeout="00:01:00"

allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"

maxBufferSize="65536" maxBufferPoolSize="524288" maxReceivedMessageSize="65536"

messageEncoding="Text" textEncoding="utf-8" transferMode="Buffered"

useDefaultWebProxy="true">

<readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384"

maxBytesPerRead="4096" maxNameTableCharCount="16384" />

<transport clientCredentialType="Ntlm" proxyCredentialType="None"

realm="" />

</security>

</binding>

<binding name="BasicHttpBinding_IQTService" closeTimeout="00:01:00"

openTimeout="00:01:00" receiveTimeout="00:10:00" sendTimeout="00:01:00"

allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"

maxBufferSize="65536" maxBufferPoolSize="524288" maxReceivedMessageSize="65536"

messageEncoding="Text" textEncoding="utf-8" transferMode="Buffered"

useDefaultWebProxy="true">

<readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384"

maxBytesPerRead="4096" maxNameTableCharCount="16384" />

<transport clientCredentialType="Ntlm" proxyCredentialType="None"

realm="" />

</security>

</binding>

</basicHttpBinding>

</bindings>

<endpoint address="http://HOSTNAME:4799/QMS/Service" binding="basicHttpBinding"

bindingConfiguration="BasicHttpBinding_IQMS" contract="QMSAPI.IQMS"

name="BasicHttpBinding_IQMS"/>

<endpoint address="http://HOSTNAME:4799/ANY/Service" binding="basicHttpBinding"

bindingConfiguration="BasicHttpBinding_IQTService" contract="QMSAPI.IQTService"

name="BasicHttpBinding_IQTService" />

</client>

</system.serviceModel>

</configuration>

Can anyone please suggest what I am doing wrong?

Thanks in advance for your help.

FYI: I do not have Publisher License, I have used the task name rather.

Regards,

Shyam.