Developer’s Guide

Publishing your database on the Web 6-17
5. To export one record that subtotals multiple records, click
Summarize by. Then, in the Summarize by dialog box, click to the left
of the field you want to use as the break field. A check mark appears
to the left of the field. (You must have set up one or more summary
fields and sorted by the break field in the database.) Click OK.
In the Specify Field Order for Export dialog box, FileMaker Pro
creates italicized temporary export fields in the Field Order list based
on the break fields you specified. For example, if you have a
summary field named Count and you select the break fields Category
and Unit, the export field list contains Count, Count by Category,
and Count by Unit.
6. Select Don't format output if you want to ignore number, date, and
time field formatting (for example, to export a number as 3.7 instead
of as $3.70).
7. Select Format output using current layout if you want to use number,
date, and time field formatting as specified for the included fields on
the current layout (for example, to export a number as $3.70 instead
of as 3.7). Symbols and other non-numeric values are exported as
text.
8. Click Export.
FileMaker Pro saves the data in table format in an HTML file. Each
field you specified becomes a column heading in the table and each
record becomes a row.
Testing your site without a
network connection
You can set up your computer to test the Web Companion and your
web site before uploading your site files and databases to the host
web server or dialing up to an Internet service provider (ISP).
To set up your computer to act as a single-machine network, enable
and activate TCP/IP networking. On Windows machines, this is
usually already set up for you (if you can connect to the Internet, then
TCP/IP networking is active). On Mac OS machines, one way to set
up TCP/IP networking is to create a new TCP/IP control panel
configuration that connects via Ethernet to any IP address manually.
(For information on setting up TCP/IP networking, see the
documentation that came with your operating system.)
Once you’ve set up your computer to act as a single-machine
network, you can type http://localhost in your web browser
and the FileMaker Pro Web Companion will serve the HTML pages
that are located in the Web folder as well as any open databases that
are shared via the Web Companion—without connecting to the
Internet or intranet.
Tip To thoroughly test your web site, click on every link that exists
in your custom web pages under every possible situation, with your
databases open, with (and without) any records existing in each
database. Did you catch all the errors and create an error message for
each of them?