User manual

Chapter 9 Importing, Exporting, and Printing 109
Field Types Supported for Import
You can import into these field types: text, choice, checkbox, number, rating,
encrypted (when unlocked), currency, time, date, duration, address, phone number,
email address, URL, and IM account.
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.