Source Control made simple

    Source Control on QlikView.

    Like all projects working solo is not a norm and source control is a critical part of this collaboration working optimally. When it comes to QlikView most of the dev work is done by one person making Source Control a topic that is dwelled upon a lot.

    We will look at setting up and using TFS in QlikView.


    Requirements

    • Visual Studio (not earlier than 2013 since ‘Microsoft Visual Studio Team Foundation Server MSSCCI Provider is only available till 2013’)
    • Microsoft Visual Studio Team Foundation Server MSSCCI Provider
    • TFS Server or Visual Studio Cloud Server.

     

    Setting it up

    1. Set up your Visual Studio cloud server, ignore if you have TFS server.
    2. Goto https://www.visualstudio.com/
    3. Then follow “Free Visual Studio” link
    4. Click Free Account just below “Visual Studio Team Services”.
    5. Login with your Microsoft details (Email login details).
    6. Give a name for your host and where you will host all your projects.
    7. Click “Team Foundation Version Control” for managing your code then click continue. (e.g. entelect.visualstudio.com)
    8. Create your first project.
    9. Install “Microsoft Visual Studio Team Foundation Server MSSCCI Provider” same version with your visual studio.

    https://marketplace.visualstudio.com/items?itemName=TFSPowerToolsTeam.MicrosoftVisualStudioTeamFoundationServer20132015M

    1. Open QlikView:
    2. go to file -> source control -> settings
    3. under the drop down select “QlikView MSSCCI Provider *32
    4. Click settings and follow path to “C:\Program Files (x86)\Microsoft Team Foundation Server MSSCCI Provider” then select “TfsMsscciProvider.dll
    5. Open QVW you are working together on.
    6. Go to File ->source control -> Add project to source control
    7. Click “Servers” then “Add
    8. Team Foundation Server name is your hostname, in our case it is.
      (entelect.visualstudio.com)
    9. Put in your login details.
    10. Go to the directory where you want to store your source control files.
    11. Name the file name of your source control then click OK
    12. Check in it will check in everything.

     

     

    Using Source control

    1. With the other person, they will have to do steps 2 and 3
    2. They should go to file -> source control -> get project from source control
    3. Add your server
    4. Go to the folder where you stored your project. The file always has PRJ at the end.
    5. Set a local path where you will direct it to save your QVW file after compiling it. Click Ok and you have their version.

     

    Features

    1. Get Latest Version to get an updated version given whoever was working on it and checked it in
    2. Check in Pending Changes to check in the changes you have made on the model.
    3. Undo Pending Changes to undo changes that you made to the model.
    4. Roll Back only can be done in visual studio
    5. Open visual studio
    6. Go to Team and connect Team Foundation service
    7. Add the Server and connect
    8. Go to view -> other windows -> source control explorer
    9. Go to the directory where you saved your project.
    10. On each XML file, you can roll back individually.
    11. Right-click on the XML file you want to roll back
    12. Click rollback and follow directions.

     

    For a more detailed download the PDF below.

    Download1