topic Re: Loading QMC Publisher data into Qlikview in QlikView

Loading QMC Publisher data into Qlikview

Anonymous — Tue, 10 Jan 2017 19:37:24 GMT

Hi folks,

Is that possible to retrieve information from QMC Publisher into Qlikview?

I have the following scenarios:

Monitoring assigned calls in order to check the "last used" column, users who have access to Qlikview, etc;

Managing documents users have access:

I do appreciate your help.

Regards,

Rubens Rodrigues

Re: Loading QMC Publisher data into Qlikview

vishsaggi — Tue, 10 Jan 2017 19:46:06 GMT

Use Governance Dashboard for more insights of the QMC server.

Re: Loading QMC Publisher data into Qlikview

krishnacbe — Tue, 10 Jan 2017 19:53:50 GMT

Hi,

You can use System Monitor tool to monitor CALS & Documents.

QlikView Application: System Monitor v5.1.23

Re: Loading QMC Publisher data into Qlikview

Anonymous — Tue, 10 Jan 2017 20:23:56 GMT

Hi Vishmarath,

I have already checked the Governance Dashboard, but it doesn't provide me the information I need.

I need to retrieve the user's assgned call list and each document my users have access to.

Tks

Rubens

Re: Loading QMC Publisher data into Qlikview

Anonymous — Tue, 10 Jan 2017 20:27:09 GMT

Hi buddy!

I've just checked the System Monitor app, and I couldn't find the information I need: "I need to retrieve the user's assgned call list and each document my users have access to.";

Is this information there?

Tks.

Rubens

Re: Loading QMC Publisher data into Qlikview

vishsaggi — Tue, 10 Jan 2017 20:40:23 GMT

Did you check the Log Details tab -> Session Log table, in the Gov Dashboard session information. You might need to tweak around the expressions to get the total cals and Last used dates. You might add additional information based on your local requirement.

Re: Loading QMC Publisher data into Qlikview

Chip_Matejowsky — Tue, 10 Jan 2017 21:52:49 GMT

Hello Rubens,

You could use the PGO as XML setting in QlikView Server to output the contents of the PGO files (particularly the CalData.pgo file which holds the information you're looking for I believe) to an XML. You could then load the XML into QlikView.

To configure:

Stop the Qlikview Server service
Edit %ProgramData%\QlikTech\QlikViewServer\Setting.ini & add PgoAsXmlAlso=1 right under [Settings 7]
Restart the Qlikview Server service

Navigate to the Root Folder and you'll see the .pgo.xml files

Hope this helps

-Chip

Re: Loading QMC Publisher data into Qlikview

Anonymous — Wed, 11 Jan 2017 18:28:22 GMT

Hi Chip,

I've tested and it worked. The XML files was generated at "C:\ProgramData\QlikTech\Documents". I have three more questions:

Is there some file that stores the user's name? I mean, the CalData.pgo.xml has the user's id, but it's possible to see the user's name on the publiser assigned calls screen.
Is the CalData.pgo.xml file updated dinamically?
What about the documents users have access. Are thei stored in some file that I could load from Qlikview?

Thank you in advance.

Rubens

Re: Loading QMC Publisher data into Qlikview

rwunderlich — Wed, 11 Jan 2017 19:31:10 GMT

This is a nice tool here:

Qlikview Server CAL Manager

-Rob

Re: Loading QMC Publisher data into Qlikview

Anonymous — Wed, 11 Jan 2017 20:25:44 GMT

Thanks Rob:

I've been receiving the following message when trying to reload the QVW file:

VX_CONNECT_ERROR: Could not connect to server: localhost

Error accessing Management Service.

Make sure you are in the 'QlikView Management API' group on the 'localhost' server! If the group doesn't exist you can create it, a logoff/login or a server restart may be required!

Detailled error:

Authorization failed for user REDERECORD\rudrodrigues, required access level is QlikView Management API

(exception: System.ServiceModel.FaultException)

CUSTOM CONNECT TO "Provider=QVSManager.exe;Server=localhost;Warnings=True;Debug=False;XUserId=UEeJBQC;XPassword=WTfGbTC;"

I suppose I have only to create the group QlikView Management API in the server and add my user in, alright?

Anoter question:

My production server is another machine. How should I enter with the server name in the variable? Is there some structured string to be observed?

Many thanks.

Rubens

Re: Loading QMC Publisher data into Qlikview

rwunderlich — Wed, 11 Jan 2017 20:36:16 GMT

Yes, the userid must be a member of the local server group "QlikView Management API".

You can just change the server name in the CONNECT string.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Loading QMC Publisher data into Qlikview

jhomulos — Wed, 07 Jun 2017 02:40:28 GMT

Is the CAL manager still available? When I try to use that link, it says I'm unauthorized.