Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 523
4. If the first record of the data you’re importing contains field names (column headings)
instead of data, select Don’t import first record (contains field names).
Selecting Don’t import first record (contains field names) skips the first record during import.
5. For Target Fields, drag fields to align with fields or data in Source Fields, to indicate where
source data will be imported or updated.
To align a field, move the pointer over the icon next to a target field name in the list. When the
pointer changes to a double arrow , drag the field to a new location.
You can do any of the following to align target fields and source fields:
• To preview the data that you’re importing, click the arrows below the fields lists.
• To create or change fields in the table you're importing into, click Manage Database. In
the Manage Database dialog box, make your changes, then click OK. (If the Manage
Database button is dimmed, either you don't have sufficient
access privileges, or the
database is shared over a network and does not currently permit database changes.
For more information about changing shared databases, see
Sharing and hosting files.)
• To reorder the target fields all at once, choose one of the following options from the
Arrange by menu:
Note Data from a source field will not import when:
• The source field is not aligned with a target field. Drag a target field to align with each
source field you want to import. Create a new target field if necessary.
• The symbol appears between the source and target fields, which indicates that the
target field type does not support the source field data. You cannot import data into
calculation or summary fields, or import some mismatched data types such as container
data into a text field. (The
symbol may also indicate that access privileges do not
permit importing data into a particular target field.)
Update data in the target file with
the data from matching records in
the source
Update matching records in found set
To also add records from the source that do not have matching
records in the target file, select Add remaining data as new
records.
To Select
Choose this option To list the fields by
Matching names Field names that match in both the target table and the source.
FileMaker
Pro matches field names dynamically each time you choose
this option. (This option is not available when the source data does not
contain field names.)
Last order The order used the last time FileMaker Pro imported data into this table
or the default order (creation order).
Creation order The order in which the fields were created.
Field names Alphabetical order.
Field types Field type.
Custom import order A custom order (which you create by dragging field names).