topic Log QV Usage in QlikView

Log QV Usage

Thu, 19 Nov 2015 16:09:47 GMT

I am trying to log how often a qv application is opened. Every time the app is opened I want to write to a log file the user and date/time. My approach is to set a trigger on the document. When opened I run a macro, but it doesn't write to the file. Any suggestions?

Sub LogOpen

Const ForAppending = 8

Set objFSO = CreateObject ("Scripting.FileSystemObject")

Set objTextFile = objFSO.OpenTextFile _

("C:\Users\frank\Documents\QVopenlog.txt", ForAppending, True)

objTextFile.WriteLine ("QVuser" )

end sub

Re: Log QV Usage

swuehl — Thu, 19 Nov 2015 16:47:34 GMT

First, are you trying to do this on the desktop client or server?

If you want to track server access, there are better options, using the server logs (and there are already existing applications to evaluate the logs).

Re: Log QV Usage

manojkulkarni — Thu, 19 Nov 2015 16:54:03 GMT

If you are writing in QV Desktop, it is working perfectly.

I think you need to provide "System Access" & "Allow System Access" in Edit Module window.

Option is available in Requested Module security

Re: Log QV Usage

Thu, 19 Nov 2015 16:58:48 GMT

Providing "System Access" & "Allow System Access" allowed the record to be written. However, the literal "QVuser" was written and not the username that opened the application. Also, how do I get the date written? thanks.

Re: Log QV Usage

Thu, 19 Nov 2015 18:29:54 GMT

Desktop client