Script Steps Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Control script steps
- Chapter 3 Navigation script steps
- Chapter 4 Editing script steps
- Chapter 5 Fields script steps
- Set Field
- Set Next Serial Value
- Insert Text
- Insert Calculated Result
- Insert From Index
- Insert From Last Visited
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert QuickTime
- Insert Object (Windows)
- Insert File
- Update Link (Windows)
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Chapter 6 Records script steps
- Chapter 7 Found Sets script steps
- Chapter 8 Windows script steps
- Chapter 9 Files script steps
- Chapter 10 Accounts script steps
- Chapter 11 Spelling script steps
- Chapter 12 Open Menu Item script steps
- Chapter 13 Miscellaneous script steps
- Appendix A Glossary
66 FileMaker Script Steps Reference
Go to Layout ["History table"]
New Record/Request
Paste [Select; History table::History]
Commit Records/Requests[]
Import Records
Format
Import Records [No dialog; “<source or filename>”; Add/Update
existing/Update matching; <platform and character set>]
Options
• Perform without dialog prevents display of import-related dialog boxes when the
script step executes. However, if a data source file has not been specified, the Open
File dialog box will be displayed.
• Specify data source lets you choose the file or source of the data to be imported.
Depending on the file or source you choose, a dialog box may appear for specifying
the following additional options:
• Specify import order tells FileMaker Pro to use a predefined import order. The last
import order used in the file appears as the default and can be edited. This option
also lets you choose whether to keep repeating field data together or to split
repeating fields into separate records, as well as whether to add new records, replace
data in the current found set, or import data as a new table.
When you
choose this file
or source
Do this
File In the Specify File dialog box, choose the file you want to import, or type file paths
directly into the list. Specify one path per line. FileMaker Pro will use the first path
it locates as the file to import. See FileMaker Pro Help.
Folder In the Folder of Files Import Options dialog box, choose the folder of image or
text files that you want to import, or type the folder paths directly into the list.
Specify one path per line. FileMaker Pro will use the first path it locates as the
folder to import. For more information, see FileMaker Pro Help
Digital Camera
(Mac OS)
In the FileMaker Pro Photo Import Options dialog box, choose your camera or
other image device, and choose how you want to download and import the
photos. For more information, see FileMaker Pro Help.
XML Data In the Specify XML and XSL Options dialog box, choose the source of the XML
data that you want to import, and choose an XSLT style sheet if you want to apply
one prior to import. The XML and XSLT source may be a file or the result of an
HTTP request, or a calculation that generates a file path or an HTTP request. For
more information, see FileMaker Pro Help.
ODBC Data Specify the data source name and location, the user ID and password (if any),
and the SQL query to be executed. You can enter a query directly or specify a
calculation to generate the query. For more information, see FileMaker Pro Help.