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