topic Re: running macro for document reload in QlikView

document reload without reload button

Wed, 19 Dec 2012 09:24:53 GMT

Hello,

I want to introduce a button for reload. For this , I wrote a macro that executes the operation...'ActiveDocument.Reload'.

But, since it didn't work, I checked the boxes 'Allow macro execution on server' and 'Allow unsafe macro execution on server'.

But, even after this, its not working. Do I have to write an edx for this?

Please suggest some ideas. I use qlikview version 9.00 SR7

Thanks and Regards,

Anju

Re: running macro for document reload

pauljohansson — Wed, 19 Dec 2012 09:29:46 GMT

Hi,

See similar question:

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

Paul

Re: running macro for document reload

Wed, 19 Dec 2012 09:52:08 GMT

Hi,

I did see that.But , it says that the user must be a part of Qlikview Administrator Group.

I don't know whether this will be feasible for the client.

Thanks and Regards,

Anju.

Re: running macro for document reload

Wed, 19 Dec 2012 11:06:55 GMT

How do I add a user to the Qlikview Administrator Group or EDX Group?

Re: running macro for document reload

pauljohansson — Wed, 19 Dec 2012 12:10:56 GMT

Hi,

you find the Qlikview Administrator Group in the computer management console:

The EDX group needs to be created manually,

Paul

Re: running macro for document reload

Wed, 19 Dec 2012 12:30:23 GMT

Hi,

Thanks ! I checked it..The username I am logging in as is listed in this group..

But when i try to run a .vbs script using command cscript...it tells me that I need to be a part of this group.

Also, I created the group 'QlikView EDX'.But, it is giving me the same error.

Thanks and Regards,

Anju

Re: running macro for document reload

pauljohansson — Wed, 19 Dec 2012 12:39:38 GMT

You can confirm in the management console that the user actually is a member of the required group:

Re: running macro for document reload

Wed, 19 Dec 2012 14:38:28 GMT

Hi,

The screen shot is not clear.....I am using this.....http://localhost:4780/qemc/SystemSetup.htm#....but....there I am not able to find any tab with this option...

Thanks and Regards,

Anju

Re: running macro for document reload

pauljohansson — Wed, 19 Dec 2012 16:02:58 GMT

Click on the picture to get it clear

Re: running macro for document reload

brindlogcool — Wed, 19 Dec 2012 16:07:32 GMT

Hi,

I think the Activedocument.Reload will work only in Desktop and

It wont work if you are trying to reload from the Accesspoint.

Re: running macro for document reload

Thu, 20 Dec 2012 04:32:25 GMT

Hi,

There is no UserManagement.htm in the folder.

-Anju

Re: running macro for document reload

Thu, 20 Dec 2012 09:19:59 GMT

Hi,

Since I got stuck while trying to do it via EDX, I tried executing a batch file .

I used this:

"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="C:\QlikViewMount\RN60-ConsolidatedCostofProgrammingReport.qvw"

I think it works.

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. I have attached a screenshot showing the error.

Kindly suggest ideas.

Thanks and Regards,

Anju Gopinath

Re: running macro for document reload

Thu, 24 Jan 2013 07:23:39 GMT

Hi All,

I tried a number of methods including macro, batch file and EDX .

All of them would throw some issues when server and client were on different machines.

So, finally, we spawned a separate server side task,

and with some C# , created a dashboard with a 'Reload' button (so, it was a one time job).

On click of the button, a request would be sent to the server side task which would invoke

the batch file with report name as parameter.

And, reload was working fine !

(We had to resort to this roundabout way as we are using Qlikview version 9 and we were doubtful whether an upgrade to version 11(in which reload option is present) would not support some drilldown functionality that we had already implemented).

The contents of the batch file :

"C:\Program Files\QlikView\Publisher\Distribution Service\QlikviewDistributionService.exe" -r="C:\QlikViewMount\%1"

Additionally, listing some C# code we used..

1)Initializing :

using AxQlikOCXLib;

using QlikView;

private AxQlikOCX axQlikOCX1;

this.axQlikOCX1 = new AxQlikOCXLib.AxQlikOCX();

2) To fetch the report name :

string[] reportPath = axQlikOCX1.ActiveDocument.Name.Split('\\');

string reportName = reportPath[reportPath.Length - 1];

3) To refresh the report :

axQlikOCX1.ActiveDocument.SetClearState();

Regards,

Anju

Re: running macro for document reload

Tue, 05 Feb 2013 07:04:55 GMT

Hi Anju,

Can you provide a step by step process to the method you have specified so that it will be useful when we try. As far from my understanding i have copied the code in pink under a bat file and using lauch action i have called this bat file. But it dint work for me. I would be helpful if you provide screenshots to explain your method for applying reload button. Also please let me know wat is QlikViewMount which you have mentioned to be pasted in bat file.

Re: running macro for document reload

Mon, 11 Feb 2013 07:46:19 GMT

Hi Henry,

Place the batch file on the server.

The code under points 1,2 and 3 go into a .cs file. This, I integrated it

with our product's GUI.

Also, the button is on the dashboard and not on the qlikview report.

So, on click of the button, a server side task calls this batch file with report name as parameter.

Much of the client side configuration is specific to our product. So, I don't know if screenshots would be helpful!

But, if you are able to come up with a setup enabling you to remotely execute the batch file, the C# code would be the same.

'QlikViewMount' is the mount point on the server, where you place all the reports. You have an option to set the path if you open Qlikview Management console on the server.

Regards,

Anju

Re: running macro for document reload

Tue, 12 Feb 2013 07:06:11 GMT

Hi Henry,

A simpler option would be to create a network drive on the local that maps to the location your report is placed on the server and then execute reload.

Then , you can avoid any other coding.

Re: running macro for document reload

kaushalview — Tue, 02 Apr 2013 07:52:26 GMT

Hi ,

Anuj

Can you tell me how to integrated .cs file in qvw file.

Kindly send the application

i have same issue in my application

kindly help on urgent.

regards

Kaushal Mehta

Re: running macro for document reload

Tue, 02 Apr 2013 08:36:57 GMT

Hi Kaushal,

We used the QlikOCXLib.dll , an API provided by qlikview. I believe its licensed.

You will need a client server setup for communicating with the batch file .

Our product framework already provided that. Sorry, I cannot attach that !

If you have a remote communication setup, I could help you with the other steps.

Regards,

Anju

Re: running macro for document reload

kaushalview — Tue, 02 Apr 2013 17:12:24 GMT

Hi,

its possible to connect with skype and show me the process reload

Regards

Kaushal Mehta

Re: running macro for document reload

kaushalview — Tue, 02 Apr 2013 17:12:37 GMT

Hi,

its possible to connect with skype and show me the process reload

Regards

Kaushal Mehta