Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 518
The Import Field Mapping dialog box appears.
8. Choose the Target table and Import Action, then choose the fields in your database that
map to the data being imported.
See Setting the import action and mapping fields during import.
Note A Bento location field displays as two separate fields in the Source Fields list:
[Fieldname](Longitude) and [Fieldname](Latitude).
9. Click Import.
The Import Summary dialog box shows the progress of your import.
10. Click OK.
To import Bento data into a new FileMaker Pro file:
1. In the FileMaker Quick Start Screen, select Convert an Existing File, then choose Bento
Data Source.
If you don’t see the FileMaker Quick Start Screen, choose Help menu > Quick Start Screen,
and repeat step 1.
2. Enter the Database Password in the Bento Password dialog box, if one was set in Bento.
Click OK.
3. In the Select Bento Source dialog box, select the library and collection that you want to
import, then click Continue.
The Create a New File Named dialog box appears.
4. Type a name for the new file, choose a location, then click Save.
The Import Summary dialog box shows the progress of your import.
Bento and FileMaker Pro field type mapping
The following table lists how Bento field types map to FileMaker Pro field types.
Note Data might appear differently after you import because of the differences in field mapping
between Bento and FileMaker
Pro and issues related to numerical precision.
Bento Field Type FileMaker Pro Field Type Notes
Date Timestamp Dates also display a time.
Data is reformatted into
FileMaker
Pro format.
Time Time Data is reformatted into
FileMaker
Pro format
Checkbox Number See “Displaying Bento
checkbox fields in
FileMaker
Pro,” below
Currency Number
Automatic Counter Number
Number Number
Duration Number
Rating Number
Tex t Text