Importing check box fields

**matthewseymour** · 2006-07-21, 08:30 AM

Hi,

Does anyone know what value/form a check box field should take in the Tab Deliminated File to get them to map and import to Sugar check box fields?

I've tried TRUE/FALSE and that does not work.

Any ideas would be appreciated.

Thanks.

Matthew

**malcolmh** · 2006-07-21, 10:36 AM

Try 0 for false, 1 for true.

**matthewseymour** · 2006-07-21, 10:42 AM

Thanks, that worked!

Thank you for your time. MS

**Markku** · 2006-07-21, 11:10 AM

Just to add to Malcolm's answer...

There are two types of fields which are displayed as checkboxes in Sugar.

Fields like invalid_email (in contacts table) has datatype of tinyint(1), and it will accept 0 for false and 1 for true.

In the same contacts table there's a field email_opt_out which has datatype of varchar(3). email_opt_out will accept off for false and on for true.