Scraping Tables – Pulling Data Tables from Web Pages into FileMaker Pro | Learning Claris FileMaker | Scoop.it

A friend of mine (Douglas Alder) has, for a number of years, been using an older version of FileMaker to grab grooming reports from the local ski hill’s web site.

 

The ski hill put out their grooming reports as PDFs, so she would download these, then Copy and Paste to get the text into FileMaker.

Once in the database, a script runs that parses the grooming information into fields and records.  

The final stage is to generate a text file summary of recent grooming days for her phone (and smart watch).

It is a very useful data set (the previous 7 days of grooming reports) to have when you are out on the ski hill, looking for some corduroy or for finding those last remaining stashes of powder a couple of days after the last snowfall. 

 

The ski hill also published their data to a web page.

In an ideal world, this data would also be posted to a publicly available JSON file and FileMaker could easily parse that data into records.

 

Read more on the blog post ...