I have a need to get the latest metal prices frequently from a web page, the data is posted daily in the same format at the site. After downloading the page in text format it will be easy to extract the daily prices and place into proper fields. My question is how can I have FMP 6 automatically go to this url and import a text file version of that page? Plug-ins?......?

Thanks for any ideas.

Rod

If you're on a Mac, Dave Dowling has a great little file that does this with AppleScript:

http://www.davedowling.com/download.htm

Cross-platform, Troi has a URL plug-in. I haven't used it but it can do quite a bit.

Also try the plug-in page at http://www.digfm.org/

Hi Fenton,

It's a OS10 only.

Too bad, I was really wanting to see how this worked.

Lee

Thanks a Lot Fenton, exactly what I was looking for!...

Have a great holiday.

Rod

A final note to this thread for anyone using the applescript Fenton recommended by Dave Dowling, I had an issue due to slow page download on the site I was importing. I wrote a note to Dave and he advised the following, thanks to him for the example, and also some help in fixing the problem.

The applescript will error out with a message about the variable myText if the page is not fully downloaded in Safari before the applescript aquires the text. If this happens change the length of the delay variable set up in myDelay, in the example as downloaded this delay is set to one, I put it at 5 for this particular site and it works fine.

Many thanks to Fenton and Dave Dowling for this one, it saved me a lot of time!..

Rod