Eurocall ' 99
Université de Franche-Comté, Besançon, France
September 15-18, 1999
Understanding, using and creating web-enabled databases
Wednesday, September 15 from 09:30 to 17:00
Room 27, PropŽdeutique, 3rd floor

Getting Started: Creating a basic web-enabled database

- the down and dirty guide to creating a database and making it web-ready

Note: Unless you have experience working with FileMaker Pro, it would be best if you followed the instructions as indicated. This will facilitate trouble-shooting in case you experience problems.


Step 1: Creating a simple database with FileMaker Pro 4.1
    1. Open FileMaker Pro 4.1 (there should be a shortcut/alias on the desktop)
    2. Choose "Create a new empty file"
    3. Click OK
    4. Save as "mydatabase.fp3"
    5. Save the database in the "Web" folder inside the FileMaker Pro 4.1 folder. (This is necessary for web-enabling the database later.)
    6. Create the first field by typing in the field name (use "firstname")
    7. Hit Enter
    8. Create the second field (call it "lastname")
    9. Create the third field ( "L1")
    10. Click "Done"
    11. Under Mode on the menu choose New record
    12. Enter in data through FMP, i.e., fill in the three fields.

Step 2: Web-enabling your database

    1. Under Edit choose Preferences, then choose "Application..." in the submenu make sure default for network protocol is "TCP/IP"
    2. Select "Plug-Ins" and check the "Web Companion" box
    3. Click OK
    4. Under File on the menu, choose "Sharing"
    5. Select "Web companion"

Step 3: FileMaker's built-in "Instant Web Publishing"
    1. Open your favorite browser (Netscape Navigator or Microsoft Internet Explorer)
      Note: Do not quit FileMaker Pro, do not close your database
    2. Type in the location bar the following IP address: 127.0.0.1 (This IP address is the default address for the very computer you are working on)
    3. You cannow view, search, and add records to your database. Enter a record, switch back to the FileMaker Pro application, and check to see if records have been added.

Step 4: Creating customized HTML pages using Claris Home Page 3.0

To create an HTML interface we are going to use the program Claris Home Page 3.0

    1. Open Claris Home Page (a shortcut should be on your desktop)
    2. Under File, choose New
    3. Select "Use Assistant"
    4. Select "FileMaker Connection Assistant"
    5. Read Overview, then click Next
    6. In the box labeled "IP address" type 127.0.0.1, then click "Connect to Server". your DB should appear in the box on the right.
    7. Select your DB, then click the Next button
    8. On the next window, choose the first layout
    9. Click Next
    10. The next screen targets accessibility issues. for this DB, we want users to search and add data in the DB. Check those checkboxes.
    11. Click Next
    12. In the Search Page, after selecting each field click the "add" button. make sure all the fields are listed on the right hand column.
    13. Click Next
    14. On the next screen, just click Next
    15. On the Search Results page, after selecting each field click the "add" button. make sure all the fields are listed on the right hand column.
    16. On the Sort Results page, choose "No sort order"
    17. On the New Records Page, after selecting each field click the "add" button. make sure all the fields are listed on the right hand column.
    18. Click Next
    19. Read, then click Next
    20. On the Style page, choose a style (your choice)
    21. Click Next
    22. Read the Final hints and suggestions, then click Next (default page explanation)
    23. On the Location page, click the "New Folder" button
    24. For now, save new folder as "questions" in the FMP/web directory (same place as the DB)
    25. Click on Create. Claris Home Page generates a "readme.htm" file.
    26. Select the Site Editor window
    27. Make sure folder "questions" is selected
    28. Click on the Consolidate button (second from the right)
    29. Select "Selected file/folders" and click OK
    30. On the next screen, click on Consolidate

Step 5: Looking at your database through a browser
    1. Return to your browser (use the Finder for Macs, use the status bar or alt-tab on PCs)
    2. Click in the location bar, and after http://127.0.0.1 type in the name of the folder you created. In this case, you should have the following address: http://127.0.0.1/questions/

[Overview][Getting Started ][Conceptualizing][Using][Choosing][Designing][Hands-On]