Administrator’s Guide
Table Of Contents
- Preface Introducing FileMaker Pro 5.5 Unlimited
- Chapter 1 Installing the FileMaker Web Server Connector
- Chapter 2 Administering the Web Server Connector
- Chapter 3 Publishing your database on the Web
- Types of web publishing
- Using the FileMakerPro Web Companion
- Creating a custom home page
- Creating a custom home page for Instant Web Publishing
- Creating a custom web site using a database layout
- Web Companion support for Internet mediatypes
- Monitoring your site
- Exporting data to a static HTML page
- Testing your site without a networkconnection
- Opening password-protected databasesremotely
- Chapter 4 Custom web publishing using CDML
- About the CDML examples
- General steps for custom web publishing using CDML
- About CDML format files
- Generating FileMakerPro CGI requests using CDML
- Using the CDML Tool and templates
- Modified CDML tags
- About the CDML Reference database
- Creating error messages
- Using an encoding parameter with a CDML replacement tag
- Planning your web site
- Chapter 5 Using FileMakerPro XML to deliver your data
- About the XML examples
- General process for custom web publishing using XML
- Generating an XML document
- Using the FMPDSORESULT grammar
- Using the FileMakerPro Extended XMLgrammars
- About UTF-8 encoded data
- Generating FileMakerPro CGI requests for an XML document
- Using style sheets with your XMLdocument
- Comparing CSS, XSLT, and JavaScript
- Looking at the XML Inventory example
- Chapter 6 Using Java and JDBC to deliver your data
- About the JDBC examples
- About JDBC
- Using the FileMaker JDBC Driver
- SQL supported by the FileMaker JDBCDriver
- FileMakerPro support for Unicodecharacters
- About the FileMaker JDBC Driver interfaces and extensions
- Example 1: Looking at the FileMakerPro Explorer application
- Example 2: Creating the JBuilder Inventoryapplication
- Example 3: Creating the Visual Cafe Inventory application
- Using the FileMaker Java classes
- Appendix A Valid names used in CGI requests for FileMaker XML data
- Generating a –find, –findall, or –findany request
- Generating a –view request
- Generating a –new request
- Generating an –edit request
- Generating a –delete request
- Generating a –dbnames request
- Generating a –layoutnames request
- Generating a –scriptnames request
- Generating a –dbopen request
- Generating a –dbclose request
- Specifying parameters for the request
- –db (Database)
- –lay (Layout)
- –format (Format)
- –recid (Record ID)
- –modid (Modification ID)
- –lop (Logical operator)
- –op (Comparison operator)
- –max (Maximum records)
- –skip (Skip records)
- –sortfield (Sort field)
- –sortorder (Sort order)
- –script (Script)
- –script.prefind (Script before Find)
- –script.presort (Script before Sort)
- –styletype (Style type)
- –stylehref (Style href)
- –password (Database password)
- field name (Name of specific field)
- Appendix B FileMaker Pro values for error codes
- Appendix C Enabling the FileMaker Pro Web Companion in MacOS X
- Index
Publishing your database on the Web 3-9
Now when you enter your computer’s IP address or “localhost” in
the web browser, the Web Companion will display the database
layout for your custom home page in the browser window.
Using script buttons in Instant Web Publishing
You can provide special script buttons in your FileMaker Pro layout
to work with Instant Web Publishing. When web users click on a
button in the browser, the script’s URL is sent to the Web
Companion as a FileMaker CGI request.
If the script is a single script step, an onClick JavaScript event
handler is executed and a URL is generated containing the current
state information in the browser and information from the script step
extracted by the Web Companion.
If the script contains multiple script steps, state information from the
first three supported steps is extracted to construct a JavaScript state
object (scriptState) that encapsulates the result of the executed script.
The resulting information is passed to the JavaScript runtime
application (Instant Web Publishing), which interprets the state
object, builds the resulting URL, and sends the CGI request to the
Web Companion.
Note For information about FileMaker CGI requests made in custom
web publishing, see “Generating FileMaker Pro CGI requests using
CDML” on page 4-3 and “Generating FileMaker Pro CGI requests
for an XML document” on page 5-8.
Requirements for Instant Web Publishing buttons
A button that you’re using in a layout for Instant Web Publishing
may have a single valid script step attached to it or a script containing
1 to 3 valid script steps.
If you’re using multiple text and graphic objects for a button, the
script or script step must be attached to the topmost object in the
group. Create the text and graphic elements first, group them, and
then attach the script to the group.
Single script steps supported for Instant Web Publishing
In FileMaker Pro 5.5 and FileMaker Pro 5.5 Unlimited, the Web
Companion supports the following single script steps for buttons
used in Instant Web Publishing layouts.
FileMaker script step CGI request Description
Open [<Document name>] Open database in
browser window
Equivalent to opening the
database from the Instant
Web Publishing home
page.
The database must be
specified as a script
parameter, and it must be
open in FileMaker Pro.
Open URL [<url>] Set window location
to the specified URL
Use this with a text field
or calculation field with a
text result to construct
target URLs.
The URL must be
complete (e.g. include
http://) and can go to
another web site or
contain a FileMaker CGI
request.
Go to Layout [<Layout
Name>]
Go to specified
layout
This will not affect other
current parameters for
location.
The generated URL link is
based on the default URL
of the database plus any
settings made for startup
script and layout, and
specified record in a
relationship.
Also supported in a multi-
step button.