Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Check the Settings tab in the script editor and make sure the option Can Execute External Programs is enable.
Thanks for getting back to us. I do have those settings in place.
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.