Author Topic: When you import data check the privacy or communications options (Read 379 times)

Jon-man · April 28, 2014, 01:25:09 am

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 · April 28, 2014, 08:44:16 am

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 · May 27, 2014, 08:34:24 am

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

CiviCRM Community Forums (archive)

News:

Author Topic: When you import data check the privacy or communications options (Read 379 times)

Jon-man

When you import data check the privacy or communications options

JonGold

Re: When you import data check the privacy or communications options

Wes Reimer

Re: When you import data check the privacy or communications options