topic Re: How to take back up of editscript code in QlikView

How to take back up of editscript code

jagannalla — Fri, 03 Jun 2011 08:41:33 GMT

Hi,

- I want to keep editscript code in one file.

- How to generate qvs file and use it?

- I need Steps to create qvs file and use it.

How to take back up of editscript code

Miguel_Angel_Baeyens — Fri, 03 Jun 2011 08:48:55 GMT

Hello,

In your script editor screen, go to File, Export to Script File... and browse your computer to store the file.

Although the file is by default saved as *.QVS file, it can be read with notepad or any other tool to read plain text.

In the new document when you want to use any previously exported script, go to the Script Editor, File, Open External Script file and you are done.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to take back up of editscript code

jagannalla — Fri, 03 Jun 2011 09:22:07 GMT

Thanks a lot Miguel....

How to take back up of editscript code

jagannalla — Thu, 16 Jun 2011 07:43:51 GMT

Hi Miguel,

- I had a qvw file with edit script.

- In front end i'll take a button in sheet. When i click this button the editscrpit code should stored in qvs file of location folder.

How can i solve this problem from front end.

Re: How to take back up of editscript code

Miguel_Angel_Baeyens — Thu, 16 Jun 2011 08:20:38 GMT

Hi,

You can create a new button, and use the following macro code (among many other sample codes)

Sub SaveScript
     Set docProps = ActiveDocument.GetProperties
     docScript = docProps.Script
     ''MsgBox(docScript)
     Set objFSO = CreateObject("Scripting.FileSystemObject")
     Set objFile = objFSO.CreateTextFile("C:\ScriptFile.txt")
     objFile.Write(docScript)
     objFile.Close
End Sub

That will save all your script code to the file specified.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to take back up of editscript code

jagannalla — Thu, 16 Jun 2011 09:12:11 GMT

Miguel,

Superb code Thanks a lot.

Actually I posted this task in community put i didn't get any solution. So, i forward to you b'coz you have given me solution previously to create qvs file.

Really thanks a lot...............

Re: How to take back up of editscript code

Fri, 22 Jul 2011 15:28:38 GMT

Hi,

How can i pass the qvs file to another Qlikview by using macro code from existing QVW file.

Thanks in advance

Re: How to take back up of editscript code

Miguel_Angel_Baeyens — Sun, 24 Jul 2011 10:12:14 GMT

Hello,

Can you please elaborate on your exact requirements and what do you mean by "pass the qvs file to another QlikView"? If you already have a QVS file you don't need any macros, just the following line at the beginning of your script

$(include=file.qvs);

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: How to take back up of editscript code

Wed, 27 Jul 2011 10:14:30 GMT

Hi,

I am trying to create a new QVW file from Current Qvw file by using macro.

When i click on "Create QVW" button then it will create a new QVW file. Ceating the new QVW file and passing the QVS File by using Macro.

After creating the new QVW file , then in Edit Script should have the qvs script for newly created QVW file.

How to pass the QVS File to Newly Created QVW File.

Now you understand what i trying to achieve.

Thanks

Re: How to take back up of editscript code

Mon, 26 Mar 2012 09:01:10 GMT

HI Miguel,

Any macro code for creating new file and then loading the existed qvs file ?

Thanks in advance.

Re: How to take back up of editscript code

Miguel_Angel_Baeyens — Fri, 30 Mar 2012 13:56:09 GMT

Hi,

Did you try using binary loads based on an already existing layout document that includes all the charts and variables, but only two lines of script, one with the binary and the other with the include? Which kind of script do you need to create using macro?

Regards,

Miguel

Re: How to take back up of editscript code

Mon, 02 Apr 2012 09:02:45 GMT

Hi Miguel,

Ya i know the use of binary load and Include statement. Now i can able to insert Include statement in another qvw file through macro code. But one thing i want to know i.e. how to insert differant objects of one qvw file to another qvw file.(ex:charts,listboxes,inputboxes,textobjects,variables etc)

Regards

...............

Re: How to take back up of editscript code

hugo_andrade — Tue, 28 Aug 2012 15:18:28 GMT

Miguel, it's not working for me.

After I click on the button that calls the macro, the Edit Module dialog opens and no file is created. What am I missing?

Thank you.

Re: How to take back up of editscript code

Miguel_Angel_Baeyens — Mon, 03 Sep 2012 15:20:22 GMT

Hi Hugo,

Are you allowing system access to the Modules (Ctrl + M, and on the left part, Module Security)? Besides, is the file and folder avaiable to the user or has any NTFS restrictions?

Hope that helps.

Miguel

Re: How to take back up of editscript code

shaikbakshu — Fri, 27 Jul 2018 06:15:46 GMT

Hi Miguel,

It is very useful Macro to Store Edit script.

If it is any way to same(Store Edit script in another location) in Current Edit script?.

If it is possible, could you please send the script.

Thanks and regards,

Bakshu.