Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amirkachlon
New Contributor III

Import Number of CALS Allocated to document

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

ss.PNG

1 Solution

Accepted Solutions
flipside
Valued Contributor II

Re: Import Number of CALS Allocated to document

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

6 Replies
datanibbler
Esteemed Contributor

Re: Import Number of CALS Allocated to document

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
Valued Contributor II

Re: Import Number of CALS Allocated to document

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
New Contributor III

Re: Import Number of CALS Allocated to document

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
Valued Contributor II

Re: Import Number of CALS Allocated to document

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
New Contributor III

Re: Import Number of CALS Allocated to document

cmd line will be much better

flipside
Valued Contributor II

Re: Import Number of CALS Allocated to document

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.

Community Browser