topic Re: Creating prj Folder in QlikView

Creating prj Folder

Mon, 07 Jul 2014 12:57:50 GMT

Hi Gurus,

I am trying to create a copy of a file which I am not able to open in my laptop due to limited resources. I know that I cud recreate a file from prj folder. But to create prj folder I need to open and save. That is how I create prj folders.

Is there a way to create prj folders without needing to open them ?

Please let me know your thoughts,

Thanks is Advance,

Sree

Re: Creating prj Folder

Gysbert_Wassenaar — Mon, 07 Jul 2014 13:39:58 GMT

Make a copy of the file, then open the copy from the command line with the /nodata option: "c:\program files\qlikview\qv.exe" /nodata "d:\myqvapps\copy of myapp.qvw". This will open the document without data. That way it should fit in your machines ram.

Re: Creating prj Folder

Mon, 07 Jul 2014 14:02:05 GMT

Export QlikView application (QVW) file to a PRJ folder

Create a folder named the same way as QlikView application with -PRJ as suffix, in the same folder as the QlikView application. For example if the application file is named MyApplication the project folder sould be named MyApplication-PRJ
Open the QlikView application that you want to export to a PRJ Folder.
Press Save (or Ctrl+S) to trigger the export of the application content to the PRJ folder.
Open the PRJ folder in a file explorer window to confirm the content has been exported. The folder should contain XML and TXT files corresponding to the objects and properties in the QlikView application.

NOTE1: The content will only be exported to the PRJ folder every time the QVW file is saved

NOTE2: The PRJ folder will not contain data, which also includes variable values

Recreate QlikView application (QVW) file from the PRJ folder

If the QVW still exists, rename it to something that does not match the PRJ folder name. For example add a underscore to the file name, mainly to enable reverting to the original file if required later.
Open QlikView desktop client
Create a new document
Save the document with the same name as the PRJ Folder. For example so that you get a file structure as the image below.
Close the QlikView application, without saving the document again if prompted. This triggers importing the data from the PRJ folder to the QVW file.
Reopen the QVW file to validate that the file has been restored.

Re: Creating prj Folder

Mon, 07 Jul 2014 14:03:02 GMT

Variable values are not stored in the project folder XML files, hence it is not possible to recover them if the QVW file gets deleted or corrupted.

To prevent the loss of variable values, the current variables can be exported to a QVD during application reload. The QVD can then later be used to recover the previous variable values.

Store all application variables to QVD file

The below script loads all defined variables from the AllProperties.XML file in the QlikView project (PRJ) folder. This script should be loaded along with the application linked to the PRJ folder, since the variable values are stored in that QVW file. All the variables found in the AllProperties.XML are extracted and stored into a QVD file called Variables.qvd.

To be on the safe side this script could be included all reloads, so that the variables can be restored even if the QVW file gets corrupted or deleted.

VariableNames:

LOAD Name AS VariableName

FROM [MyApplication-prj\AllProperties.xml] (XmlSimple, Table is [AllProperties/VariableProperties/VariableProperties]);

FOR i=0 TO NoOfRows('VariableNames')

LET varName = Peek('VariableName', $(i), 'VariableNames');

LET varValue = $(varName);

Variables:

LOAD

'$(varName)' AS VariableName,

'$(varValue)' AS VariableValue

AutoGenerate 1;

NEXT

STORE Variables INTO Variables.qvd (QVD);

DROP Tables VariableNames, Variables;

Restore all application variables from a QVD file

The variables stored in the QVD file in the above example can be restored by the principle below. The QVD is loaded and then the variables are picked out one by one and defined in the application. This script should only be executed on loads where the variables should be recovered.

Variables:

LOAD VariableName,

VariableValue

FROM Variables.qvd (qvd);

FOR i=0 TO NoOfRows('Variables')

LET vVar = Peek('VariableName', $(i), 'Variables');

LET vVal = Peek('VariableValue', $(i), 'Variables');

LET '$(vVar)' = '$(vVal)';

NEXT

Re: Creating prj Folder

Mon, 07 Jul 2014 14:17:37 GMT

Hi, I am unable to export the files into TEST_QVW-PRJ after saving & reload my file. I got this file from some other team and Is there any settings I need to enable ?

Re: Creating prj Folder

Tue, 08 Jul 2014 08:27:47 GMT

Thanks a lot Gysbert.

Exactly what I was looking for. It worked for me !!

Re: Creating prj Folder

KumaRan — Wed, 28 Mar 2018 06:34:23 GMT

Hi Gybsert

i am trying to create prj folder in separate drive in a same machine.its not working..Is there any solution for this?

Re: Creating prj Folder

Gysbert_Wassenaar — Wed, 28 Mar 2018 08:52:11 GMT

No, the -proj folder has to be in the same place as the .qvw document

Re: Creating prj Folder

KumaRan — Wed, 28 Mar 2018 12:05:36 GMT

Thank you Gybsert

Re: Creating prj Folder

mcrookucsd — Thu, 27 Oct 2022 06:13:18 GMT

Has anyone had an issue with saving QVW's containing Container objects using a -prj folder? Every time I do the save just hangs as a tmp file.