topic Re: Back up with out data in QlikView

Back up with out data

raajaswin — Wed, 21 Mar 2018 09:56:23 GMT

Hi all,

Is there any way to take back up of set of Qlik apps without data.

Limit load/ Reduce data <-- These are something which we have to manually do to reduce data. Which is very difficult when we have more number of apps.

Scenario:

Say We have 50 apps each 300 MB . So we have to back-up of all apps automatically on daily basis. Any help ??

Re: Back up with out data

Chanty4u — Wed, 21 Mar 2018 09:59:03 GMT

did you tried this option?

Re: Back up with out data

raajaswin — Wed, 21 Mar 2018 10:03:19 GMT

I want apps from Server to be copied to local.Correct me if am wrong, Use Backup option will do verisoning and save duplicate of the app with data, but I need without data

Re: Back up with out data

olivierrobin — Wed, 21 Mar 2018 10:06:41 GMT

hello

you can write a macro in a .qvw (whiwh will be reloaded automatically on the server)

which reads all .qvw, open them and save them without data in a folder

(you can take document analyser as model and modify it slightly)

Re: Back up with out data

Chanty4u — Wed, 21 Mar 2018 10:20:06 GMT

i think there is no direct way to do it.

macro im not sure.

Re: Back up with out data

olivierrobin — Wed, 21 Mar 2018 10:26:51 GMT

see :

Tools | Qlikview Cookbook

qlikview document analyzer

theres is a macro which open all .qvw to analyze them

you need to add a save() to copy the .qvw without data where you want

Re: Back up with out data

raajaswin — Wed, 21 Mar 2018 11:12:00 GMT

Ok thank you. Let me try and see in Macro

Re: Back up with out data

avinashelite — Wed, 21 Mar 2018 11:44:46 GMT

As stated earlier we don't have any direct way to achieve this without macro .....other option is to go the paid power tools

Re: Back up with out data

shmkmr90 — Thu, 22 Mar 2018 06:28:18 GMT

Hi Aswin,

When the application is huge, it will take time to open for Reducing and may consume more CPU/memory utilization (depends on the Computer config).

Execute the below command in command prompt, application will open with no time with reduced data, you just need to save it.

"C:\Program Files\QlikView\qv.exe"/nodata "D:\Test\Application_name.qvw"

change requires only at the second half (D:\Test\Application_name.qvw)

For multiple QVWs to reduce, you can try such commands with different Application names put in txt file save it as .bat. Double click the .bat file to run the commands.

Regards,

Shyam

Re: Back up with out data

raajaswin — Thu, 22 Mar 2018 06:59:21 GMT

Whats that?

Re: Back up with out data

raajaswin — Thu, 22 Mar 2018 07:05:09 GMT

yeah. This is a great first step. It opens in no time. Bt still manually we have to save all applications. Is there a way to automate it too?

Re: Back up with out data

raajaswin — Thu, 22 Mar 2018 07:53:51 GMT

Thanks For the Start Guys!

Finally Done it simple way

Add this script in every application

//LET vVar=1; //un comment only for the first time reload then permanently comment it

if ($(vVar)=0) then

SET vVar=1;

EXIT Script;

else

//Whole Application Scripting part comes here ;

endif;

Now Comes the batch Part

"C:\Program Files (x86)\QlikView\qv.exe"/r /vvVar=0 "<qvw Path>"

/r for reload and save /v to pass variable

Place the Above code in Batch file then run it saves application with out data

Any other way kindly post those also