Build QlikView Project from Source Control

[#1]

I am doing research into QlikView's ability to interact with Source Control in QlikView 11.  One thing we would need to be able to do is create the qvw from a build process.  Is the only way to create the qvw from Source Control the "Get Project from Source" function in the developer client, or is there an API that can perform this function?

[rwunderlich · Accepted solution]

You should be able to do it in a build by lauching a script like this:

Set Qv = CreateObject("QlikTech.QlikView")

Set docObj = Qv.CreateDoc

docObj.SaveAs qvwFullPath

docObj.CloseDoc

Set docObj = Qv.OpenDocEx (qvwFullPath,0,false)

docObj.Save

docObj.CloseDoc

Qv.Quit

-Rob

[#3]

Hi Rob,

                Do i need to write this script in .Bat file?

[magavi_framsteg]

No, it is VBscript.

You can also do it in PowerShell if needed.

If using VBscript, just copy Robs snippet to a file called "MyFile.vbs".

[#5]

yes by that snippet i am able to create a QVW file.. but how to load the data to QVW using VBScript...

[magavi_framsteg]

Hi again.

QVW:s get populated from -prj when opened.

In the script snippet, it is this line which does it:

Set docObj = Qv.OpenDocEx (qvwFullPath,0,false)

When it it saved, it is saved with the latest version from the -prj folder.

docObj.Save

*EDIT:

Afterwards, you can do a normal reload as you usually do it, via Publisher, batch or API (VBscript/PowerShell).

[#7]

Actually after creating QVW file .. I need to load data from external xml file similarly we select tables files and have to give file path rgt.. so i want to load that files from VBSript only... so that i can reload that from batch file..