Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button to record user Usage

Hi Experts

I have a QV dashboard with 10 different users, I need to know who is actually using the dashboard and when ( Its an internal debate issue !!)

Our support have told me that there is no easy way to record this so I was thinking that ( AND I DONT KNOW IF THIS IS POSSBLE)

as a work around --

Hide all sheets - bar one

On this sheet put a button that when toggled

shows all sheets and

*Presumably uses a macro to update an Excel file on the s drive with data based on users info

-- Hence I would have a log of all users!!!

Has anyone got any feedback on this ?


Do you think its possible?

Should I not even try and persue it ?

Any advice greatly appreciated

Thanks


A

22 Replies
m_woolf
Master II
Master II

I'm trying again.

The admin will log into the PC and run this vbscript.

Copy the script and paste into a text editor.

Change cSERVER_NAME to your server name.

Save with any name and a .vbs extension.

'// ************************************************** 

'// Script for adding some registry keys to the current user profile/registry settings 
'// for enabling the macro security/module security for the SERVER defined below 
'// ~ 

'// CONFIGURATION 

'// Just configure the script by defining your server below 

'// ~ 

'// The article explaining this script can be found at 

'// qlikblog.at/523   ' put www. in front

'// ************************************************** 

CONST cSERVER_NAME = "YOUR_SERVER_NAME"

Dim WshShell 'as Object 

' Delete any registry entries where the user blocked script for the server
on error resume next
WSHShell.RegDelete "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script Blocked\" & cSERVER_NAME
WSHShell.RegDelete "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script Blocked\"
  

Set WshShell = WScript.CreateObject("WScript.Shell") 

WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\", 1, "REG_SZ" 

WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\", 1, "REG_SZ" 

WshShell.RegWrite "HKCU\Software\QlikTech\QlikOcx\Settings for Qlikview Servers\Module Script System\ " & cSERVER_NAME, "", "REG_SZ"

m_woolf
Master II
Master II

I tried again without success.

See if you can read this blog:

www.qlikblog.athttp://www.qlikblog.at/523/

Not applicable
Author