Sunday, November 23, 2008

Filemaker Pro Database Instant Web Sharing (IWS)

How to set Filemaker Pro 9 to share your database as a website on the internet.

~
Open your database in Filemaker Pro 9 from the computer you wish to Host the database. I know at least FMP 6 - 9 can publish databases on the web. I will refer only to FMP 9.
Goto: File>Sharing>Instant Web Publishing...
Turn on Instant Web Publishing to publish all open and available databases on the web.
Change the port to 591. Click OK.
For now leave the Instant Web Publishing access to file, to All Users, you can change this at your own discretion.
Your Currtently open files should be listed. Click OK.
Goto: File>Manage>Accounts & Privileges...
Make sure Admin is turned on, select Admin, Click on Edit...
Set a Password. Click OK.
If you have a Router, you must:
Open the start/end/internal/external TCP port (AKA, gateway, pinhole, service) 591 and specify which computer IP is hosting the FMP database file in your LOCAL network (LAN). For example, 192.168.1.4, is the host computer IP with the FMP database open and running in the local office network. Find this number by logging into your router and identifying the database host computer and its LOCAL IP address. That is, inquiries from the outside world to your host computer that have FMP data, will be forwarded by your router to your specified local network host computer 192.168.1.4 through port 591.
Find out the IP address of your WAN (wide area network), that is, get the IP address that your broadband carrier assigns you (for example, 60.123.4.123), or know your domain name (for example, domain.name.com)
Close and restart FMP 9.
Your database web server setup is now complete.
From a remote location inside the office or outside of the local network, open a web browser and do the following:
In the address bar, type in the static IP address or domain name with the addition of :591 at the end, for example, http://60.123.4.123:591 or http://domain.name.com:591.
If you have a dynamic IP that changes when the router is restarted or if there is a power failure, you can obtain a static pseudo domain name from sites such as www.no-ip.com.
The Filemaker web page should appear with your file available as a link.
Click on the link and log in as admin with the password.
Certain dynamic functions from FMP are not available on a static web page. One thing that is missing is Preview mode. Functions requiring the preview mode such as displaying label sheets for printing are not possible through Instant Web Sharing and require Network Sharing with a remote FMP 9 client connection to the server.
~

No comments: