Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to add a table with NTNAME etc. into the Governance Dashboard to enable the use of my client standard Loop and Distribute method in QMC. Running Governance Dashboard with the security code (or any code) added to the script, nothing happens.
Is it possible to add custom script to the governance dashboard?
Is there an "end script" command in the hidden script preventing me of adding custom code? Are there any work around. I tried binary load, but it feels like hidden script is run anyway.
egbs consulting ab
Vegar Arnsten,
Yes, there is an "Exit Script" at the end of the script.
You basically have two options. Note that option 2 gets you into the "not supported" realm, so proceed at your own risk .
1) If you can get execute your script before the data is loaded, you can use the UserConfig script. You’d want to follow the instructions online about using a UserConfig script. (see HERE). Just create a .txt file with the script above in it, turn ‘on’ UserConfig script in the configuration page of the Governance Dashboard, and input the filepath to you UserConfig script.
2) Remove the hidden script in a copy of the Governance Dashboard and use "Binary"
Vegar Arnsten,
Yes, there is an "Exit Script" at the end of the script.
You basically have two options. Note that option 2 gets you into the "not supported" realm, so proceed at your own risk .
1) If you can get execute your script before the data is loaded, you can use the UserConfig script. You’d want to follow the instructions online about using a UserConfig script. (see HERE). Just create a .txt file with the script above in it, turn ‘on’ UserConfig script in the configuration page of the Governance Dashboard, and input the filepath to you UserConfig script.
2) Remove the hidden script in a copy of the Governance Dashboard and use "Binary"
I'm the most comfortable with the binary load solution. I had already started on that, but could not get rid of the Gooden script.
I will however take a better look at the user config script feature in GD. I've totally overlooked that feature.
Thanks for the help Tyler.
/Vegar
Hi Tyler,
I'm trying on the second options, but I can't get the result for step 4#. Any advice?
You should get an understanding of what the prj folder is. Google it or use this YouTube movie Creating prj Folder in QlikView - YouTube
khoo cs - Be sure the name of the qvw and the -prj folder are the same. For example, if you kept the Governance Dashboard.qvw as is (did not rename), you would create a folder next to that .qvw called "Governance Dashboard-prj". Then open the Governance Dashboard.qvw, click Save, and close it. You should then see the files in the -prj folder.
If that's not working, make sure you have permissions in the folder where you make the -prj folder -- or, copy the Governance Dashboard.qvw to your local computer and try it there.
Yes, I don't have permission. Thanks. Solved!
Cool, I understand on the prj folder, just can't get the result because of permission. 😃 Anyway, solved and got it!
Hi Tyler,
Do you know how to define the excluded Files | Directories in Governance Dashboard? Says I defined a path in "List of file paths to scan", can I exclude several directories which located inside the path?
Yes, this "excludes" is set using LUA patterns, as described here: Programming in Lua : 20.2
Personally, I have found I'm not super skilled at getting the right pattern down, but you might have more experience here.
Separate each folder to exclude using the vertical pipe |.
Here's the paragraph from the online doc about GovDB (HERE😞
The scanner descends into all sub-directories of each scan path root directory to find all QVW, QVD and QVX files to analyze. One or more exclusion patterns (see Patterns) can be entered into the Excluded Keywords text field (separated by vertical bar | characters) to exclude from the metadata scan individual files or entire directories whose names match the exclusion pattern. Note that if the name of the candidate folder or file matches ANY one of the pipe-delimited patterns, the file or subfolder (and all of contents) is excluded from the scan.