A: It depends on the field you import into.
Yes/No custom fields
For custom fields of the type Yes/No (checkboxes) on companies, contacts and products:
- Use 1 to tick the box.
- Use 0 to untick it. TRUE, FALSE, Yes and No also untick the box.
- Leave the cell empty to keep the value the record already has.
If active and If subscription (products)
The product columns If active and If subscription take yes and no:
- No, n, false, f, nej and falskt turn the setting off. For If active, inactive and inaktiv also work. Upper or lower case does not matter.
- Any other value turns the setting on. This includes 0, so do not use 0 for off in these columns.
- An empty cell leaves the setting unchanged.
For the full import steps, see How to import data.