Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

onkellepie
New Contributor III

QlikSense: Is there an alternative for execute?

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!

4 Replies
amartinez35
Valued Contributor

Re: QlikSense: Is there an alternative for execute?

Hi,

Have you see this Execute ‒ Qlik Sense ?

Aurélien

onkellepie
New Contributor III

Re: QlikSense: Is there an alternative for execute?

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

amartinez35
Valued Contributor

Re: QlikSense: Is there an alternative for execute?

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

onkellepie
New Contributor III

Re: QlikSense: Is there an alternative for execute?

Are there any other ideas? Everything is welcome

Community Browser