Power Tools for QlikView - One-stop-shop

[StefanBackstrand]

This page will collect all relevant release information about Power Tools for QlikView, and will be continuously updated with each new release and with any patches that are issued. This way we hope for a more consolidated view of the Power Tools suite.

Do you have a feature request or a bug?

• Start a discussion in the QlikView Management or Deployment forums, or
• Email sbn@qlik.com

Latest release

Power Tools 1.3.2 for QlikView

Power Tools 1.3.2 for QlikView - Release Notes

Power Tools 1.3.2 for QlikView - Readme

QlikView 12 compatibility matrix

	12.0	12.1	12.2
QlikView Server Agent	Yes	Yes	Yes
QlikView Server Super Agent	Yes	Yes	Yes
QMSClient	Yes	Yes	Yes
Qv User Manager 10	Not yet	Not yet	Not yet
Qv User Manager 11	Not yet	Not yet	Not yet
QvsDetector	Yes	Yes	Yes
QvServerObjectConnector	Not yet	Not yet	Not yet
ReloadScheduleMigration	No	No	No
ServerObjectHandler	Yes	Yes	Yes
ServerObjectHandlerBatch	Yes	Yes	Yes
SharedFileRepair	Not yet	Not yet	Not yet
SharedFileViewer	Not yet	Not yet	Not yet
XMLDBViewer	Yes	Yes	Yes

Please note that this matrix only describes the compatibility with QlikView 12. It does not indicate whether or not Power Tools are officially supported, because they are not.

SharedFileViewer

Provides insight into the QlikView Server .shared files belonging to .qvw documents. The .shared file stores server data such as server/shared bookmarks, server objects (charts and objects created by a client via the server), annotations and other data that is specific to the document. The tool visualizes the content of the binary .shared file and provides options to "Repair" legacy files, as well as defrag large .shared files.

QvServerObjectConnector

A custom data connector for QlikView that much like the SharedFileViewer provides insight into .shared files, but instead allows to load data straight from .shared files into QlikView documents for analysis. The tool supports extraction of data like ownership, size and type of objects, expressions, annotations, bookmark selections (fields and values) and much more.

QlikView Server Agent

A small service utility that allows easy management of QlikView services. Also allows for quick change of credentials across multiple services at the same time.

QlikView Server Super Agent

A monitoring tool for QlikView Server, that monitors Qv services regardless of version (9+) and reports any service outage with email notifications and/or log files.

QMS API Client

A highly useful tool that gives its user the possibility to interact with the complete setup of QMS API functions in QlikView Server without typing a line of code. Visualizes data structures and enables the user to parameterize and test every function call based on their own data or data from the QMS API.

Qv User Manager

A command-line tool to list, add, remove and edit CAL and user information in a QlikView Server remotely.

QvsDetector

Scans the current subnet for other QlikView Servers and visualizes information like license, root folder, version and such. Also enables certain administrative functions.

Reload Schedule Migration Tool

A small step-by-step instruction tool that helps migrate reload schedules from non-Publisher databases in 9 to Publisher databases in 10 or 11, by manipulating the QVPR database (XML repository required) directly.

Server Object Handler

Enables listing, ownership changing and deletion of server objects in documents hosted on a QlikView Server remotely. Also allows ownership changing to be performed on a selected number of server objects matching a given name pattern.

Server Object Handler Batch

The command-line little brother of the Server Object Handler, that does all the same, but from any command prompt or batch script.

XmlDbViewer

Visualizes and enables searching in and editing of the QlikView Publisher Repository database (QVPR), when in XML format.

Shared File Repair

Uses the upgraded .shared file verify and repair functionality that was re-introduced in QlikView Server (QVS.exe) SR5, by providing a GUI to execute verify/repair operations on one or more .shared files and report the result. Note that even though the verify/repair functionality first came into QVS in 11.20 SR4, this version requires the upgraded functionality in 11.20 SR5.

Frequently Asked Questions

Q: What is a Power Tool?

A: A Power Tool is a small utility program or application that aid in performing a specific functionality or that extends QlikView functionality in some other way.

Q: When should I use a Power Tool?

A: Power Tools should be used when there is a need for functionality that is not in the QlikView product suite already, to evaluate new functionality or when administrative actions outside that is not available as part of the regular program suite might be needed.

Q: Do I need to install any of the tools?

A: No, all tools are, as of this moment, drop-to-deploy tools. Be aware that some of them require resource files outside of the executable itself, like for example configuration files or DLL files. When deploying, make sure to deploy the whole folder and its content.

