Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 528
• If you’re exporting to XML, you see the Specify XML and XSL Options dialog box.
Continue with step 8.
• If you’re exporting to any other file type, skip to step 9.
8. In the Specify XML and XSL Options dialog box, do the following:
• Specify the XML grammar to use by choosing either the FMPDSORESULT format or
the FMPXMLRESULT format.
• To apply an XSLT style sheet to the XML during export, select Use XSL style sheet
and specify the source of the XSLT style sheet. The XSLT source may be a file or the
result of an
HTTP request.
9. In the Specify Field Order for Export dialog box, indicate how you want FileMaker Pro to
export the data.
• When the Specify Field Order for Export dialog box opens, the tables list defaults to
Current Layout (LayoutName) and displays only the visible fields on the current
layout. To display all field names from the current table, choose Current Table
(TableName) from the list.
• If the current layout contains panel controls, only the fields that exist on the current
panel are displayed in the Specify Field Order for Export dialog box.
10. If necessary, for Output file character set, choose the character encoding you want the
exported file to use.
To Do this
Include a field in the export Double-click the field name to move it to the Field export order
area.
To include all fields in the export, click Move All.
Include a related field in the
export
Choose the name of the related table from the list in the upper-left
corner of the dialog box, and then move the fields you want into the
Field export order area. (You can include related fields before,
after, or between other fields being exported.)
Export grouped summary
values instead of individual
records
In the fields list on the left, click a summary field whose values you
want to summarize. In the Group by area, select each break field
by which you want the values summarized. Then click Move.
When you click Move, FileMaker Pro adds the summary field and
one or more grouped summary fields to the Field export order
area. (FileMaker
Pro adds one grouped summary field for each
break field you selected in the Group by area.) The grouped
summary fields use the syntax
SummaryField by
GroupByField
, such as “Total Sales by Region.”
Note You can’t export grouped summary values unless you sorted
the data before you started the export process. (The Group by
area shows “Unsorted” instead of any fields if data is not sorted.)
Remove a field from Field
export order and prevent its
data from being exported
For Field export order, choose a field, then click Clear.
To move all fields from the list, click Clear All.
Change the export order of the
fields
For Field export order, point to the double arrow to the left of the
field name and drag it up or down.