topic Re: Export to File Script question in QlikView

Export to File Script question

Anonymous — Thu, 14 Jan 2016 15:33:45 GMT

Hi,

I exported the script in my Qlikview document by doing a File -> Export to Script File in the script editor. I was looking for the menu to reverse this operation – meaning I wanted to re-import this script after making changes. I couldn’t find any menu option. Is this possible?

Thanks

Re: Export to File Script question

rwunderlich — Thu, 14 Jan 2016 15:55:07 GMT

There are two menu options to reimport script.

1. Insert > Script File.

2. File > Open External Script File.

The first inserts the file contents at the cursor position. It's what I use.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Export to File Script question

swuehl — Thu, 14 Jan 2016 15:59:34 GMT

Hi Rob,

is there a way that tabs are getting reconstructed

(using the automatically generated comments like

///$tab SalesRep

when exporting as script)?

Re: Export to File Script question

Anonymous — Thu, 14 Jan 2016 15:59:45 GMT

Neither is doing what I would like to do. The document I'm looking at, written by someone, has 10 tabs. Each

tab has scripts in it. I want to be able to import the script file and have the code placed in the tab where they belong to.

Is this possible?

Re: Export to File Script question

rwunderlich — Thu, 14 Jan 2016 16:19:21 GMT

Close the script editor. Then reopen it. The script will automatically be distributed to tabs based on the ///$tab comments.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Export to File Script question

Anonymous — Thu, 14 Jan 2016 16:30:19 GMT

So I closed the editor and re-opened it. The problem is that it re-created all the tabs with the same name. I now have duplicate tab names. Is this what you expected or maybe I didn't do it in the right sequence?

Re: Export to File Script question

rwunderlich — Thu, 14 Jan 2016 17:05:15 GMT

It's what I expected. The process creates a new tab for each ///$tab name. It will not merge with an existing tab of the same name. You have to do that manually, which is pretty easy with the tab promote & merge menu commands.

If the issue is more complex than that and your'e willing to write some macro code, you can update script via the API.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Export to File Script question

Anonymous — Thu, 14 Jan 2016 19:38:41 GMT

OK, sounds good. Thanks for your help.

Re: Export to File Script question

Anonymous — Thu, 14 Jan 2016 19:49:19 GMT

Just to clarify ...

The "Merge with Previous" isn't exactly merging. This is rather an append operation. You will still need to remove the duplicate code/script manually yourself after you do a promote/demote and merge with previous.

Re: Export to File Script question

rwunderlich — Thu, 14 Jan 2016 20:49:01 GMT

Yes, that's correct. It's not an intelligent merge. It just appends the entire contents of one tab to the previous tab.

-Rob

Re: Export to File Script question

Anonymous — Thu, 14 Jan 2016 20:59:03 GMT

I think having a feature that can perform real merge is very helpful to developers in future relases. I do mass updates quite often as a developer not just in QV but in other programming languages, database, pretty much any tool/language that can generate scripts.

Re: Export to File Script question

rwunderlich — Thu, 14 Jan 2016 22:26:07 GMT

If you do your script editing in external files, you can use any merge tool to do real diffs and merges. If you use the QV Source Control feature (prj directory) you can do the merge from within QV, although I'm not sure that's a great benefit.

-Rob