Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Get Bookmark Report from all your DocInternals.xml (fields and values)

Employee
Employee

Get Bookmark Report from all your DocInternals.xml (fields and values)

For those who want to get an overview on all the document bookmarks from all the QVW files in your environment, this tool will be very helpful.

  • It requires that you create "-prj" Folders for such QVW, which should be reported.
  • It flattens the field selections of the bookmark into a central QVW and also per project into a file "~BookmarkReport.txt" (optional)
  • It can scan multiple folder structures (configurable) and concatenate the results

Set the folders which you like to scan (multiple values separated by new-line) and then re-run script.

Enjoy

Christof

Clipboard01.png

How It Works?

The entire information of a QVW-file's bookmark (field, values, settings) is found in a XML tree structure within DocInternals.xml file of the -prj folder.

( If you don't have a -prj Folder yet, simply create it under the same location where the QVW is placed and give it the same name as the qvw but with "-prj" instead of ".qvw". The next time you open and save the QVW with QlikView Developer Client the -prj folder will be populated with a number of .xml and .txt files. )

Some tricks have been used to convert the bookmark infos into a flat table:

  • Field selections in alternate states are in a different XML branch than field selections in the main state
  • Numeric values are in 64-bit Hex, not directly readable; there was no built-in function to convert it and I learned in this community how to decode this http://community.qlik.com/docs/DOC-4388
  • Text constants, number constants or formulas used to select field values are stored in different places. Those are merged into one column in the report; --> so nevermind if you put 2014 or "Europe" or "AT\*" or "=LEFT(Category,1)='2'" ... this will be in the column "FieldValue" of the report

See attached file ~BookmarkReport.txt to see what you will get (It will be put into each -prj folder separately, but the QVW has the full picture of all project folders)

Attachments
Version history
Revision #:
1 of 1
Last update:
‎05-27-2014 09:35 AM
Updated by: