topic Re: Using DOS Commands in Qlikview Script in QlikView

Using DOS Commands in Qlikview Script

Fri, 17 Jan 2014 19:25:26 GMT

Hello Forum,

I am trying to do a simple copy/paste in DOS using Qlikview Script. Here is what I am doing. It is pretty simple:

Execute cmd.exe /C net use \\ServerName009\dbsrvr1;

Execute cmd.exe /C E:;

Execute cmd.exe /C copy \Qlikview\Data\Day17\test.qvd \Qlikview\Data\Today;

When I type these exact commands, in this order, in a DOS prompt, it works well and copies test.qvd from the "Day17" folder to the "Today" folder. I am trying to figure out why this won't work in a script. Can someone please advise on what could be the issue here?

Thanks much!

Re: Using DOS Commands in Qlikview Script

Gysbert_Wassenaar — Fri, 17 Jan 2014 21:04:07 GMT

Check the Settings tab in the script editor and make sure the option Can Execute External Programs is enable.

Re: Using DOS Commands in Qlikview Script

Fri, 17 Jan 2014 21:11:10 GMT

Thanks for getting back to us. I do have those settings in place.

Re: Using DOS Commands in Qlikview Script

swuehl — Sat, 18 Jan 2014 10:01:14 GMT

I assume the context is lost between your separate command executions, i.e. when changing to E: and then using a relative file path in the next command.

I would suggest putting your commands in a small .bat file and call the single batch file from within QV script.