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
3-16 FileMaker Pro 5.5 Unlimited Administrator’s Guide
A formula for an external function requires the name of the external
function to call and the function’s parameter.
7. Replace the word “parameter” with the required parameter for the
function (0, field name, or text value).
See the next table for a description of the Web Companion external
functions and their parameters.
8. Continue to build the formula as desired and click OK when you’re
done.
9. Click Done to close the Define Fields dialog box.
For more information, see chapter 11, “Using formulas and
functions,” in the FileMaker Pro User’s Guide or see FileMaker Pro
Help.
Exporting data to a static HTML page
To quickly display the existing data in your FileMaker Pro database
on the Web, you can export it into an HTML table and publish your
database as a static web page. To automate the exporting process on
a regular basis, use a FileMaker Pro script and control the timing for
when the exported table is uploaded to the web site.
Note Images in container fields cannot be exported. To display them
on your web site, place the image files in the Web folder and insert
reference links to them in a text field in the database (or insert image
links in the exported HTML table).
To export the data into an HTML table:
1. Open the FileMaker Pro database and create a sorted found set
with the records you want to export.
If you are going to export subsummary data, include the break field
in the sort order.
2. In Browse mode, choose File menu > Export Records. Type a name
and select a location for the exported file. Then, choose HTML Table
Files (Windows) or HTML Table (Mac OS) for the file type, and click
Save.
External function’s name
and parameter Description of external function
Web-Version, 0 Returns the version of FileMaker Pro Web
Companion that loads when you open
FileMaker Pro
Web-ClientAddress, 0 Returns the domain name (for example,
www.filemaker.com) of a web user whose HTTP
request is currently being processed by the Web
Companion. Returns the web user’s IP address if the
domain name is not available.
Web-ClientIP, 0 Returns the IP (Internet protocol) address of the
web user whose HTTP request is currently being
processed by the Web Companion
Web-ClientName, 0 Returns the value that the web user types for a
user name in the web browser password dialog
box
Web-ClientType, 0 Returns the name and version of the web
browser being used by the web user
Web-ToHTML, field name
Web-ToHTML, text value
Returns the contents of the specified field or text
value encoded in HTML. This is useful, for
example, when you want to modify a data field
with a calculation and then use it as an error
page.
Web-ToHTTP, field name
Web-ToHTTP, text value
Returns the contents of the specified field or text
value encoded in HTTP. This is useful for fields
containing data that should be handled as URLs
in HREF links by the browser. For example,
“Display Art” becomes “Display%20Art.”
External function’s name
and parameter Description of external function