Import Number of CALS Allocated to document

[amirkachlon]

Hi all,

I need to get this number for each document on my QVC,

meaning I want to run a process that returns a list of document names and number of aloocated documents (in this case 11).

I tried this : Qlikview Server CAL Manager, and I couldnt generate this data.

Any other ideas ?

Regards,

Amir

[datanibbler]

Hi Amir,

if you search for "analyze CAL allocation" or so, there is a how-to (here in the Community) to edit an .ini file in your QlikView installation so that a CalData.pgo.xml file gets written daily (in addition to the CalData.pgo that you have already) which QlikView can read. There is an app somewhere on the Community that can read that xml file and draw all the CAL data from it.

HTH

[flipside · Accepted solution]

Hi Amir,

Using QVS CAL Manager via a command line, you can use the -documents switch to export this data to Documents.xml. The data is in field DocumentCALsAllocated.

flipside

[amirkachlon]

any script to loop all documnets and get this data from the xml file to two rows of ; delimted txt file?

will be great !!

thanks!

[flipside]

Qlikview can read in the xml file and can store it back out as a delimited flat file using something similar to below ...

STORE Data into data.ssv (txt, delimiter is ';');

flipside

[amirkachlon]

cmd line will be much better

[flipside]

I don't think there is an option to choose a different output format but I could be wrong - try posting the query on the QVS CAL Manager link.