topic Re: cmd.exe Move File in App Development

cmd.exe Move File

Anonymous — Thu, 05 Oct 2017 07:28:19 GMT

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

Re: cmd.exe Move File

kaushiknsolanki — Thu, 05 Oct 2017 16:39:59 GMT

Hi Check below link.

It says it wont work in standard mode.

Execute ‒ Qlik Sense

Regards,

Kaushik Solanki

Re: cmd.exe Move File

Anonymous — Fri, 06 Oct 2017 06:46:15 GMT

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

Re: cmd.exe Move File

catalystmichael — Tue, 31 Oct 2017 10:11:51 GMT

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

Re: cmd.exe Move File

Anonymous — Tue, 06 Feb 2018 14:54:08 GMT

Hi Michael

Did you ever hear back from Qlik on this?

Re: cmd.exe Move File

catalystmichael — Tue, 06 Feb 2018 15:00:16 GMT

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.

Re: cmd.exe Move File

cspindley — Tue, 05 Jun 2018 08:41:10 GMT

thanks guys, no > side, nhs

Re: cmd.exe Move File

catalystmichael — Tue, 05 Jun 2018 09:07:58 GMT

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

Re: cmd.exe Move File

cspindley — Wed, 06 Jun 2018 05:33:20 GMT