topic Re: PGO Files in QlikView

PGO Files

Mon, 26 Jan 2026 18:19:17 GMT

Does someone know any way to parse the pgo files into a qlikview? Thanks

PGO Files

disqr_rm — Thu, 23 Feb 2012 20:48:54 GMT

You can't. But you can surely use QMS APIs to get information you are looking for. Search QMS API here in the forum and you will find some information. Also Power Tools would allow you to export some information you might be looking for.

PGO Files

StefanBackstrand — Tue, 28 Feb 2012 08:47:10 GMT

There is a diagnostic setting in QlikView Server that allows for the PGO files to be mirrored in XML format for debugging purposes. It is named "PgoAsXmlAlso" and it's value should be "1" if enabled. You can set this in the Settings.ini file for QVS, under the "Settings 7" node in QlikView Server 10 and 11.

Re: PGO Files

disqr_rm — Tue, 28 Feb 2012 11:22:13 GMT

Interesting!!! Thanks Stefan.

What if we keep the setting active always? Any side effects or issues with keeping this setting active in production environment?

Re: PGO Files

StefanBackstrand — Tue, 28 Feb 2012 11:46:40 GMT

For data security purposes, and also performance, I would not recommend having this enabled in any environment over extended periods of time. It is a diagnostic easter-egg, not a feature.

Specifically in larger cluster environments where PGO operations needs to be instantaneous, this is very much not recommended.

Re: PGO Files

disqr_rm — Tue, 28 Feb 2012 12:03:41 GMT

Thanks Stefan.

How about reading Meta files? Any trick to that?

Re: PGO Files

deepakk — Tue, 28 Feb 2012 12:16:44 GMT

hi Stefan,

With lots of curoisty I tried the above method. but where does the xml file gets created. I am not able to find it

Deepak

Re: PGO Files

StefanBackstrand — Tue, 28 Feb 2012 12:48:44 GMT

They will be created and maintained in the QVS root - the main User Document folder for your QVS. Are you sure you created the setting correctly?

Settings.ini file example:

[Settings 7]

PGOAsXmlAlso=1

..more settings..

[Authentication]

..settings...

Re: PGO Files

StefanBackstrand — Tue, 28 Feb 2012 12:51:44 GMT

Rakesh Mehta wrote:
Thanks Stefan.
How about reading Meta files? Any trick to that?

Yes, but that has to be done with the SharedFileViewer, which is a part of the Power Tools for QlikView: http://community.qlik.com/docs/DOC-2649. Just note, that reading .meta files in this tool is kind of a "bonus", so never mind the red or pink markings on data in the file, as that does not apply to .meta files, only to .shared files.

Once you get the object list, double click IDs to see the data and venture deeper into the file.

Re: PGO Files

deepakk — Tue, 28 Feb 2012 13:03:47 GMT

Thanks Stefan

I made a mistake. I wrote PGOAsXmlAlso=1 at the end of the file. I changed it to the top and now its working fine.

Deepak

PGO Files

Tue, 28 Feb 2012 14:28:49 GMT

Thanks Stefan !

Re: PGO Files

disqr_rm — Tue, 28 Feb 2012 15:23:56 GMT

Perfect. Thank you Stefan. You're the best.

Re: PGO Files

fernando_tonial — Fri, 13 Apr 2012 01:35:59 GMT

Hi Stefan,

Very good this easter egg, but how to transform the value of the tag <LastUsed> 40E4063317FCF747 </ LastUsed> format for the Timestamp.

Best Regards,

Tonial.

PGO Files

StefanBackstrand — Thu, 03 May 2012 11:39:49 GMT

That's a good question, it doesn't look like an ordinary timestamp. I'll try and snoop around a bit on that one.

PGO Files

Bill_Britt — Thu, 03 May 2012 12:11:12 GMT

Here is another post out there where someone was questioning the data format.

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

Re: PGO Files

raz-datamind — Mon, 27 Aug 2012 09:48:21 GMT

Hi,

I have QV 10 SR5 installed.

I have changed my root folder to be a mounted one, and as result i'm left with shadows of qvw's holding CAL's which i can't unassign.

Tried to look for the PGOAsXmlAlso entry, but i can't see it.

The Problem is I have 8 other qvw's with CAL's i don't wanna loose, so I don't want to delete PGO files completely.

Does anyone have a solution?

Thanks,

Raz.

Re: PGO Files

StefanBackstrand — Mon, 27 Aug 2012 10:41:21 GMT

Add some empty dummy qvw documents with the same names (you can find them in the xml copies of the PGO files), this will make them show up in User Documents. You can then remove the Document CAL assignments from the documents in QMC and delete the documents.

Re: PGO Files

raz-datamind — Mon, 27 Aug 2012 10:53:25 GMT

Perhaps I was not clear, i've changed the root folder into a mounted one.

The root folder contained sub folders with models like:

<root>\Client1\ClientBI.qvw

<root>\Client2\ClientBI.qvw

etc'.

I wanted all this models to be under section named production so i moved the folder into mount and gave it an alias.

so now i have in the document list:

Production

Client1\ClientBI.qvw

Client2\ClientBI.qvw

etc'. which is great

but i also have

CLIENTBI.QVW

holding CAL's which i can't release.

Re: PGO Files

StefanBackstrand — Mon, 27 Aug 2012 11:02:21 GMT

The same suggestion still applies. Create a document named "Clientbi.qvw" and place in your root, and then delete CALs from this document. If you are afraid of collision, move the original good documents out of the root first.

Re: PGO Files

raz-datamind — Mon, 27 Aug 2012 11:09:43 GMT

I'm not sure i'm following:

I now have a new root folder that contains no models,

a mounted folder (the old root) that contains the models, and a list of non existence models holding up CAL's.

Do you suggests creating qvw's called Clientbi.qvw in the new root folder which wll then allow me to release the CAL's and then delete the documents?

Or do you reffer to the old root that is now a mounted folder?

Thanks for your help.