4 Replies Latest reply: Feb 17, 2018 12:18 PM by Isabelle Timmermans RSS

    Execute Command

    Isabelle Timmermans

      Hi,

       

      We are trying to create and execute a bat file from the script.

      I already disabled the standard mode and added these two lines in the settings.ini:

      OverrideScriptSecurity=1

      AllowExecuteCommand=1

       

      My qlik service user has rights to go to the location and to do things there.

      In Qlik Sense the message is that de execute command is being executed, but it doesn't do anything.

      The commands i'm using are:

       

      let vFile = peek('File',$(j),'FilesToLoad');

      LET vImportPath = '\\Server\map\IN\';

      LET vExportPath = '\\Server\map\Archief\';

      LET vMoveFile = 'move ' & chr(34)& vImportPath & vFile & chr(34) & ' ' & chr(34) &  vExportPath & vFile& chr(34);

       

      execute cmd.exe /c echo $(vMoveFile) > "E:\1. Qlik PROD\0. Data\4. Support files\2. Batch bestanden\Batchbestanden\sales.bat";

      EXECUTE    cmd.exe /C "E:\1. Qlik PROD\0. Data\4. Support files\2. Batch bestanden\Batchbestanden\sales.bat";

       

      Anyone any idea what is going wrong?

       

      Thanks in advance,

      Isabelle