User manual

Chapter 8 Importing, Exporting, and Printing 83
You cannot import into these field types: file list, media, automatic counter,
calculation, or related records list.
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 7, “Using Fields,” on page 63 for additional information on field types.
Note: The message “Some values in some records can’t be imported” means that one
or more record values are not valid for the type of field that has been selected for
import. For example, you cannot import alphabetic text into a number field or into a
date field. You can either change the contents of the CSV file, change the field type to
match the data, or proceed with import. If you proceed with import, some of the
values will not be imported.
date Numeric data in the form DD, MM/DD, or MM/DD/YYYY, where:
1 DD is the day (between 1 and 31, as valid for the month)
1 MM is the month (between 1 and 12)
1 YYYY is the year (between 1 and 9999).
A date field can also contain a “time” value, as described for the time
field.
duration Text representing a duration in weeks, days, hours, minutes, and
seconds. The text may use the following abbreviations:
1 w for weeks
1 d for days
1 h for hours
1 m for minutes
1 s for seconds
For example, the following are all valid duration text:
1 8 days, 5 hours
1 8d,5h
1 8d5h
For this field type This data can be imported