topic Re: Accessing a data file on the internet from mathcad worksheet in Mathcad

Accessing a data file on the internet from mathcad worksheet

ebarsoukov — Thu, 03 May 2018 17:14:24 GMT

We have a problem with some of the mathcad tools that data-file they come with needs to be periodicallyupdated. The easiest way would be if we could like a file reading function to an internet locationof the latest file. But it does not appear to work. Is there any way to make it

Re: Accessing a data file on the internet from mathcad worksheet

Werner_E — Thu, 30 May 2013 20:46:31 GMT

Have never used it but just gave it a try:

READPRN failed, but

Menu: Insert / Data / File_Input

worked with http:// target, too.

As you mentioned vbscripts I'm assuming we are talking about real Mathcad (V15-).

Re: Accessing a data file on the internet from mathcad worksheet

tdevaraj — Fri, 31 May 2013 10:03:09 GMT

Yevgen,

Have a look at this link.

http://mathcadworksheets.blogspot.co.uk/2010/11/connecting-mathcad-to-internet-data.html

Regards,

Thomas

Re: Accessing a data file on the internet from mathcad worksheet

ebarsoukov — Thu, 20 Jun 2013 18:14:08 GMT

Thanks a lot. That works, and with data input wizard it works even with differnt data files like binary.

Now how about being able to un-compress a file inside mathcad? Some web-sites only allow

to put files on the web if they are compressed in *.zip format. Is there any way to load the zip file

as binary (that works, I tried) and than un-compress it inside mathcad itself?

I know that zip compression has been around for long time, so its algorithm is well known.

Did anybody implement the decompression in mathcad yet?

Regards,
Yevgen

Re: Accessing a data file on the internet from mathcad worksheet

Werner_E — Thu, 20 Jun 2013 18:47:34 GMT

I know that zip compression has been around for long time, so its algorithm is well known.
Did anybody implement the decompression in mathcad yet?

I've never seen an implementation and it wouldn't be that easy as there is not one but quite a lot of different compression algorithms possible in a zip-file. So you would be the first to implement a Mathcad zip decompression routine - if you finish, post it here please 😉

I can't provide the script but the best I could think of is fetch the zip-file in Mathcad and save it locally. Then, using a scripted component, decrompress is locally using one of the commandline decompression programs which sometimes accompany the zip-programs or maybe the GUI-version of your unzipper itself has a commandline mode.

Then you can load the unpacked file in MC the normal way.

Another way would be to try to fool the website in question by simply renaming the datafile to *.zip. Maybe even adding the magic two bytes "PK" in front of the file (in case the website looks for that signature of Phil Katz), which MC easily could discard.

Re: Accessing a data file on the internet from mathcad worksheet

ebarsoukov — Fri, 13 Dec 2013 16:49:28 GMT

Is there a way to load a binary file using similar method? I tried loading a binary file I get a string "d" as a result...