FileMaker Custom Web Publishing

Quite often we want to take much of the data included in a FileMaker database and make it available to a large audience without the need for them to own the FileMaker application and have it installed on their computer. To do this, we can utilize custom web publishing to make the information avaialable to any person with an internet connection and web browser like FireFox, Safari, Chrome, or Internet Explorer.

There are several ways to build customized web solutions based on FileMaker Pro:

  1. IWP (Instant Web Publishing)
  2. Connect to an existing web site database like MySQL or Microsoft SQL Server via ESS (External SQL Sources) and synchronize the data.
  3. Connect the web site directly to the FileMaker database as a backend via the FileMaker API for PHP (Application Programming Interface for the PHP language)

Option 1: IWP – Instant Web Publishing
We almost never recommend IWP. It converts FileMaker layouts automatically to web site pages on the fly. Although it is interesting technology, it is not easily scalable to many users and limited in its functionality and reliability. There is some speculation that it may no longer be supported in future versions of FileMaker Pro.

Option 2: ESS  - External SQL Sources
Connecting to an existing web site database via ESS is a great option especially if you need to scale your web site to thousands of users or the web site already exists. It also allows for division of development labor. One developer can be responsible for the front end user facing web site and another developer can work on the back-end administrative FileMaker database with lots of reporting features for use in the office.

We build custom web sites with WordPress and integrate them with FileMaker. It offloads the processing of the website completely to the web server and an associated MySQL database that we synchronize with the FileMaker solution. It makes use of the strengths of both platforms effectively.

Option 3: FileMaker API for PHP
The first FileMaker PHP interface was a product called fx.php. It is no longer used as much. The officially supported product for custom web publishing today is known as the “FileMaker API for PHP”. It can be a good option…and here we include a listing of some resources that will assist in learning more about the API.

Resources for Learning and Utilizing the FileMaker API for PHP:

General PHP learning resources:

 

If you have any other resources that you feel might apply, feel free to add a comment below.

Comments

  1. Hi Tim, I would add to the list of resources, our Bares Bones PHP pre-con sessions at the 2012 FileMaker Developer Conference in Miami.

    http://www.filemaker.com/developers/devcon/2012/schedule-monday.html

Speak Your Mind

*