User manual
Table Of Contents
- Bento® 3
- Welcome to Bento
- Overview of Bento
- Using Libraries
- Using the Address Book, iCal, and iPhoto Libraries
- Using Collections
- Using Form View
- About Forms
- Viewing a Form and a Table at the Same Time
- Creating Records in Form View
- Editing Records in Form View
- Duplicating Records in Form View
- Deleting Records in Form View
- Creating Forms
- Deleting Forms
- Duplicating Forms
- Renaming Forms
- Adding Fields to a Form
- Tabbing Between Fields
- Moving Fields and Objects on Forms
- Resizing Fields and Objects
- Removing Fields from a Form
- Customizing Form Layouts
- Using Table View
- Using Grid View
- Using Fields
- Importing, Exporting, and Printing
- Backing Up and Restoring Information
- Using Bento with Bento for iPhone and iPod touch
- Keyboard Shortcuts
- Reverting to a Previous Version of Bento
- Index
Chapter 9 Importing, Exporting, and Printing 105
To create a library by importing:
1 Choose File > Import > File.
2 Click Choose, then select the file you want to import in one of the following
file formats: .csv, .tab, .tsv, .numbers, .xls, .xlsx.
• For .csv, .tab, or .tsv files, in the section “Choose the format,” choose
Comma separated, Semicolon separated, or Tab separated.
• For Numbers files, use the pop-up menus to select a sheet, then a table.
• For Excel files, use the pop-up menu to select a worksheet.
3 For “Choose a target,” choose New Library, and enter a unique name for the
library.
4 Indicate whether the file contains a row with values that you want to use as
field names.
• If the file contains a row with column names, click the arrow buttons to
go to that row and select “Use this record’s values as column names.”
Bento uses the values in this row as the new field names.
• If the file does not contain a row with column names, clear “Use this
record’s values as column names.”
Bento assigns default names to each new field. To change a default field
name, double-click the field name and type a unique name.
5 Bento sets the field types to “Text” by default. To change a field’s type, click
the pop-up menu and select a new field type.
• If there is a column that you do not want to import, click the pop-up
menu and select “Do not create.“
• For information on the field types supported for import, see ”Field Types
Supported for Import” on page 109.
6 Click Import.
When the import is done, Bento displays the records, which you can view in table
view, form view, split view, or grid view.
Importing into an Existing Library
If you want the information that you are importing to go into an existing library,
import the file into that library. Bento creates new records in the library.
You can also import a file into a collection. When you choose a collection as the target
for the import, Bento creates new records in the library that contains that collection,
and adds the new records to the collection.