Boolean Values in CSV Files

You should use only “TRUE” or “FALSE” as values for radio button fields to ensure that import of these fields is successful.

• Currently, radio button fields do not accept any other Boolean values.

• The Individual field for entities is an exception that accepts all forms of True or False. For information, see Customers as Individuals or Companies.

• Check boxes accept the following forms for true values: TRUE, YES, T, Y.

• Check boxes accept the following forms for false values: FALSE, NO, F, N

When working with check boxes and radio buttons, note the following:

• True and false values are case insensitive.

• The Import Assistant does not honor localization. This means that true and false values are not accepted in languages other than English.

• The Import Assistant does not accept any other true or false value than the eight values listed.

Related Topics

• Tips for Successful CSV Imports
• Sublist Data Import
• Importing Subrecord Data
• Supported Subrecord Imports
• Effects of Auto-Generated Numbers during Imports
• General CSV File Conventions
• Tips for Using Numbers in CSV Files
• Avoiding Errors for Commas and Other Delimiter Symbols within CSV File Fields
• Delimiters for Hierarchical and Multi-Select Fields
• Name References
• State and Province Names for CSV Import
• Country Names for CSV Import

General Notices