Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 524
6. In the space between each pair of fields in the list, click the field mapping symbol one or
more times to indicate the field mapping you want performed.
Continue clicking until the symbol between the fields indicates the field mapping you want. For a
description of each symbol, refer to the Field Mapping area. You can choose whether or not to
import each field into the target field, or use a field pairing as a
match field for updating matching
records.
Tip You can also set the field mapping for multiple fields at the same time. First select the target
fields you want to change by holding down Ctrl (Windows) or Command (OS
X), and clicking
each target field. (You can also select a range of adjacent fields by clicking the first field and
then Shift-clicking the last field in the range.) Then click a field mapping symbol for one of the
selected fields until they all indicate the mapping that you want. (You can also press the Space
bar one or more times to change the field mapping symbol.)
7. If necessary, for Character Set, choose the character encoding used in the source file.
The Character Set list may be dimmed or available:
• If the list is dimmed, then FileMaker Pro was able to determine the encoding of the file
and picked it automatically.
• If the list is available, then FileMaker Pro was not able to determine the file encoding,
and has tried to pick an appropriate character encoding based on your operating
system and the file format you’re importing. You may need to change the encoding that
FileMaker
Pro picked. If you pick a different encoding, FileMaker Pro scans the import
data, and will display an alert message if the data contains characters that are illegal in
the character set you selected.
Note If you’re importing a 16-bit Unicode (UTF-16) text file, the file must contain a Unicode
standard Byte Order Mark (BOM). If the BOM is missing, FileMaker
Pro will not properly
recognize the file encoding.
8. Click Import.
You may see the Import Options dialog box, which appears when:
• the target file has fields for which automatic data entry (auto-enter) options have been
enabled
• you’re importing and adding new records from a FileMaker Pro file with repeating fields
9. If the Import Options dialog box appears, select one or more of the following options, and
then click Import.
To Do this
Auto-enter new data in fields
defined with auto-enter
options. (For example, to
enter the date in a
Modification Date field.)
Select Perform auto-enter options while importing. Otherwise,
auto-entered values will not be entered.
Note When you’re importing into fields that are set to auto-enter a
value (like modifier name, modification date or time, or
lookup data),
clear this option unless you want the auto-entered data to overwrite
the data you’re importing.