Source Control for QlikView with git

What you need?

So, facing the general question of „reasons“ for lacking data quality, one of the most important thinks is transparency within the creation of the KPI’s. To reach this aim, I’ll switched to a full version control management with git to show my QlikView „customers“ from where possible „issues“ may resulting.

To reach this, I first registered myself at bitbucket – because the offer unlimited private repos for teams till 5 people. What means a perfect match for me! I although have an paid account on github, but for this „project“ bitbucket fits my needs more.

Bitbucket offers a git client „sourcetree“ that I although installed (free) and it works like charm!

Building the source to control

As we wanna track source changes, we first need to create _prj folders for all applications that we wanna manage by git. If you don’t know this folder, pls. just goolge it and you’ll find wonderfull explenations by other qlik’s that will help you to understand the contents. As I’m lazy and my QlikView Projects have more than 100’s of qvw’s. I wrote/adapted this little script to generate the _prj folders automatially:

After this, we’ll have a wonderfull set of xml’s and txt/dat within the _prj folder. And suprise, they can be tracked within source control!

Convert XLS to TXT in QlikView

As some of you might store mappings inside XLS-Files, I coded a small load script, that will convert your xls-files to txt, so changes within your mappings or intervall maps can be tracked to! Here is the code:

 Add a local „mirror“

After working in praxis, I introduced a local mirror to my qlikview work directory, that only contains the txt, xml, csv, xls files. This is much better, as all qvw and qvd files are not really needed within the source control!

To achieve this, I just wrote a small batch file to copy the relevant folders. The /XD-Parameter allows me to „skip“ predefined folders:

 

Setup basic yii2 application

As your environment should be up and running. It’s time to get your first yii2 page to live! 😉 The easiest way – and which is described perfectly here:

https://github.com/yiisoft/yii2-app-basic

As some of the details on how to setup this can change and are always the latest on the link above. I will not any details here. If you have questions about it, of course you are welcome to ask me here!

After I went through the install procedure, to ensure it’s really that simple… Here are some additional notes I have to share, as it will make life easier.

1. As version management is not only „cool“ it’s although pretty usefull! Thats why I suggest you to grep yourself an account at github (http://www.github.com). Of course their are more version control systems than github. But just as I told you in the early beginning – I’m an economist and this plattform is easy to understand, fast to setup and it supports none coders to work with a version control system super fast!

2. After you have registered your new github account, pls. make a new project called e.g. „playgroundone“, which you can use for the installation of your first yii2 basic app.

3. Before you start with the installation of yii-basic-app, clone your playground to your desktop (pls. put it into your webroot!) by using the github client software and then within the new cloned project, start the installation procedure!