Please list all fields tied to methods of communication and their data types. It would also be cool (P2) if we could tell the last time a field was used/edited.
Hmm, so one question. Are we just looking for the fields in the custom set "Communication"? Also, I agree that so far there is no obvious place in our documentation to put this, but that means we need to create one.
- Unsubscribe - this unsubscribes the contact. We add an Unsubscribe activity and set civicrm_contact.is_opt_out to 1. We also search for other instances of that email address & set civicrm_email.is_bulk_mail to 0 for them. Setting this is_bulk_email doesn't really affect anything at the moment but we also do is for DS unsubscribes
I think Do not solicit is manually set by MG staff
Thanks for all this. I think this is pretty good. However I swear we used to have a field "Do not mail" but I only see a "Do not solicit" at this point. did we change the name of this field? Of course I may be remembering this incorrectly.
So do not solicit is a custom field. CiviCRM has the following core fields
I'm not sure if we use these other than is_opt_out.
Note CiviCRM 'respects' some of these fields in some cases - e.g if you export from Civi & choose 'postal addresses' as an option it will exclude do_not_mail contacts. If you send a CiviMail it will ignore is_opt_out and do_not_email. If you send a ' normal' mail from the civicrm UI it respects 'do_not_email'
When we export to silverpop we set is_opted_out if ANY of these are true
civicrm_contact.is_opt_out shows up as no bulk emails user opt out. We fill in this field when users unsubscribe via Silverpop or DS & it affects our uploads to Silverpop (and we can't CiviMail them should we wish to)