cmd.exe Move File

[Anonymous]

Hi all!

I upgraded Qlik Sense Desktop to September 2017 yesterday and it seems to have stopped "EXECUTE cmd.exe" functions from working in my load scripts. I use this to move csv files to an Archive folder once I have loaded them to a QVD. As an example, the script I am using is:

LET File = 'T:\QS Exports\Test.xlsx';

execute cmd.exe /c move "$(File)" "T:\QS Exports\Archive\";

And these are the settings I have in the settings.ini file:

[Settings 7]

InterfaceLanguage=English

NumberOfDocuments=0

DocumentTimeout=60

StandardReload=0

MarginTop=20

CurrentQVConnect64Loc=

CurrentQVConnect32Loc=

OverrideScriptSecurity=1

When running in Debug mode, the Output just has this:

08:17:04

execute cmd.exe /c move "T:\QS Exports\Test.xlsx" "T:\QS Exports\Archive\"

And I used to see a cmd window appear briefly whenever the command was executed, but now I don't see anything. Has anyone had the same issue?

Thanks!

Alan

[kaushiknsolanki]

Hi Check below link.

It says it wont work in standard mode.

Execute ‒ Qlik Sense

Regards,

Kaushik Solanki

[Anonymous]

Hi Kaushik,

I believe the StandardReload=0 setting which I showed above means that the program is running in Legacy mode, so the statement should still work?

Thanks,

Alan

[catalystmichael]

I've got the same issue.  I'll raise a case with Qlik.

[Anonymous]

Hi Michael

Did you ever hear back from Qlik on this?

[catalystmichael]

Apologies I never posted the result on here straight away.  Looked back through my script and found I got it working by adapting it to the below:

execute cmd.exe /C move /Y "$(File)" "$(FileDestination)";

Hope that helps.

[cspindley]

thanks guys, no > side, nhs

[catalystmichael]

Did this work for you?  If so can you mark the thread as answered?