Script Steps Reference

68 FileMaker Script Steps Reference
Note You can export records as a Microsoft Excel worksheet by choosing Excel from
the File Type list. For more information on saving FileMaker Pro files as Excel files,
see FileMaker Pro Help.
If you specify XML as the export file type, the Specify XML and XSL Options dialog
box appears, where you can specify an XML grammar and choose an XSLT style
sheet if you want to transform the XML. The XSLT source may be a file, the result of
an HTTP request, or a calculation that generates a file path or an HTTP request.
Note Do not export fields whose name is entirely numeric (such as "2") or whose name
is a single-byte kana character (Japanese version) using the FMPDSORESULT
grammar.
• Select Specify export order or click Specify to use the export order that was in
effect when you added the script step. The last export order used in the file appears
as the default and can be edited or deleted. If necessary, choose an output file
character set from the drop-down list. Select Apply current layout’s data
formatting to exported data, or the formatting of the last exported data will be used.
Web compatibility
This script step is not web-compatible.
Description
Exports records to a specified file. You can set the export order before adding this script
step, or perform the step with a dialog box so a user can set new criteria. Export Records
exports all the records currently being browsed. If you want to limit the set of records
you're exporting, use a find request before using Export Records.
Example
Go to Layout ["Layout #4"]
Export Records [No dialog, "Contacts"]
Save Records As Excel
Format
Save Records As Excel [No dialog; “<output filename>”;
Automatically open; Create email; Current record]
Note In order to save records as a Microsoft Excel worksheet, your privilege set must
include Allow exporting, or you must select Run script with full access privileges in
the Edit Script dialog box.
Options
• Perform without dialog prevents the Excel Options dialog box from displaying as
the script step executes if you have already specified a file. If you have not specified
a file, the Save Records as Excel dialog box displays as the script step executes, but
the Excel Options dialog box is not displayed.