Power Tools for QlikView

[StefanBackstrand]

Dear Community members!

On Monday, November 7th, the Power Tools for QlikView is released to the general public!

This is the main thread to discuss the Power Tools, share ideas and report bugs. It will work as an interim solution until we get the Power Tools section up and running.

We will update this thread with all necessary information as soon as the package is released, so stay tuned!

Best regards,

The Power (Tools) team

[StefanBackstrand]

rgluzman: About running QMSAPI via command line.. the QMS API Client it's not really meant to automate your API calls, it's meant to help you explore, test and verify API calls. Therefor no command line version exists. Another reason for that is that making command line support for a tool this dynamic is nearly impossible.

[StefanBackstrand]

In another note though, we will release an EDX command line tool in relation to the QlikView 11 release, so stay tuned for that. It is not a part of the Power Tools (yet), but we'll see.

That tool will help you both trigger EDX tasks via QMS API from command line, and also help you return statuses and so on.

[#4]

Christer,

You need to execute the application including the parameters surrounded by the quotes as it's the complete parameter to cmd.exe. Like this... notice the quotation.

EXECUTE cmd /c "D:\QlikView Storage\Private Data\Cmd Files\Power Tools\qv-user-manager.exe --list cal > cals.csv";

I would however recommend to put the command(s) in a batch file and execute the batch file instead. If you download the binary package from the GitHub link in the README file it will include an example app and batch file.

[Stefan_Walther]

I absolutely agree!

I'd prefer if these tools would be based on some general APIs which are open and documented.

This would it make easier to

• understand what's going on in these tools and
• expand these tools

So the community of all QlikView developers would be able to give more feedback on required enhancements and further power tools ...

What do you think?

Regards
Stefan

[#6]

Hello,

Thank you very much Stefan

Régis

De : Stefan Bäckstrand

Envoyé : mardi 22 novembre 2011 08:46

À : Régis GLUZMAN

Objet : - Re: Power Tools for QlikView

QlikCommunity <http://community.qlik.com/index.jspa>

Re: Power Tools for QlikView

created by Stefan Bäckstrand <http://community.qlik.com/people/sbn> in Deployment and Management (Server/Publisher/AJAX/IE/Web Parts) - View the full discussion <http://community.qlik.com/message/166980#166980

[StefanBackstrand]

Stefan: As I said, it is something that will need to be discussed. Making all tools open source requires that we have ways to handle and nurture the feedback from the field, like deciding how we handle contributions to the source, as well.

Stefan Bäckstrand

Senior Technical Expert, PM

Email: Support@qlik.com<mailto:Support@qlik.com>

qlik.com<http://www.qlik.com/>

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

[#8]

cmd.exe

EXECUTE

C:\PowerTools\qv-user-manager\qv-user-manager.exe  --list=CAL

error:没有终结点在侦听可以接收信息的http://sesth-rfn1:4799/QMS/Service。通常是由于不正确的地址或者SOAP操作导致的。

please help me！thanks

[#9]

cmd.exe

EXECUTE

C:\PowerTools\qv-user-manager\qv-user-manager.exe  --list=CAL

error:没有终结点在侦听可以接收信息的http://sesth-rfn1:4799/QMS/Service。通常是由于不正确的地址或者SOAP操作导致的。

please help me！thanks

[#10]

lixiaowei,

This text below is from the documentation... you need to change the server address.

Configuration

Add the user that is executing the tool to the "QlikView Management API" Windows group. This group does not exist by default and must be created. Restart the computer or log out and back in again to let Windows update the groups.

Change the line below in qv-user-manager.exe.config file to reflect the server address of your QlikView Management Service.

<endpoint address="http://sesth-rfn1:4799/QMS/Service" binding="basicHttpBinding"bindingConfiguration="BasicHttpBinding_IQMSBackend" contract="QMSBackendService.IQMSBackend"name="BasicHttpBinding_IQMSBackend" behaviorConfiguration="ServiceKeyEndpointBehavior" />

[cva1962]

Thanks Rikard

That just made it perfect...but I also changed it to a bat file...so it work even better.

I have combined this with the script fetching AD info from the tool "QV10SystemMonitor.qvw" so now I have a updated user list with latest usage and from what department etc, totally automated every morning.

And then I also have added the possibillity to run it on demand with a "little button".

THIS IS GREAT!!!