User manual

Importing and exporting data 12-7
Relationship
list
Type a name
for the
Choose a file
exported file
type that the
target
application
supports
5. Choose a file type from the Save as type list (Windows) or Type list
(Mac OS), then click Save.
6. In the Specify Field Order For Export dialog box, set the field
order as needed.
To Do this
Export fields Double-click a field to move it to the Field Order list. To
export all fields, click Move All.
Export fields from Choose a relationship from the Relationship list (see
a related file illustration on page 12-7), then move fields to the Field
order list. You can include related fields before, after, or
between fields in the master file.
Prevent data from Select a field in the Field Order list, then click Clear. To
being exported move all fields out of the list, click Clear All.
Change the export In the Field Order list, point to the double arrow for the
order of the fields field name and drag it up or down.
Export a grand Include the summary field in the Field Order list. Each
summary value  record will include the grand summary amount. If you
export subsummary values (page 12-8), the grand
summary amount is only in the first record exported.
Export subsummary See page 12-8.
values
FileMaker Pro
Select fields
exports these
from this list
fields
Choose a
character set
Choose a
formatting
option
7. Windows: Choose an appropriate Character Set for the platform or
application the exported file will be used with.
For example, if you’re exporting data to a Windows application,
choose Windows (ANSI).
8. Select a format option for the fields.
Suppose the current layout has a number field that’s formatted to
display two decimal digits and a currency symbol ($). When you
enter 3.7 into the field, FileMaker Pro displays $3.70 in Browse
mode. You can export the value with or without the formatting.
To export Select this option
Unformatted values (for example, 3.7) Don’t format output.
Values with the number, date, and time Format output using current layout.
formats from the current layout (for Symbols and other non-numeric values
example, $3.70) are exported as text. You can’t select this
option for SYLK, DBF, or DIF formats.
9. Click Export.
Keep these points in mind:
• To use an exported file, open an application that can read the file
format, then open the file. See “About file formats” on page 12-1 for
more information.