Field Types Supported for Import

You can import data into the field types listed in the following table.

For this field type	This data can be imported
text choice address phone number IM account encrypted (when unlocked)	Any text
email address	Any text, but a valid email address must include the @ character.
URL	Any text, but the URL field does not support URL values that contain Japanese characters.
checkbox	“1” for checked; “0” for not checked “True” for checked; “False” for not checked “Yes” for checked; “No” for not checked
number currency	Numeric data
rating	A number between 0 and 10
time	Numeric data in the form HH, HH:MM, or HH:MM:SS, optionally with “AM” or “PM” where:  • HH represents the hour (between 0 and 24, if you don’t use “AM” or “PM”, or between 0 and 12 if you use “AM” or “PM”)  • MM is minutes (between 0 and 59)  • SS is seconds (between 0 and 59). For example: 12:59:59 PM
date	Numeric data in the form DD, MM/DD, or MM/DD/YYYY, where:  • DD is the day (between 1 and 31, as valid for the month)  • MM is the month (between 1 and 12)  • YYYY is the year (between 1 and 9999). A date field can also contain a “time” value, as described for the time field. Note: These formats vary depending on the current system date settings.
duration	Text representing a duration in weeks, days, hours, minutes, and seconds. The text may use the following abbreviations:  • w for weeks  • d for days  • h for hours  • m for minutes  • s for seconds For example, the following are all valid duration text:  • 8 days, 5 hours  • 8d,5h  • 8d5h
location	Location information (latitude and longitude) either in decimal degrees or in degrees, minutes, hours.

You cannot import into these field types: file list, media, automatic counter, calculation, related data, message list, or encrypted (when locked).

When you import into an address, phone number, email, URL, or IM account field, the data is automatically added to the associated address list, phone number list, email address list, URL list or IM account list field.

See Chapter 8, “Using Fields” on page 83 for additional information on field types.

Note  The message “Some values in some records can’t be imported” in the Import dialog means that one or more record values are not valid for the type of field to which you are importing the values. For example, you cannot import alphabetic text into a number field or into a date field. You can either change the field type to match the data, or proceed with import. If you proceed with import, the invalid values will not be imported. Other options are to change the contents of the file or to import the data into a Text field. Text fields accept all values.

Home > Importing, Exporting, and Printing > Importing Information into Bento > Field Types Supported for Import