topic Re: Back up for Qlikview in QlikView

Back up for Qlikview

abhijith28 — Fri, 30 Nov 2018 08:19:02 GMT

Please help me with:

I need to create the back up file (.qvw) after each reload of qlikview document.

Is there any script? to achieve this.

Re: Back up for Qlikview

agigliotti — Fri, 30 Nov 2018 08:23:36 GMT

what reload do you mean ? server side or with Qlikview Desktop ?

Re: Back up for Qlikview

Frank_Hartmann — Fri, 30 Nov 2018 09:07:20 GMT

If you use QV Desktop you can use a macro to achieve this. You will just have to set up a trigger for "OnPostReload" (Settings-->DocumentProperties-->Trigger-->AddActions-->Add-->External-->RunMacro--> MacroName = SaveDocWithTimestamp)

Sub SaveDocWithTimestamp 
    	set app = ActiveDocument.GetApplication    
    	Timestamp="-"&Year(now())&"-"&month(now())&"-"&day(now())&"--"&hour(now())&"-"&minute(now())&"-"&second(now()) 	
    	fname = ActiveDocument    	
	fname = right(Left(fname, InStr(fname, ".") - 1),4)						'Reportname in this example: Main.qvw--->4 characters, if you change Reportname you have to adjust the "4" according to the length of the Reportname		  	
    	ActiveDocument.SaveAs "C:\Users\root\Desktop\"&fname&"-Backup"&Timestamp&".qvw"                 'Here you can specify the backup path
  	ActiveDocument.SaveAs "C:\Users\root\Desktop\Main.qvw"						'paste here the path to the original .qvw file to guarantee not being in the wrong document after macroexecution
End Sub

hope this helps

Re: Back up for Qlikview

abhijith28 — Fri, 30 Nov 2018 09:24:36 GMT

with Qlikview desktop, not with the server

Re: Back up for Qlikview

agigliotti — Fri, 30 Nov 2018 10:07:00 GMT

you can find it under User Preferences->Save.
You could enable "Save Before Reload" and also "Use Backup" with Keep Last 3(for example) Instances.
I hope it helps.

Re: Back up for Qlikview

abhijith28 — Fri, 30 Nov 2018 11:47:23 GMT

Yeah, Thank you..

But where could i find these back up files? where it will be saved?