When you import data check the privacy or communications options

[Jon-man]

We have been importing contact data into CiviCRM 4.3.5 the values for do_not_email, do_not_phone, do_not_mail, do_not_sms and do_not_trade are null unless specified.

For us, this meant we were confused as to why our mailing lists were so small - contacts were being omitted as the values weren't being set. Just remember to set the communications preferences, otherwise your contacts won't be included to mailings/sms.

# SQL query to fix this.
update civicrm_contact set do_not_email=0 where do_not_email is null;

Hope this helps someone.

[JonGold]

This is related to this bug, which was fixed in 4.4: https://issues.civicrm.org/jira/browse/CRM-12748.

However, it sounds like this fix may not fix your use case.  If you can replicate this same bug on the demo server (which runs the current version), it's worth opening a second bug report.

[Wes Reimer]

I did not have this issue with 4.4.5. All those fields were set to zero during import.