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
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.