09-03-2015 02:48 PM
Hello,
I assumed this would be easy but I'm not having any luck here.. I'd like to create a VI to read each of the .cvs file located on a local web server (see imagesfor more detail). Any suggections?
Thank You
Pete
Solved! Go to Solution.
09-03-2015 02:51 PM
What have you tried?
You should be able to open a file on the server. What have you entered as your file path?
09-03-2015 02:58 PM
At the most basic level, I tried simply a Read speadsheet file. See attached image..
'
I can paste that same path in the Open dialog of excel and the data loads perfectly..
09-03-2015 03:16 PM
http:\\ shouldn't be part of the file path.
Try \\10.201.76.20\rest of the path.................
09-03-2015 04:00 PM
Still no luck
09-03-2015 04:02 PM
Different error.
Are you sure that file exists?
Try from the run prompt in windows.
09-03-2015 04:07 PM
@PJackson wrote:
I can paste that same path in the Open dialog of excel and the data loads perfectly..
That's because Excel is doing some fancy path parsing, sees the URL, and loads the file from the web rather than from the local disk. This is in no way standard behavior (although maybe it will be in a few years). Until then, you cannot treat a URL - an address of a file on a remote web server - like a local file. RavensFan's suggestion might work if you have set up file sharing on the remote computer, but then you're doing file sharing, not downloading from the web. To download a file from the web, use the HTTP VIs, or a Datasocket Read, which is probably the easiest option here. For Datasocket Read, provide the URL (http://10.....) as the Connection In, and wire an empty string to Type. You'll get the entire file as string on the data output, which you can feed to Spreadsheet String to Array to get an array.
09-03-2015 04:37 PM
HTTP Get did the trip.. No luck with DataSocket but didn't give it too much effort. Thank you all for the quick help.
Pete