Updated 7-2015 to include some new options

Quite often we want to take much of the data included in a FileMaker database and make it available to a large public 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 available to any person with an internet connection and web browser like FireFox, Safari, Chrome, or Internet Explorer. FileMaker can talk to the web.

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

  1. WebDirect (formerly IWP or Instant Web Publishing)
  2. 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)
  3. Connect to an existing web site database like MySQL or Microsoft SQL Server via ESS (External SQL Sources) and synchronize the data.
  4. Misc Other Methods

Option 1: WebDirect (formerly IWP or Instant Web Publishing)

WebDirect was released with FileMaker 13 and replaced IWP. We almost never recommended IWP. In versions of FileMaker before version 13, it converted FileMaker layouts automatically to web site pages on the fly. Although it is interesting technology, it was not easily scalable to many users and limited in its functionality and reliability.

WebDirect has the advantages of providing a user experience similar to FileMaker client without requiring an application to be installed (using only the browser). With FileMaker 14 it has been further optimized and can be used on some Android mobile devices. No traditional web developing skills are required. WebDirect is resource intensive for the server and not scalable to as many users as some of the other options.

Option 2: 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.

Option 3: 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 4: Miscellaneous

There are some other options for publishing FileMaker information to the web. These are basically wrappers for the FileMaker API for PHP:

  • FMEasyWeb – From Tim Dietrich
  • FileMaker WebSite – From Inner File Software
  • RestFM from Goya uses PHP code to turn your FileMaker Server into a RESTful Web Service so you can access your FileMaker Server databases via HTTP using a common REST architecture with easy to understand API calls.

The longterm viability of these methods and ongoing support of these technologies remains to be seen.


 

Here follow some resources for Learning and Utilizing the FileMaker API for PHP:

General PHP learning resources:

Tim Cimbura – CEO and Software Engineer

Tim is an expert in creating custom business solutions that make businesses more effective, productive, and profitable. He specializes in rapid application development with the Claris platform including FileMaker and WordPress. He also knows Apple macOS technology inside and out.