Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Just a little integration problem:
Because the qvb.exe-process doesn't apply the contents of a prj-folder to a qvw we have worked around this problem by creatign a little helper app which opens the app via macro, hereby applies all the changes from the prj-folder reduces and saves it. After this the "normal" reload job does the reload and distributes the app to the users. Problem is now that this helper app now consumes a named CAL because it opens the real app (but only for some seconds) on the server.
Is there another way to get around this problem (with SVN and without consuming a CAL)? And does anyone know if there is a feature request for qvb.exe to apply contents from the prj-folder to the qvw-files? (@Qliktech: if not, please think of qvb.exe to not ignore the contents of a prj-folder...)
regards,
Edgar
Hi Edgar,
Unfortunatelly I don't have an anwser for you but I am encountering the same issue as per loading the .qvw from the -prj folder automatically from script.
Would you be open to sharing your solution for solving this problem?
I am able to create and open the .qvw but not reducing it and saving it. I am not a Windows guy so I could be missing something easy to do.
Thanks a lot,
Seb
HI Edgar ,
As per my knowledge i can suggest you to use VB Script Batch file .
By this Batch file you can open the Qlikview document and then Save it to reflect the changes which are checked in via SVN .
So you have to write some code in VB language in the batch file .
There is no need to run macro via another app .
Please let me know if there is anything .
Thanks
Hi Yusuf,
I am new to programming in VB.
I am trying to create a vbs that would load the data from a -prj folder into the corresponding .qvw file.
I found out about VB functions that allow me to open up a .qvw after creating it and then saving it and finally closing it:
Set Qv = CreateObject("QlikTech.QlikView")
Qv.Launch qvPath, qvwFile
Set docObj = qv.OpenDoc(qvwFile)
socObj.Save
docObj.CloseDoc
--> where qvPath is pointing to my QlikView.exe and qvwFile poiting to my .qvw script.
I am not sure about where these functions are coming from and what would be the list of functions I could use to do further operations on my .qvw scrips through vbs.
When I execute a similar script to the one above I am having a couple of issues:
Would you happen to know what is happening when executig this script and what is to be done in order to make it work?
Thanks a lot,
-Seb
HI ,
Can you please try the below code
Set Qv = CreateObject("QlikTech.QlikView")
Qv.Launch qvPath /r , qvwFile
Thanks
Hi,
Thanks Yusuf for your anwser! Sorry for anwsering with such a delay.
What I have done in my VB script is the following (this is only a part of it):
Set Qv = CreateObject("QlikTech.QlikView")
'Creating empty qvwFile
Set docObj = Qv.CreateDoc
docObj.SaveAs qvwFile
docObj.CloseDoc
' Loading the created qvw with the -prj content
Set docObj2 = Qv.OpenDoc(qvwFile)
docObj2.Save
docObj2.CloseDoc
This works very well when logged on directly to the Windows server machine or when connected through RDP to this server.
However I would like to integrate my script in Jenkins (http://jenkins-ci.org/) and be able to run it on the Windows machine which is a slave of Jenkins.
The problem here is that Jenkins uses a SSH connection to the Windows machine and the VB script requires Qlikview user interface in order to run the above piece of code.
Is there a way to add an option to the above piece of code in order to make it run as batch and not rely on UI? Or any other way to run Qlikview as batch and assemble the -prj folders to qvw exclusively in a batch way?
Thanks a lot,
-Seb
did you succeed in performing CI using Jenkins? I am also seeking for doing it, that is after each commit to SVN autocreating QVW files from PRJ sources...
Thanks
Ferran.
Hi Edgar,
would you have please a document that explain SVN versioning ?
best regards
chris