User manual
Table Of Contents
- Bento® 4
- Welcome to Bento
- Overview of Bento
- Using Libraries
- Using the Address Book Library
- Migrating the iCal, iPhoto, and Address Book Libraries
- Using Collections
- Using Form View
- About Forms
- Creating Records in Form View
- Editing Records in Form View
- Duplicating Records in Form View
- Deleting Records in Form View
- Creating Forms
- Deleting Forms
- Showing and Hiding Forms
- Duplicating Forms
- Copying Forms
- Renaming Forms
- Locking and Unlocking 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
- About Table View
- Selecting Records in Table View
- Creating Records in Table View
- Editing Records in Table View
- Duplicating Records in Table View
- Deleting Records in Table View
- Sorting Records
- Working with Fields and Columns in Table View
- Creating Fields in Table View
- Adding Fields in Table View
- Working with Media Fields in Table View
- Changing Options for a Field in Table View
- Completing Text Automatically as You Type
- Duplicating Fields
- Changing the Field Type
- Showing and Hiding Columns
- Deleting Fields in Table View
- Reordering Columns
- Resizing Columns
- Filling Fields Automatically
- Summarizing Column Data
- Using Grid View
- Using Fields
- Importing, Exporting, and Printing
- Backing Up and Restoring Information
- Syncing
- Keyboard Shortcuts
- Reverting to a Previous Version of Bento
- Index
Chapter 10 Importing, Exporting, and Printing 105
Correcting .csv Files
If you are having difficulty importing a .csv file, open it in a text editor (such as
TextEdit) and do the following:
• Put double quotation marks around field values that have embedded
commas.
For example: “10,000 Donors“
• Put double quotation marks around field values with leading or trailing
spaces.
• Put double quotation marks around field values that contain embedded line-
breaks.
• Put double quotation marks around field values that contain double
quotation marks. Change the embedded double quotation marks into a pair
of consecutive double quotation marks.
For example: “She said ““I will be there”” in her email.“
Example of a comma separated (.csv) file