1 Reply Latest reply on Aug 1, 2009 11:32 AM by davidanders

    How Do I Export a Database to Make It Web-Usable?

    poingferret

      Title

      How Do I Export a Database to Make It Web-Usable?

      Post

      Guys, I created a simple database that I want to put up on a web site so users can log in as needed, perform quick searches and add records.

       

      I'm using FileMaker Pro 10 for the Mac...so, what's the best way to go about this and then upload it?

       

      Any help would be appreciated and thank you.

       

      Chris

        • 1. Re: How Do I Export a Database to Make It Web-Usable?
          davidanders
            

          A database file needs to be running in the database application to be used.

          A common database on websites is mysql.

          It is much more rare to find a web hosting company that runs Filemaker.

           

           

          FileMaker Database with One User [Using Filemaker Pro]
          1] Filemaker is installed on one computer, the database is on the computer or a network device and is set to single user and can be opened by one user.
          2] A stamdalone database runtime is created in Filemaker Pro Advanced. One user and it’s design can not be changed.
          Pros - inexpensive Cons - limited access

          FileMaker Database with Multiple Users [Using Filemaker Pro]
          1] Filemaker is installed on all computers, a copy of the database is on all the computers.
          2] The Main copy of the database is on one of these computers. Changes to the Main have to be distributed to the other copies, or the changes on the other computers have to be imported or entered into the Main DB copy.
          Pros - inexpensive Cons - limited access and inconvenient and prone to error

          FileMaker Database with Multiple Users on the same local network [Using Filemaker Pro]
          1] Filemaker is installed on several computers on a local network. One user (or a server) opens the database with Filemaker Pro that is set to multiple users. The other users open Filemaker, choose Open Remote, and they see the hosting computer’s shared databases. This is possible because they share a local network.
          OR the local users open a web browser and can use the Instant Web Publishing capability of the Filemaker Pro application.
          Pros - less expensive Cons - limited to 9 or 10 Filemaker users and 5 concurrent IWP users.

           

          FileMaker Database with Multiple Users on the internet [Using Filemaker Pro]
          1] The hosting computer has a static IP address (or the router is set to forward specific port requests to the Filemaker computer). The computers outside the local network can connect with Filemaker or a web browser.
          Pros - less expensive Cons - limited to 9 or 10 Filemaker users and 5 concurrent IWP users.

          FileMaker Database with Multiple Users on the same local network [Using Filemaker Pro Server]
          1] Filemaker Server runs on one computer, Filemaker is installed on several computers on a local network. The server opens the database with Filemaker Pro Server. The other users open Filemaker, choose Open Remote, and they see the hosting computer’s shared databases. This is possible because they share a local network.
          Pros - 100 or 250 Filemaker users Cons - Expensive

          FileMaker Database with Multiple Users on the internet [Using Filemaker Pro Server]
          1] The server has a static IP address (or the router is set to forward specific port requests to the Filemaker server). The computers outside the local network can connect with Filemaker.
          Pros - 100 or 250 Filemaker users Cons - Expensive.

          FileMaker Database with Multiple Users on the same local network [Using Filemaker Pro Server Advanced]
          1] Filemaker Server runs on one computer, Filemaker is installed on several computers on a local network. The server opens the database with Filemaker Pro Server. The other users open Filemaker, choose Open Remote, and they see the hosting computer’s shared databases. This is possible because they share a local network.
          OR they can open a web browser and can use the Instant Web Publishing capability of the Filemaker Pro
          Pros - 100 or 999 Filemaker users & 100 IWP sessions Cons - Very Expensive

          FileMaker Database with Multiple Users on the internet [Using Filemaker Pro Server Advanced]
          1] The server has a static IP address (or the router is set to forward specific port requests to the Filemaker server). Any computer on the internet can connect with Filemaker.
          OR any internet computer can open a web browser and can use the Instant Web Publishing capability of the Filemaker Pro application.
          2] OR the database is Hosted on an Web Hosting Service that specializes in FMP hosting
          Pros - 100 or 999 Filemaker users & 100 IWP sessions Cons - Very Expensive.

          Web Publishing with Instant Web Publishing
          Instant Web Publishing is fairly easy, built into Filemaker Pro (5 users) and Filemaker Server Advanced (100 users).
          IWP is limited and frustrating to get exactly right, IWP takes a Filemaker layout and converts it to dirty JavaScript.
          Record viewing is limited to 25 records on a single page without hitting a button, for instance.
          Backgrounds, images, font size and script steps are limited compared with using Filemaker.

          Web Publishing with PHP
          www.fmwebschool.com has software (FMStudio) that in conjuction with Dreamweaver, allows more sophisticated designs and less restrictions. It also adds the complication of knowing how to use Dreamweaver. It also requires that your run or pay a hosting service to run Filemaker Server or Filemaker Server Advanced. So the cost of FMStudio $125 and Dreamweaver $200 to $300 and FM Server $1000 or a hosting service.

          Web Publishing with XLST
          http://www.filemaker.com/support/technologies/xslt.htm
          Built into Filemaker Server or Filemaker Server Advanced. Programming knowledge. Experts can be difficult to find.