Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Have you see this Execute ‒ Qlik Sense ?
Aurélien
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
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
Are there any other ideas? Everything is welcome
Did you find any solution for this?