Often there are "feeds" meant to do this. You should research the website for this possibility.
You may also get answers for "scraping-the-website" and I have done this (with permission from the website) but that can be prone to errors, should they make changes and not notify you. Typically, you read the contents of the web page and extract by searching for a pattern.
Research the script step "Insert from URL". <http://www.filemaker.com/help/14/fmp/en/html/scripts_ref1.35.50.html>
Also, there may be plug-ins to assist with this process.
Importing data from a database on line to my FileMaker database...
created by user447 in Discussions - View the full discussion
Is there a way to connect to a database on line - for instance the library of congress, and if entering the ISBN number in MY database, have the data from the library of confess database transfer to my Filemaker database?Impor
Hi user 447,
The short answer to your question is "generally yes".
The longer and more specific answer to connecting to a specific online database is "maybe" or "it depends".
So, the "depends" is mostly due to two main reasons:
- Which online database and does it provide access methods that can be implemented programmatically in FileMaker (in what is typically referred to as "EDI"). This has to do with whether they allow other computers running database software (such as FileMaker) to "plug" into or download data from their system, which is different from just a user name and password as would be normally granted to a person.
- Are those connectivity options readily supported by FileMaker, and if not, what remedies may need to be implemented to integrate that system with FileMaker.
So, the "devil", as they say, is in the details.
If Library of Congress is the specific database you wish to connect to, I suggest you begin by looking at these pages:
Then, look at FileMaker's Training Series and other online literature on “Integrating with Other Data Sources”.
Hope that helps,
Thank you so much!