Q: Do the tools require administrative privileges?

A: Some of them require this, yes. It is up to each tool and its functionality. If you are using UAC (User Account Control) security, make sure to run the tools in privileged mode (right-click and select “Run as Administrator”).

Q: Is there any documentation for the Power Tools?

A: Yes. A limited documentation for the Power Tools is included in each of the separate tools.

Q: Are the Power Tools Supported?

A: No. The Power Tools are not supported and is seen as use-as-is tools, supplied separate from the QlikView product suite. *** Qlik is not responsible for any consequences such as environmental issues, data corruption, configuration errors or unexpected behavior, resulting from the use of Power Tools. ***

Q: Where do I report bugs in the Power Tools?

A: To report a bug, please visit our QlikCommunity Discussion Forums, for example the QlikView Management or QlikView Deploymentforums or send an email to SupportServiceabilityLabs@qlik.com. Bugs will be fixed between releases of the Power Tools entirely at Qlik's discretion.

Older versions

Power Tools 1.3.1

Power Tools 1.3.1 for QlikView

Power Tools 1.3.1 for QlikView - Release Notes

Power Tools 1.3.1 for QlikView - Readme

Power Tools 1.3.0

Power Tools 1.3.0 for QlikView

Power Tools 1.3.0 for QlikView - Release Notes

Power Tools 1.3.0 for QlikView - Readme

Power Tools 1.2

Power Tools 1.2 for QlikView

Power Tools 1.2 for QlikView - Release Notes

Power Tools 1.2 for QlikView - Readme

Power Tools 1.1

Power Tools 1.1 for QlikView

Power Tools 1.1 for QlikView - Release Notes

Power Tools 1.1 for QlikView - Readme

Power Tools 1.0

Power Tools 1.0 for QlikView

Power Tools 1.0 for QlikView - Readme

[#2]

Thanks Stefan for providing the Power Tools.

Using Power Tools, we are able to identify the server object bookmarks with name "$LASTKNOWNSTATE" .

But do you know if it is possible by using QMS API to identify the bookmarks using name instead of bookmark ID (BM\****)

Our requirement is to identify the server object bookmarks with name "$LASTKNOWNSTATE"  and delete them using QMS API.

Thanks.

[kevinpintokpa]

Hi,

When I use SharedFileViewer to open a certain Shared file (that users have reported bookmark problems with), I receive this error message:

An attempt was made to move the file pointer before the beginning of the file.

Is this a sign of file corruption?

[kevinpintokpa]

SharedFileRepair seems to require .NET Framework 3.5 which is quite old now and often not installed by default on Windows servers.

Is it possible to update it to work with newer versions of the .NET Framework?  Thanks!

[StefanBackstrand]

We will look into that when we look at the Shared File Viewer, and its potential for QlikView 12.

[StefanBackstrand]

Yes, that can be a sign of the file being corrupted, in some fashion. THere's not much we can do with the file in a case like that. You should try the shared file repair in QVS.exe. It's documented for example here (12.10): https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Server/Content/QlikView%20Server/QVSRM_Cleaning...or in QlikView in the embedded documentation manual.

[peterreif]

Hi -

recently have I started to use the formidable PowerTools in connection with QlikView 12.

We do have the specific problem that we have a huge user base (>2000 users) that is pretty hard to keep under control - especially concerning access rights to reports / dashboards ("Who is allowed to see what").

Concerning the QV User Manager, I stumbled over the following behaviour:

- I get the SW to interact with the server

- I am able to feed the user manager via the "-r dms"-option with a list of names to be deleted within a text file

- the server answers that it has deleted those users from the system

- nevertheless will the users still be visible inside the QMC, so obviously, deletion failed

Any chance we see the QV User Manager fixed for QV12 pretty soon?

Best regards,

     Peter.

[StefanBackstrand]

Peter,

Please keep and eye on this thread here, Re: Removing unused (Doc)Cals using powertools, it seems to be related. I'm working on it, albeit between other things.

[Sue_Macaluso]

@StefanBackstrand it was brought to my attention that some links in this might need updating.  If this document is still relevant can you have a look.  Thank you!

[hiringel]

Hi,

Is the 1.3.2 version relevant for 11.20 version of QV, or should I get an older version?

[Brett_Bleess]

The new version is backward compatible from what I recall, be sure to take a quick read of the Release Notes once you download and extract things, that should confirm in there for you.