Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Check below link.

It says it wont work in standard mode.

Execute ‒ Qlik Sense

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

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

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

Anonymous
Not applicable
Author

Hi Michael

Did you ever hear back from Qlik on this?

catalystmichael
Partner - Contributor III
Partner - Contributor III

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

thanks guys, no > side, nhs

catalystmichael
Partner - Contributor III
Partner - Contributor III

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

cspindley
Contributor III
Contributor III