topic Re: QlikSense: Is there an alternative for execute? in Management & Governance

QlikSense: Is there an alternative for execute?

onkellepie — Thu, 27 Jul 2017 12:45:09 GMT

I migrate some qvw to qliksense. In QV i use following script to update old qvd files to new one:

STORE $(table) into [$(filename)_tmp.qvd];

IF ScriptErrorCount = 0 then

// If there is no error, delete old qvd file and rename temp.qvd to normal filename.

EXECUTE cmd.exe /C DEL /F [$(filename).qvd];

EXECUTE cmd.exe /C MOVE /Y [$(filename)_tmp.qvd] [$(filename).qvd];

END If

Becaues we get some Trouble with our filesystem in the past, we introduce this to store at first a tmp.qvd file and then delete the old one and replace it with the new one. So far, so good.

But in QlikSense i got the error

EXECUTE statement not available in this script mode

I understand that i can solve the Problem when changing Settings ini to OverrideScriptSecurity and enabled legacy mode. But this solution comes with many other negativ aspects. So i dont want to change Settings.ini and dont want to enable legacy mode.

So i want to know if there is an alternative to rename/ replace a qvd file within QlikSense Script?

My System:

Windows Server 2016

Qlik Sense June 2017

Thanks in advance!

Re: QlikSense: Is there an alternative for execute?

Aurelien_Martinez — Thu, 27 Jul 2017 15:11:10 GMT

Hi,

Have you see this Execute ‒ Qlik Sense ?

Aurélien

Re: QlikSense: Is there an alternative for execute?

onkellepie — Thu, 27 Jul 2017 15:23:54 GMT

Hi,

thanks for your Reply. i see this. But also:

If you set OverrideScriptSecurity to enable Execute, any user can execute files on the server. For example, a user can attach an executable file to an app, and then execute the file in the data load script.

i dont want to open my infrastructure in this way. So i search for another way to rename/replace my files without changing Settings.ini and so on.

Regards

Re: QlikSense: Is there an alternative for execute?

Aurelien_Martinez — Thu, 27 Jul 2017 15:35:07 GMT

I think, there's no alternative.

You can retry, STORE $(table) into [$(filename).qvd];

Or you can play with the API to create an app (C# or any language) to rename the QVD after the reload.

Aurélien

Re: QlikSense: Is there an alternative for execute?

onkellepie — Mon, 31 Jul 2017 08:45:47 GMT

Are there any other ideas? Everything is welcome

Re: QlikSense: Is there an alternative for execute?

rupamjyotidas — Mon, 07 Oct 2019 17:06:00 GMT

Did you find any solution for this?