topic Re: Export Scripts from multiple QVW files in QlikView

Export Scripts from multiple QVW files

sunny_talwar — Sat, 16 Nov 2024 21:44:34 GMT

Hi all -

Is there a quick way to export the scripts from multiple files? I know to export them one by one by going to the edit script and then exporting it out. Can this be done programmatically for multiple qvws so that we don't have to be export them one by one?

To give a brief background, I am looking for a SQL query that might be running in one of the 100-150 qvw files that we have and although I have looked through the log file, I have seen that not all SQL queries are logged into the log file. If I were to export the log files from all the dashboards, I can very easily use NotePad++ to look through them to find the keywords from the query.

Now that you know what I am trying to do, may be there is another efficient way to find out what I am looking for? I am open for suggestions.

@rwunderlich, @marcus_sommer

Thanks,
Sunny

Re: Export Scripts from multiple QVW files

m_woolf — Wed, 12 Dec 2018 14:48:28 GMT

This post:

https://community.qlik.com/t5/QlikView-Scripting/export-script-into-txt-file/m-p/1393371

has a macro that exports the current application's script to a text file. With some adjustment, you might make it loop through all qvws and export the script.

Re: Export Scripts from multiple QVW files

sunny_talwar — Wed, 12 Dec 2018 14:50:44 GMT

I will take a look at it. Thanks

Re: Export Scripts from multiple QVW files

prieper — Wed, 12 Dec 2018 14:56:18 GMT

Which SQL-queries are not in the logfiles?
I used to have one QVW, which reads all logfiles and highlights certain keywords. Thus you have all data in one place.

Re: Export Scripts from multiple QVW files

sunny_talwar — Wed, 12 Dec 2018 15:02:16 GMT

@stevedark would you be able to help here since you have had worked with similar situation in the past based on this thread

Code to export script

Re: Export Scripts from multiple QVW files

sunny_talwar — Wed, 12 Dec 2018 15:05:09 GMT

@prieper wrote:
Which SQL-queries are not in the logfiles?

I have not been able to determine the pattern, but I have seen that not all sql queries show up on the log file... I used to think that if you add SQL in front of your SELECT, it will not show up on the log file. But I am not sure this is true. But to be truthful, I have not done enough testing around this.

@prieper wrote:
I used to have one QVW, which reads all logfiles and highlights certain keywords. Thus you have all data in one place.

I have been able to go through the logfiles using NotePad++ to look for the keywords, so loading the logfiles into QlikView might not really help me here. What I really need is to look at each of the script.

Re: Export Scripts from multiple QVW files

marcus_sommer — Wed, 12 Dec 2018 15:14:23 GMT

Here a similar one which looped through the cells of a tablebox to read the path and filenames (you might create this table with a dirlist/filelist-loop within the script):

sub ReadScript

dim doc, obj, prop, newApp, newdoc, fso, File, FilePath, iRow, app, path, script

set doc = ActiveDocument
set obj = doc.GetSheetObject("TB04")

FilePath = ActiveDocument.Variables("pApp@01").GetContent.String
FilePath = FilePath & "DataStructures\"

