topic Re: VB function execution on Server not working! in QlikView

VB function execution on Server not working!

Wed, 17 Feb 2016 19:37:10 GMT

Hi Qlik Community,

i have the following function defined and I'm calling this function in the script editor using the following statement:

let x = sendmail('Test');

Note: variable is not doing anything in the function, and that's by design.

The function is basically opening the text file Maro_Err and writing the line Hello There. This is working when executing the script using the thick client. However when reloading the dashboard using QMC, the function sendMail is not doing anything. Any ideas? Is there any setting I can check on the server that is stopping the executing?

Your help is much appreciated. Thanks

function sendMail(variable)

on error resume next

Dim objFileToRead

'''Object to open text file

Set objFileToWrite = CreateObject("Scripting.FileSystemObject").OpenTextFile("\\servername\Macro_Err.txt",2,true)

'''''

objFileToWrite.WriteLine("Hello There")

objFileToWrite.Close

Set objFileToWrite = Nothing

'Clear the memory

Set outobj = Nothing

Set mailobj = Nothing

end function

Re: VB function execution on Server not working!

kaushiknsolanki — Wed, 17 Feb 2016 20:05:12 GMT

Hi,

It is because Macros are not supported in Ajax mode.. Try using the IE Pugins.

Regards,

Kaushik Solanki

Re: VB function execution on Server not working!

petter — Wed, 17 Feb 2016 20:14:57 GMT

Visual Basic works also in Ajax but with limitations as documented in the QlikView Reference Manual.

The question does not mention Ajax but Load Script calling a VBScritical function.

Re: VB function execution on Server not working!

petter — Wed, 17 Feb 2016 20:16:44 GMT

The server settings in the QMC have to allow execution of Macros. It could also be a matter of rights....

Re: VB function execution on Server not working!

Wed, 17 Feb 2016 20:27:48 GMT

So I don't think this has anything to do w/ Ajax vs. IE plugin. My reasoning is as follows:

The qvw has no frontend. My goal of this qvw is to set a reload task that on a predetermined frequency can refresh the dashboard and execute the macro. So I'm not even using the front end at all. Let me know if i'm mistaken.

Peter - I looked into your other comment about macro execution on server setting. This setting is enabled, yet the dashboard is still not write the string to the text file, as the function is instructed to do. Any ideas??

Re: VB function execution on Server not working!

petter — Thu, 18 Feb 2016 03:03:05 GMT

Check these three things:

1) The reference to the file does not seem to be valid:

\\servername\Macro_Err.txt

The structure of an UNC path to a file has to have at least three components

\\servername\share\filename

2) The account that the server is running under has to have sufficient rights to the file that will be written to.

3) The file has to exist already since you are not creating the file but only opening it for writing.

Re: VB function execution on Server not working!

marcus_sommer — Thu, 18 Feb 2016 06:54:55 GMT

Have a look here: Using EDX in QlikView 11 - basic example

- Marcus

Re: VB function execution on Server not working!

petter — Mon, 29 Feb 2016 16:11:59 GMT

If you have additional feedback please pose more questions or if you feel that your question has been answered please close this thread by marking it as answered and if appropriate mark one or more answers as helpful