topic Re: Why exec Rename cmd Do not work? Security ? in QlikView

Why exec Rename cmd Do not work? Security ?

yanivvl0 — Sun, 27 May 2018 12:33:48 GMT

hi to all ,

i am trying to exec:

EXECUTE cmd.exe /C rename 'D:\AA.XLSX' 'D:\BB.XLSX' ;

BUT i get this warning :

Although had checked the security before :

when i check Oerride option it doeas NOTHING!?

what is wrong ? , plz help..

Re: Why exec Rename cmd Do not work? Security ?

pradosh_thakur — Mon, 28 May 2018 06:55:53 GMT

Well. It depends upon what version of Qlikview you are using.

Go through the below link. It's clearly explained. Let me know if you need more help or screenshot etc.

https://qlikviewcookbook.com/2016/01/authorizing-the-script-execute-statement/

regards

Pradosh

Re: Why exec Rename cmd Do not work? Security ?

olivierrobin — Mon, 28 May 2018 07:12:14 GMT

hello

be careful that your command is incorrect. You can't put a path in the renamed file name

EXECUTE cmd.exe /C rename 'D:\AA.XLSX' 'BB.XLSX' ;

Re: Why exec Rename cmd Do not work? Security ?

yanivvl0 — Mon, 28 May 2018 07:53:08 GMT

thanks Robin , i tried that but nothing happend .

in the exec log it looks like it do sometheing

but , AA REMAIN the same ..

Re: Why exec Rename cmd Do not work? Security ?

olivierrobin — Mon, 28 May 2018 07:56:06 GMT

are you sure file AA.XLSX is not in use by some process ?

Re: Why exec Rename cmd Do not work? Security ?

pradosh_thakur — Mon, 28 May 2018 08:01:40 GMT

Can you try putting the fie to be renamed in the same directory of cmd.exe and try . If this works then there is some error in the command else security has to be corrected.

Re: Why exec Rename cmd Do not work? Security ?

yanivvl0 — Mon, 28 May 2018 08:08:19 GMT

hi Thakur , my Ver is 12.1 ,

i try to run it strait on the server but still - no good ..

Re: Why exec Rename cmd Do not work? Security ?

Miguel_Angel_Baeyens — Mon, 28 May 2018 08:08:52 GMT

The REN/RENAME command takes quotes " instead of single quotes ' for the file parameters.

Re: Why exec Rename cmd Do not work? Security ?

yanivvl0 — Mon, 28 May 2018 08:10:20 GMT

yea , i'm sure ' its fictive file , its close , and nobody needs it.

Re: Why exec Rename cmd Do not work? Security ?

yanivvl0 — Mon, 28 May 2018 08:12:33 GMT

OK Miguel - this is the thing - THANKS !!