Designing a script to update info from a website

[davelhersh]

I'd like to know how I can design a script that will copy a group of prices from a web site, paste in FMP, & then divide each line into a separate record. Since prices change several times per day, this will allow me to quickly update & sort my records. I'm hoping someone can help me.

[mr_vodka]

I think we need more information here... You may even be able to use the webviewer and parse out the info that you need if there is some kind of consistency. Best if they had XML data... But again we need a little more info.

[davelhersh]

John,

I tried the web viewer and can't get exactly what I want with it. I'm trying to get updated fuel prices from truckstop web sites, then find the locations that are on my route and sort by price. I was able to do a web query in MS Excel. I think it will be perfect for the first step but I'd like to convert it to FM. When I tried that, it didn't work. I've been using FM for years and it seems to be a lot better at finding and sorting than Excel. Any help would be greatly appreciated.

[mr_vodka]

Take a look at these web scraping links.

http://www.filemakermagazine.com/videos/automated-web-scraping.html

http://web.mit.edu/ist/usergroups/filemaker/fmug/pres/scraping.pdf