topic Re: Append text to text file from access point in QlikView

Append text to text file from access point

Anonymous — Tue, 28 Nov 2017 08:38:25 GMT

Hi Guys

My vendor has request:

Qlikview App users (Clients) when open an app from access point can Append text to a shared text file on server

how can I do this for him

thanks

Re: Append text to text file from access point

marcus_sommer — Tue, 28 Nov 2017 15:59:01 GMT

By using the IE plugin a macro similar to this one: VBS. openOutputFile issue could be used (the second parameter by OpenTextFile needs to be 8 for appending data). By using the AJAX client it won't be possible.

- Marcus

Re: Append text to text file from access point

Anonymous — Mon, 04 Dec 2017 09:36:17 GMT

I did it finally by mu self

I Use this Macro

'---------------------------------Start of Macro--------------

sub Append

Const ForAppending = 8

Set objFSO = CreateObject("Scripting.FileSystemObject")

'-----this is the address of shared file

Set objFile = objFSO.OpenTextFile("\\Server IP\...\textreport.txt", ForAppending)

'---I need to variable that i define them here

Set var1 = ActiveDocument.Variables("vInput")

var = var1.GetContent.String

Set var2 = ActiveDocument.Variables("vQVUser")

var3 = var2.GetContent.String

objFile.WriteLine

objFile.Write "" &var3& "," &var& ","&now

objFile.Close

end sub