User manual

Importing and exporting data 12-7
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.
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.
9. Click Export.
Keep these points in mind:
1 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.
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
a related file
Choose a relationship from the Relationship list (see
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
being exported
Select a field in the Field Order list, then click Clear. To
move all fields out of the list, click Clear All.
Change the export
order of the fields
In the Field Order list, point to the double arrow for the
field name and drag it up or down.
Export a grand
summary value
Include the summary field in the Field Order list. Each
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
values
See page 12-8.
Choose a file
type that the
target
application
supports
Type a name
for the
exported file
To export Select this option
Unformatted values (for example, 3.7) Don’t format output.
Values with the number, date, and time
formats from the current layout (for
example, $3.70)
Format output using current layout.
Symbols and other non-numeric values
are exported as text. You can’t select this
option for SYLK, DBF, or DIF formats.
Select fields
from this list
Relationship
list
Choose a
formatting
option
Choose a
character set
FileMaker Pro
exports these
fields