topic Re: Help on EXECUTE command in QlikView

Help on EXECUTE command

dmohanty — Thu, 03 Oct 2013 14:03:30 GMT

Hi Friends,

I wanted to know the logic and functionality of EXECUTE command. Looking into the Help, I am tring to Execute a Excel File like below:

EXECUTE C:\MyFiles\QlikView Documents\SalesData.exe;

First its asks with a Prompt like this:

Finally its failing with and error: The EXECUTE statement requires the Execute flag to be set for the script.

How to deal with these? Could you please help me in explaining the Logic and Way to work with EXECUTE command?

Regards!!!

Re: Help on EXECUTE command

Clever_Anjos — Thu, 03 Oct 2013 14:06:35 GMT

Mark that check to enable running external programs

Re: Help on EXECUTE command

srchilukoori — Thu, 03 Oct 2013 14:07:29 GMT

check the "Can execute external programs" in the script editor.

Re: Help on EXECUTE command

dmohanty — Thu, 03 Oct 2013 14:18:47 GMT

I see...Thanks...Now its not asking for any prompt!!!

But still its failing due to Syntax issue. What could be it?

EXECUTE C:\MyFiles\QlikView Documents\SalesData.exe;

SalesData is stored in an Excel File.

Regards!!!

Re: Help on EXECUTE command

dmohanty — Thu, 03 Oct 2013 14:27:17 GMT

Hi,

Infact my requirement is like this:

I have a Excel Sheet in some shared folder. I have to COPY it to my Local folder and use that Excel in QlikView.

So what would be the syntax to write the EXECUTE command in QlikView to COPY from one location to another?

Re: Help on EXECUTE command

srchilukoori — Thu, 03 Oct 2013 15:10:40 GMT

create a batch file and use the following syntax

Execute "<absolute path to bat file>\<Filename>.bat"

Re: Help on EXECUTE command

abeyphilip — Thu, 03 Oct 2013 15:23:28 GMT

Hi,

Does the command work fine if you run it explicitly from the cmd prompt?

See if this helps:

EXECUTE cmd.exe /C COPY /Y "\\<IP Address>\c$\Qlikview\SourceDir\ABC.xls" "C:\QlikView\TargetDir\"

This will copy ABC.xls from c:\Qlikview\SourceDir on server with IP address - <IP Address> to C:\QlikView\TargetDir\ of your local system.

Regards,

Abey

Re: Help on EXECUTE command

shree909 — Thu, 03 Oct 2013 15:30:09 GMT

Hi,

i know that when u check the " can execute external programs"

u will not get that error , but when u close the application or move to other place then it will start complaining.

So what u need to do is go to Settings-->User Preferences-->Security--> then check the option

"Script( Allow database write and execute statements") this will fix the problem forever..

Use EXECUTE cmd.exe /c MOVE " soure folder path" "Destination Folder path"

Re: Help on EXECUTE command

dmohanty — Fri, 04 Oct 2013 06:53:46 GMT

Hi Abey/Shree,

I have not tested in CMD.

Is it required to create Batch file for that? How to test in CMD? The same same above command will work?

Regards!!!

Re: Help on EXECUTE command

abeyphilip — Fri, 04 Oct 2013 07:00:52 GMT

Hi,

Yes - you don't need a batch for this. You can include that line directly in your load script. Only change the path to your requirement.

Regards,

Abey

Re: Help on EXECUTE command

Wed, 17 Feb 2016 05:31:06 GMT

Hi DMohanty,

goto user preferences - > Security -> script(Check this option)

Then you run your script

Thanks

Avinash Kuraku