Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mvproductivitya
New Contributor

cmd.exe Move File

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

8 Replies

Re: cmd.exe Move File

Hi Check below link.

It says it wont work in standard mode.

Execute ‒ Qlik Sense

Regards,

Kaushik Solanki

mvproductivitya
New Contributor

Re: cmd.exe Move File

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
New Contributor III

Re: cmd.exe Move File

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

mvajhuddart
New Contributor

Re: cmd.exe Move File

Hi Michael

Did you ever hear back from Qlik on this?

catalystmichael
New Contributor III

Re: cmd.exe Move File

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
New Contributor II

Re: cmd.exe Move File

thanks guys, no > side, nhs

catalystmichael
New Contributor III

Re: cmd.exe Move File

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

cspindley
New Contributor II

Re: cmd.exe Move File

Community Browser