CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Mailing group is ignoring some people
Pages: [1]

Author Topic: Mailing group is ignoring some people  (Read 1185 times)

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Mailing group is ignoring some people
November 08, 2011, 01:53:05 am
I have a group of students - 79 in Advanced search, and also showing as 79 in a smart group I have created for them.  When I choose to mass email this group Civimail only shows 13 recipients.  This is also happening with a couple of other groups.

If I subsequently go into individuals' edit screens and press save they seem to then become mailing recipients.  Why might this be?  Why aren't they showing automatically as recipients in the mass email when they appear as contacts in the smart group?

We've recently upgraded to 4.0.7  Could this be part of the problem.  Speedy suggestions appreciated as I have several mass emails waiting to go out!

Lindsey

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing group is ignoring some people
November 08, 2011, 04:17:04 am
Can you check if contact's that are not displayed have their email address "On hold" or have checked "Do not email"

Kurund
Found this reply helpful? Support CiviCRM

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Mailing group is ignoring some people
November 09, 2011, 05:16:33 am
Hi Kurund - they don't - they're 'good' as far as I can see.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing group is ignoring some people
November 11, 2011, 03:01:05 am
Can you please try to replicate this on http://drupal.demo.civicrm.org

Kurund
Found this reply helpful? Support CiviCRM

jcasharpe

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 5
    • Woodlands Church
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: MariaDB 10.0.13
  • PHP version: 5.5
Re: Mailing group is ignoring some people
November 12, 2011, 09:20:51 am
Another symptom of this seems to be that civi group role sync is failing to sync our users into drupal, again only if their contact has never been edited.
I'm beginning to suspect its something to do with how we imported the data as we didn't use the import function but rather constructed the database tables directly and it appears that there's something in the tables that is wrong for contacts that haven't been touched. Is there a way in code to effectively loop over each contact, load and save them back to the database?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing group is ignoring some people
November 12, 2011, 02:54:45 pm

Might be easier to check two contacts that are fairly close in structure and see what the difference is in the DB records between one that has been edited and saved and the other that has not.

the only thing which i think that might affect it are: is_deceased OR is_deleted. But both of them would need to be fixed when saving the contact, which blows this theory away :(

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Mailing group is ignoring some people
November 15, 2011, 09:28:06 am
Hi Kurund
I was going to try re-creating it... but the demo site seems to be in Spanish at the moment and the only default language it shows is that.  Can I change it? Do I need to 'add' English to make that appear as a default option?  Also, as my colleague mentioned, it looks like it may be something to do with the imported data which hasn't subsequently been edited not being recognised for some reason so I won't be able to re-create that dynamic.  I may do some further testing though, when I can read the demo site in English again!
Thanks
Lindsey

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing group is ignoring some people
November 16, 2011, 12:42:12 am
Lindsey,

Currently demo is in English, in case language is changed you can revert to english from http://drupal.demo.civicrm.org/civicrm/admin/setting/localization?reset=1

Kurund
Found this reply helpful? Support CiviCRM

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Mailing group is ignoring some people
November 16, 2011, 04:17:06 am
That would be super useful to add that on the home page node (where you give the login/password), so people can find their way to switch even when the interface is in a language one can't read.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing group is ignoring some people
November 16, 2011, 05:21:02 am
Done.

Kurund
Found this reply helpful? Support CiviCRM

jcasharpe

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 5
    • Woodlands Church
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: MariaDB 10.0.13
  • PHP version: 5.5
Re: Mailing group is ignoring some people
November 16, 2011, 02:25:34 pm
Ok so the only change that gets made in the database is to a custom field group (incidently not the one that the smart group is based around) where we have a couple of varchar(255) fields that are set to NULL for contacts that are missing from the mailings. An edit and save on the contact changes this field to '' instead. (The default value for the field from a database point of view is NULL)

jcasharpe

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 5
    • Woodlands Church
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: MariaDB 10.0.13
  • PHP version: 5.5
Re: Mailing group is ignoring some people
November 16, 2011, 03:34:13 pm
Updating the database to change all the NULL fields to '' gets us closer but it appears that now people added to smart groups i.e. with status added and not smart don't show up.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Mailing group is ignoring some people

This forum was archived on 2017-11-26.