topic Re: Map a drive and get a file in QlikView

Map a drive and get a file

Tue, 14 Aug 2012 17:53:57 GMT

I need to map to a drive and then copy a file from that drive to our server. How would I do this?

Thanks,
Stephen

Re: Map a drive and get a file

Jason_Michaelides — Tue, 14 Aug 2012 18:01:26 GMT

From within QlikView?

Re: Map a drive and get a file

Tue, 14 Aug 2012 18:02:57 GMT

Yes, the script needs to map the drive and and get the file so the script can then "process" the file.

Stephen

Re: Map a drive and get a file

Tue, 14 Aug 2012 18:03:04 GMT

Yes, the script needs to map the drive and and get the file so the script can then "process" the file.

Stephen

Re: Map a drive and get a file

Jason_Michaelides — Tue, 14 Aug 2012 18:14:07 GMT

Try using the EXECUTE function to call a .bat file that uses the "net use" command.

Re: Map a drive and get a file

Tue, 14 Aug 2012 18:15:52 GMT

Yes, that is what I currently am doing. But I would like to get it all into a QV document.

Stephen

Re: Map a drive and get a file

Jason_Michaelides — Tue, 14 Aug 2012 18:23:28 GMT

I don't think there's a COPY command within QV - that's not really what it's for. Why are you not able o use a simple bat file? You may not even have to use "net use" - a simple copy coats and a UNC path should suffice.