topic Re: Executing Jscript function during load statement in QlikView

Executing Jscript function during load statement

jonastemin — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to execute a Jscript function during a load script but it looks like the command is not executed at all.

I have the following Jscript function:

The functions works correctly when executing using "Run Macro" button.

I looked at previous forum posts and this command should work;

How do a call a Jscript function from a load script?

Are there security settings that prevents this from working?

Thanks,

Jonas

Re: Executing Jscript function during load statement

marcus_sommer — Wed, 22 Nov 2017 17:00:57 GMT

In general you could use macro-functions within the load-script but they mustn't contain any reference to ActiveDocument because it didn't exists at this time. Only after the script is finished ActiveDocument is available.

- Marcus

Re: Executing Jscript function during load statement

jonastemin — Wed, 22 Nov 2017 19:25:05 GMT

‌Okay, I see. But is there a way to use the variable sPath in the Jscript function?

Is there another syntax in order to read the variable in the Jscript?

Can I use something like LET vExecFunction = post($(sPath)) and update the Jscript equivently? Tried this in the past but couldn't get it to work

Re: Executing Jscript function during load statement

rwunderlich — Wed, 22 Nov 2017 19:31:30 GMT

You should be able to do that. Just be sure to quote the parameter.

LET vExecFunction = post('$(sPath)');

Also if running QV Nov2017, you'll need turn off BNF mode by adding this as the first line of your script.

///$bnf off

-Rob

Re: Executing Jscript function during load statement

jonastemin — Thu, 23 Nov 2017 12:11:16 GMT

Thanks, I got it working now when running Qlikview Desktop, both on local computer and Qlikview server.

However, in QMC the function is not executing.

I'm running Qlikview server 12.10.20400.0 so I have not set BNF mode to off.

Are there any settings in the QMC or document that I need to set?

Re: Executing Jscript function during load statement

Ricardo_Gerhard — Thu, 23 Nov 2017 12:17:36 GMT

Take a look on this procedure:

Cause

The new BNF script reload mode in QlikView November 2017 initial release doesn't allow the Macro function name in the script.
This is a bug that RD will fix in the future release, hopefully in Patch 1.

Resolution

Disable the BNF script reload mode either from the script, or fromthe settings.ini file.

Instructions of disabling BNF reload module:

Disabling BNF reload mode for the entire server: Update the Settings.ini by adding the line EnableBnfReload=0
Disabling BNF reload mode for individual apps: Add the ///$bnf off tag at the top of the script (The tag must be in the first 50 characters of the script).

Re: Executing Jscript function during load statement

jonastemin — Thu, 23 Nov 2017 12:48:12 GMT

I don't believe I use Qlikview November 2017. I run version 12.10.20400.0.

Re: Executing Jscript function during load statement

Ricardo_Gerhard — Thu, 23 Nov 2017 12:54:01 GMT

This is an information from Qlik in another problem.

Try, could be helpful and fix.

Re: Executing Jscript function during load statement

jonastemin — Thu, 23 Nov 2017 13:16:19 GMT

Added the EnableBnfReload=0 but it didn't help. Restarted the server to make sure settings were updated.

Re: Executing Jscript function during load statement

Peter_Cammaert — Thu, 23 Nov 2017 13:19:27 GMT

You're right, The option to execute Load Scripts in strict BNF mode is new to QlikView 12.20 (and Qlik Sense of the same date) or later and does not apply to earlier versions.

Re: Executing Jscript function during load statement

jonastemin — Thu, 23 Nov 2017 13:33:21 GMT

The current code looks like this;

Jscript

Load script

The script should connect to a web server that send a POST request to Google Sheets API to update the format of a specific sheet.

Re: Executing Jscript function during load statement

marcus_sommer — Thu, 23 Nov 2017 13:38:12 GMT

A qmc-tasks doesn't execute "classical" macros - by macro-functions during the load-script I'm not sure but I could imagine that this is also disabled.

In this case you could try to outsource your macro into an external batch which could be triggerred within the load with an EXECUTE statement. Here an example what is meant: Re: Run Excel macro via QMC.

The input/output from your routine mustn't be necessary a parameter for the batch-call you could also use QV store/load for it, for example:

[$(sPath)]:

load '$(sPath)' autogenerate 1;

store [$(sPath)] into Parameter.txt (txt);

and your routine read this parameter and stored its output again into a txt-file which QV reads afterwards within a load.

- Marcus

Re: Executing Jscript function during load statement

rwunderlich — Thu, 23 Nov 2017 17:24:20 GMT

In the QMC Server Security settings, you will have to check on both:

Allow macro execution on server

Allow unsafe macro execution on server

-Rob

Re: Executing Jscript function during load statement

jonastemin — Thu, 23 Nov 2017 17:42:40 GMT

‌Botg of those are already checked

Re: Executing Jscript function during load statement

rwunderlich — Fri, 24 Nov 2017 16:55:22 GMT

What error do you get in the script? Or no error but incorrect output?

Re: Executing Jscript function during load statement

jonastemin — Thu, 30 Nov 2017 11:50:30 GMT

Thank you all for your input.

My conclusion is the QMC does not execute any macros.

Using EXECUTE and BAT to execute the script would have been possible but includes several steps that could potentially fail.

My solution (verified) is to use Qlik REST Connector;

I needed to run a SQL Select statement and use WITH Connection to execute the POST command.