Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 522
generates. See the Xerces C++ FAQ on the Apache website at http://xerces.apache.org/xerces-
c/.
• If you are using a calculation that generates the file path for the XML file, you must use the
format used by the operating system for the full path. For example, the following are valid
paths:
Windows: driveletter:/directoryName/fileName
OS X: /Volumes/VolumeName/directoryName/fileName
If you are providing a cross-platform solution, you can use the Get(SystemPlatform) function to
identify the current platform and use the correct format for each platform.
Setting the import action and mapping fields during import
When you import data into an existing FileMaker Pro file, the Import Field Mapping dialog box
appears after you select the file or source of the data to import. Use this dialog box to specify the
following import options:
• Import action: Specify how to import the data into the existing file. You can add new records
to the file, update existing records in the file, or update matching records in the file. See
Methods of importing data into an existing file.
• Field mapping: Specify where to import the data by mapping the fields in your database to
the fields in the source data that you’re importing.
To set the import action and map fields during import:
1. If you have not done so, choose the file or source of the data to import into an existing
FileMaker
Pro file.
Follow the instructions in Importing data into an existing file, Importing a folder of files all at
once, Importing Bento data (OS X), or Importing XML data. You will see the Import Field
Mapping dialog box.
2. If you’re importing data from another FileMaker Pro file and that file contains multiple tables,
choose the table you want to import from the Source list.
3. In the Import Action area, choose the type of import to perform.
Important Updating existing or matching records overwrites data in the target file and
cannot be undone. Choose File menu
> Save a Copy As to make a backup copy of the
target file. Make sure you understand how updating records works. See
Methods of
importing data into an existing file.
To Select
Add new records to the end of the
target file
Add new records
Note If the table you’re importing into contains no data, you can
only select Add new records; the other options described
below are not available because there is no data to update.
Update the found set of records in
the target file with the records
you're importing from the source,
in order, starting with the first
record in each file
Update existing records in found set
To also add any additional records in the source as new records
in the target file, select Add remaining data as new records.