Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
MVP & Luminary
MVP & Luminary

Hi Check below link.

It says it wont work in standard mode.

Execute ‒ Qlik Sense

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Contributor
Contributor

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

Highlighted
Partner
Partner

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

Contributor
Contributor

Hi Michael

Did you ever hear back from Qlik on this?

Highlighted
Partner
Partner

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.

Highlighted
Contributor III
Contributor III

thanks guys, no > side, nhs

Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III