User manual

12-4 FileMaker Pro User’s Guide
1 If you’re updating records, make sure the found set contains only
the records you want to update. Records outside the found set will
not be updated, even if match field data matches.
5. In Browse mode, choose File menu > Import Records.
6. In the Open File dialog box, to see all the files in the current folder
that you can import: for Files of type (Windows) or Show (Mac OS),
choose All Files. To narrow the choices, choose a file type from the
list.
7. Select the name of the file to import, then click Open.
8. If you're importing a Microsoft Excel file that contains more than
one worksheet, you see the Select Worksheet dialog box. Select the
worksheet that you want to import and click OK.
9. If you're importing a Microsoft Excel file, you see the First Row
Option dialog box. Choose whether the first row of data in the file is
field names or data.
10. In the Import Field Mapping dialog box, perform the next three
steps before you click Import.
You can also perform either of these actions at any time before you
click Import:
11. In the Import Field Mapping dialog box, choose the type of
import you want to perform.
12. In the Import Field Mapping dialog box, line up each field in the
Fields in list with the data or field you want to import into it or match
for import update.
Data or fields in
the source file
Fields in the
destination file
Null symbols show data
that won’t be imported
Re-order
all fields
Double-headed arrows indicate
match fields for import update
Arrows show that data will
import into the field at right
Choose an
import action
To Do this
View the data in the file
you’re importing from
(Optional)
Click the Scan Data arrows to see the data in each
record.
Create, change, or
delete a field in the file
you’re importing into
(Optional)
Click Define Fields. In the Define Fields dialog box,
make your changes, then click Done. (For more
information about defining, changing, and deleting
fields, see chapter 5, “Creating a database.”) If you’re
importing into a shared file, only the host can create
fields. If the button is dimmed, your access privileges
don’t allow you to define fields.
Choose To
Add new records. Add new records to the end of the
file you’re importing into
Replace data in current found set. Replace data in this file with data
from the source file, in order,
starting with the first record in
each file
Update matching records in current found set.
To add records in the found set of the source
file that do not have matching records in the
destination database, also select Add
remaining records.
Update data in the found set of
this file with data in matching
records in the file you are
importing from