topic Re: Scripting Autosave in speciffic folder in QlikView

Scripting Autosave in speciffic folder

Sat, 17 Jan 2015 15:52:36 GMT

Hi Experts

I would like to insert a command into my code that saves my file every time the script is run. Is that possible? If yes, how? I would also like to save my file in a speciffic folder. How can I script this?

Thank you for your help!

Jan

Re: Scripting Autosave in speciffic folder

maxgro — Sat, 17 Jan 2015 17:44:03 GMT

there are some autosave options in user preferences (image), not for a specific folder

or see here (m woolf answer)

http://community.qlik.com/message/663079#663079

Re: Scripting Autosave in speciffic folder

Gabriel — Sat, 17 Jan 2015 21:35:18 GMT

Hi,

So that you get correct answer.

Do you mean you'll like to save the qvw file or save the data as QVD whenever the qvw file is run?

If you want the qvw file save whenever it reloads then,

ctlr + alt + U (User Preferences) then select Save tab, check Save Before Reload box.

If you want to save the data during reload then you have to use STORE command in your script.

STORE Table_Name INTO FileLocationPath

It's every important to clarify your question.

Hope this helps

Re: Scripting Autosave in speciffic folder

Sun, 18 Jan 2015 10:09:43 GMT

HI Gabriel

Thank you for your reply. You are right, I should clarify. I would like to save the whole file as a .qvw file after updating the data.

Is it also possible to give a path where it is supposed to be saved or is it only possible to ovveride the existing file?

Best

Jan

Re: Scripting Autosave in speciffic folder

Colin-Albert — Sun, 18 Jan 2015 10:20:41 GMT

QlikView server will save the QVW after reloading, but does not have an option to save backup copies to a different folder.

QlikView desktop has the option to save after reload, but this option overwrites the original file and does not have an option to save a copy to a different folder.

Re: Scripting Autosave in speciffic folder

Sun, 18 Jan 2015 11:38:20 GMT

Hi Colin

Okay. This means I have to tick "after reload" under Save Auto Recover Info in the system preferences?

Thanks

Jan

Re: Scripting Autosave in speciffic folder

Gabriel — Mon, 19 Jan 2015 16:55:37 GMT

Hi,

Another option if you wanted to save your qvw when reload is to use macro

as this

ActiveDocument.SaveAs "C\MyDoc.qvw"

This you can run it last once your reload is done or any point during reload.

Hope this helps