Qlik-Script-Tools

Contents:

Indices and tables

Installation

There are two ways to get Qlik-Script-Tools. You can either: 1. Checkout Qlik-Script-Tools from github:

git checkout https://github.com/BenSimonds/Qlik-Script-Tools
  1. Install with setuptools (develop/install):

    python setup.py develop
    

Or install with Pip:

pip install Qlik-Script-Tools.

Usage:

You can start by trying subbify on a qvs script:

QVSubbify "MyScript.qvs"

Behold! Automated qvw generation! See Examples for more ways to use Qlik-Script-Tools.

Current Features

  • Block class acts as a container for a chunk of Qlik script. Blocks can be imported from plain text, or from structured xml files.
  • BlockLibrary class combines a container for a bunch of blocks as well as methods for creating, storing and manipulting blocks, as well as writing their content to qvs files.
  • QVD class allows you to read in the xml header of a qvd file, providing access to it’s metadata such as creator doc, reload date, fields, etc.
  • BlockLibary can also create blocks from QVD classes. This allows for reading in a qvd, and then writing the load script to load it into a file.
  • Batch loading of qvds from a directory can also be done.
  • Some blocks have replace lists. This allows for string replacement within a block, for example to pass variables or rename tables.
  • PRJ class has tools for reading in a prj folder, with XPath based find and replace for xml files (useful for batch editing objects).
  • Subbify tool - load in an existing qvs script, and subbify will generate a qvw file with each tab made into a separate subroutine, useful for making ETL scripts modular.
  • Logfile parsing with ability to extract qvds loaded and build a dependency graph by iterating through logfiles.

To-Do/Ideas

  • Improve dependency graph vizualisation.
  • Rescaling of qlikview documents by manipulation of object layout coordinates.