Jump to content
Server Maintenance This Week. ×

populating filemaker table wih data from a web table?

goanna300

By goanna300
in External Data Sources

 Share

This topic is 4475 days old. Please don't post here. Open a new topic instead.

Recommended Posts

comment Grand Master

comment

Posted
Posted

It's possible, though it's certainly no fun - and anytime the webmaster decides to change anything, your solution fails. You need to look at the HTML code of the web page, available through the GetLayoutObjectAttribute() function, and parse out the data out of there using some "navigation points" that you think (hope) are constant, for example: the second <table> element, third row, fifth cell.

Link to comment
Share on other sites
goanna300 Contributor

goanna300

Posted
  • Author
Posted

I know how to do it using php (fopen,fread and fprint) and insert, I could also probably use page-scraping via Curl;I could probably manage it via an intermediate step. I could also do it in excel and script an import into Filemaker - again a two-step process; a pain and error-prone.

But it's a snap in excel I thought it would be a sought-after feature in FMP

.

@bcooney - the page's xml as presented on the site is all I need; in the past I've used Yahoo's currency exchange rates to add to an Excel spreadsheet of my own holiday budget. After a week or so the Indonesian Rupiah rate goes up, my Excel database refreshes and automatically displays how much my daily Bali holiday allowance will be for each item: banana smoothies, massages and house by the beach.

I'll look up what ESS IS.

@comment

Can you give me a better idea of ho to use GetLayoutObjectAttribute() ?

For example, If wanted the "Slogan of the Day" from http://home.exetel.com.au/re/ to appear in a database field, how would I connect to that URI and parse out the slogan text from:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<meta content="text/html; charset=ISO-8859-1"

http-equiv="Content-Type">

<title>We only subsist.</title>

</head>

<body>

<br>

We only subsist.<br>

</body>

</html>

Link to comment
Share on other sites
comment Grand Master

comment

Posted
Posted

For example, If wanted the "Slogan of the Day" from http://home.exetel.com.au/re/ to appear in a database field

See the attached example.

ScrapeExample.zip

the page's xml as presented on the site is all I need;

XML is very different from a "web page"; Filemaker can import XML directly from a remote site, as long as it can be retrieved by a GET request.

Link to comment
Share on other sites
goanna300 Contributor

goanna300

Posted
  • Author
Posted

I posted this because somehow I'd expected Filemaker to include some sort of WYSIWYG table-data-sync like excel; when I look for features and cannot find them I rarely presume that the features just aren't there in the first place!

@comment:

The scrape file seems straightforward, thank you.

Since my randomly chosen scenario was over-simplified, can you please take a look at the Brisbane Weather page for the next 7 days and tell me if the GetLayoutObjectAttribute function could still somehow be used with all the multiple field values? I magine I'd have to repeat something like your "Scrape" script multiple times.

I remember once (in a government website job, limited in what tools I had available), I did a two-step scrape of a table via Google Docs. As with Excel, inelegant but worked.

XML is very different from a "web page".

Sorry, I meant XHTML, not XML.

Link to comment
Share on other sites

This topic is 4475 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept