Import a checkbox field

[mtmendez]

Hi

I'm trying to import the information from a field to a "checkbox" field in Sugar crm 5.0. But I can't get the software to recognize the "true" value.

I have the original data stored in an excel file, that I exported to a csv file. I have tried with:

=true
1
yes
Y

How should I store my data on the excel so I can correctly import it?



Just in case it matters, every other kind of field is imported without trouble.

[swissblade]

Since data is stored in a MySQL database, I am guessing the true/false import has to match the field type of the MySQL table...

I had the same problem and substituted true with "1" and false with "0" and it worked like a charm!!!