for iRow = 1 to obj.GetRowCount - 1 
	set app = obj.GetCell(iRow, 0) 
	set path = obj.GetCell(iRow, 1) 
	set newApp = ActiveDocument.GetApplication 
	set newdoc = newApp.OpenDoc (path.Text & "\" & app.Text,"","") 
	set prop = newdoc.GetProperties 
	script = prop.Script 
	set fso = CreateObject("Scripting.FileSystemObject") 
	set File = fso.OpenTextFile(FilePath & "LoadScript_" & app.Text & typ, 2, true)		File.Writeline script
	File.Close 
        newdoc.closedoc  
next

end sub

Instead of OpenDoc you might choose OpenDocEx which has a parameter to open an application with no data.

Alternatives to this might be to use prj-folder or (to macro-export also within a loop) the document-layout and reading then the script from there. Each way will have some benefits and disadvantages.

- Marcus

Re: Export Scripts from multiple QVW files

marcus_sommer — Wed, 12 Dec 2018 15:21:42 GMT

I just remembered that there is already a very useful tool for it: qlikviewcookbook.com - script-log-analyzer

- Marcus

Re: Export Scripts from multiple QVW files

marcus_sommer — Wed, 12 Dec 2018 15:28:05 GMT

Maybe the SQL queries aren't logged if there happens any error. Therefore using the ERRORMODE especially with the ScriptErrorDetails which contain detailed infos about the database-errors might give useful hints for your issues.

- Marcus

Re: Export Scripts from multiple QVW files

stevedark — Wed, 12 Dec 2018 15:46:36 GMT

The Script Analyzer by @rwunderlich is an excellent too, as @marcus_sommer suggests.

If you want something a bit more automated, you could look at setting up project folders for all of your QVW files. On any change the script (and all object definitions) are all automatically persisted to the project folder.

You do need to be careful with the project folder approach, as if changes are made to the files in the project folder these get pulled back into the QVW. This is great for config control or bulk updates, but a real pain when it happens and you don't want it to.

If you search Community, or just Google, "project folders qlikview" you should find the info on these.

Steve

Re: Export Scripts from multiple QVW files

m_woolf — Wed, 12 Dec 2018 17:37:32 GMT

Sunny,

This is messy.

The forum wouldn't let me attach a vbs file, so I had to zip the file.

The attached vbs will load all qvws in a folder structure and export the script to a text file of the same name.

Line 3 sets the target folder for the qvws and line 4 sets the folder for the text files.

You should open an instance of QV first. Then execute the vbscript. Once it is started, the only way to stop it is to open the task manager and end the wscript.exe process.

Backup up you system.ini file, because this process will mess up your recent file list.

Sorry for the messy solution. Hope it helps.

Re: Export Scripts from multiple QVW files

rwunderlich — Wed, 12 Dec 2018 17:53:21 GMT

I don't know how you all missed the tool:

Qlikview Cookbook: Script Repository http://qlikviewcookbook.com/recipes/download-info/script-repository/

The Script Repository tool will extract the script from an entire set(s) of QVWs and give you a search UI as well.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

P.S. If you came to a recent Masters Summit you would know all about this stuff 🙂

Re: Export Scripts from multiple QVW files

sunny_talwar — Wed, 12 Dec 2018 18:17:21 GMT

I have been re configuring the Macro behind Document Analyzer for the last couple of hours :). I was able to store the script for one qvw, the next step was to loop over it somehow :).

Now that I have your app, it will save me ton loads of time. Thank you Rob!!

Best,
Sunny

Re: Export Scripts from multiple QVW files

varunqvmm — Thu, 19 Dec 2019 15:17:50 GMT

Hello,

Is there any way to export all the QVW files/documents from workspace to some specific file folder location through script.And can u help me understand how the data sources are used / connected in specific sheets of a document i.e link in between them.I have a requirement where i want to know which data sources are used in which sheet.And i explored the document summary xml format in QVW file but i didn't got any link between them.

Thanks ,

Varun

Re: Export Scripts from multiple QVW files

stevedark — Thu, 19 Dec 2019 15:22:46 GMT

As mentioned above Rob's tool for the exporting of the load script is the best start point:

https://qlikviewcookbook.com/tools/#squelch-taas-accordion-shortcode-content-9

You probably then want to look at creating Project folders for each app and then looking at the XML. Not sure this will give you the relationship between data and sheet.

Each app though should ideally be based on a single data model, rather than having different sheets showing different data. Separate apps would make more sense for that.

Re: Export Scripts from multiple QVW files

rwunderlich — Thu, 19 Dec 2019 15:57:25 GMT

The only tool I know that can tie sheet objects back to data sources is the NodeGraph product https://www.nodegraph.se/

-Rob

Re: Export Scripts from multiple QVW files

varunqvmm — Fri, 20 Dec 2019 08:12:47 GMT

Hi ,

Thank you for your quick response Rwunderlich / Stevedark ,but i want to get the information using QVW files or any of the QlikView related files itself, rather than using separate product.Is this possible using the JavaScript or Java kind of API's,if possible please provide the sample code.

And can a licensed version of QVW file contains this information i.e. link between the sheet and data source when opened in notepad++. Example : lets say i have 3 data sources which are csv ,excel and some sql run through LOAD function .Csv file data source used in sheet 1 and excel data used in sheet 2 ,i want to know this information through some kind of export functionality.

Thanks ,

Varun

Re: Export Scripts from multiple QVW files

rwunderlich — Fri, 20 Dec 2019 14:52:33 GMT

Hi,

QVW files contain information (with some limitations) about data sources at the file or DB table level. Sheet objects use Fields in the data model. Making an accurate association between a data model Field and it's source file is difficult work and there is nothing automatic. This is the hard work that vendors like NodeGraph have done.

-Rob