topic Re: export script into txt file in QlikView

export script into txt file

marcorizzo — Wed, 18 Oct 2017 17:33:28 GMT

Hi everybody.

I've got this need.

I would like to export all the script of my qlikview file into a txt file.

What do you suggest me ?

Thanks

Re: export script into txt file

marcorizzo — Wed, 18 Oct 2017 17:47:15 GMT

Is there a command in the script that I can use in the top of the script for my need ?

Re: export script into txt file

felipedl — Wed, 18 Oct 2017 17:49:31 GMT

Hi Marco,

When you enter the script editor (CTRL+E), theres an option, under File -> Export to Script File that makes what you need.

This will export it to a qvs file or txt.

Felipe.

Re: export script into txt file

marcorizzo — Wed, 18 Oct 2017 17:56:13 GMT

Nice but I'd like to automatize this operation.

Is there a syntax that I can use in the top of the script to export the whole script below ?

P.S. Sorry for my English

Re: export script into txt file

felipedl — Wed, 18 Oct 2017 18:07:59 GMT

Hi Marco,

See the attached QVW.

It uses a macro, as follows:

sub writeScriptToFile

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objFile = objFSO.OpenTextFile("C:\Users\eferibe\Desktop\Test.txt", 2,True)

objFile.Write(ActiveDocument.GetProperties.Script)

objFile.Close()

end sub

You can create a task (if you have Qlik Server) to automate the task.

Felipe.

Re: export script into txt file

marcorizzo — Wed, 18 Oct 2017 18:35:07 GMT

What do you think if the txt result is this:

///$tab Main

???

Re: export script into txt file

felipedl — Wed, 18 Oct 2017 18:43:48 GMT

It's a comment that's just stating in which tab it is.

I've added two more tabs, and it's the same for the others, so you can differentiate between the tabs in Qlikview.

It's just a tag actually.

Felipe.

Re: export script into txt file

Wed, 18 Oct 2017 18:45:05 GMT

Hi Marco,

Try this Macro, you should change the path used in the variable.

After saving the macro, you can create a button to execute it.

Re: export script into txt file

felipedl — Wed, 18 Oct 2017 18:48:46 GMT

Forgot to mention that the script is generating the file into "C:\Script\Test.txt"

You have to create the folder or change it in the macro section in qlivkiew "Tools -> Edit Module";

Use the attached QVW.

Felipe.

Re: export script into txt file

marcorizzo — Thu, 19 Oct 2017 07:08:58 GMT

which is the variable I have to change ?

Thanks

Re: export script into txt file

Thu, 19 Oct 2017 10:51:25 GMT

Where we have this:

set docprop = ActiveDocument.GetProperties

wd = docprop.MyWorkingDirectory

wdEx = wd & "\Scripts\"

We are getting your working directory(Where your QVW is) and going to the folder "Scripts", so you should change that to the folder you want, your simply, create the folder "Scripts".

Oh, and this scripts exports a .qvs, if you want a .txt you can change the following line:

from:

fPath = wdEx & vNameFile & ".qvs"

to:

fPath = wdEx & vNameFile & ".txt"

Haven't tested myself (with the .txt extension), but it should work.

Re: export script into txt file

marcorizzo — Thu, 19 Oct 2017 11:02:53 GMT

it works.

Thank a lot