topic Re: Acquire meta data from QlikView documents? in QlikView

Acquire meta data from QlikView documents?

Bimal — Fri, 20 Nov 2020 18:58:42 GMT

Question: We have an internal project to harvest meta data from multiple qvw files to retrieve information on documents, load scripts, sheets, objects, fields, expressions and reports. I can see that there are APIs that provide different levels of access, e.g. QMS SOAP API and QlikView Javascript API as described here: https://help.qlik.com/en-US/qlikview-developer/April2020/Content/QV_HelpSites/APIsAndSDKs.htm

I can see in the QMS wsdl that we can use get fields but how to identify expressions and load scripts please? I'm using Java rather than VB / .NET. Any guidance appreciated.

Re: Acquire meta data from QlikView documents?

marcus_sommer — Thu, 12 Nov 2020 13:37:28 GMT

Did you try to load the xml-metadata of the qvw's? If not just use the table-wizard to pick the qvw and choose xml as file-format.

- Marcus

Re: Acquire meta data from QlikView documents?

MichaelRobertshaw — Thu, 12 Nov 2020 13:45:29 GMT

The QMS API is SOAP-based, and enables you to inspect/maintain the QlikView deployment infrastructure but not the contents of the QlikView documents.

To see inside QlikView documents you'll need to consider the OCX API or OLE Automation using the QlikView client. There is no convenient Java API for QlikView.

https://help.qlik.com/en-US/qlikview-developer/latest/Subsystems/Automation/Content/QV_Automation/automation-introduction.htm

Re: Acquire meta data from QlikView documents?

QFabian — Thu, 12 Nov 2020 14:01:02 GMT

The best way without making code by yourself is QV Document Analyzer :

https://qlikviewcookbook.com/tools/#squelch-taas-accordion-shortcode-content-6

@rwunderlich

Re: Acquire meta data from QlikView documents?

rwunderlich — Thu, 12 Nov 2020 20:36:47 GMT

I've used com4j in the past to bridge java into the OLE Automation COM Api. It works, still requires you to run a desktop.

You can get some information reading the xml metadata in the qvw files -- some document properties, Tables, Fields, Objects and Expressions used in the Expression pane. No script or attribute expressions.

You might also consider running my free Document Analyzer tool in batch (https://qlikviewcookbook.com/2017/07/document-analyzer-batch-analysis/) to collect data and process the CSV and QVD output with a tool of your choice.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com