Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jerrysvensson
Partner - Specialist II
Partner - Specialist II

Create qvw file from -prj folder using commandline?

Hi

I would like to recreate a qvw file from the -prj folder using commandline syntax.

Any ideas?

10 Replies
marcus_sommer

I don't use these functionality (prj) but maybe it worked per vbs with creating a new qvw with an appropriate file-name and then opening (and reload?) and saving it again.

- Marcus

jerrysvensson
Partner - Specialist II
Partner - Specialist II
Author

Hi

We are doing that now but we have had problems sometimes. It is isn't good enough for production.

jerrysvensson
Partner - Specialist II
Partner - Specialist II
Author

Hi

It is Magnus Åvitsland and me that have done the setup here at my client. Running in test enviroment at the moment. But for production we need more stability.

swuehl
MVP
MVP

So it seems you already have more expertise than I can provide with you.

What are the issues you've experienced in your test environment?

jerrysvensson
Partner - Specialist II
Partner - Specialist II
Author

Perhaps, but not enough. 🙂

Different issues.

Macros sometimes.

Section access mistakes.

But basically I would like to get ride of the script that does partial reolad. It can be done, since it is possible when you do it from the integration in developer.

marcus_sommer

Maybe an additionally (sideward) step with exporting the document-layout (from the origin qvw) could be helpful if there are difficulties with the marco-modul and the load-script and section access problems might be caught with a general outsourcing from this part into include-variables which could be independent changed for the time of re-creating the qvw.

- Marcus

jerrysvensson
Partner - Specialist II
Partner - Specialist II
Author

Looking into the solution from Qlik I think they use something similar to this:

Code from Rob Wunderlich:

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

Maybe this is the best solution? Delete the qvw file, then loop all -prj folders.

swuehl
MVP
MVP

Yes, might be a good solution to use the COM API to open and save the template doc for reconstructing the QVW from -prj. I don't think there is a command line option to do the same without performing a reload, too.