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) »
  • Can't mail to my imported mail db
Pages: [1]

Author Topic: Can't mail to my imported mail db  (Read 700 times)

apotropaic

  • I post occasionally
  • **
  • Posts: 34
  • Karma: 1
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 1.8
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Can't mail to my imported mail db
February 07, 2014, 10:11:17 am
I recently upgrade from 3.4 to 4.4 :) and the process was a little messy but essentially I found that exporting and importing was the best way to go.

I am now set up and everything is imported. I have an newsletter mailing group of about 95,000 people. When I go to create a mailing and select that group, on the very next screen on the top right corer of the mailing options it says, 'Total Recipients: 28'

So, 28 out of 95,000? What could have possibly happened here? I thought maybe it was just a display error and proceeded anyway. But, yea only 28 people go that mailing. Any suggestions?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Can't mail to my imported mail db
February 07, 2014, 12:39:42 pm
i may be sending you down the wrong path but in the db look at the civicrm_contact and civicrm_emails table and see if there is any pattern to the 28 compared to the 95000
eg i am wondering if in your import (how did you import) something got missed and has left a NULL where you need a 0 or 1

Pretty vague of me I know but it might help
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

apotropaic

  • I post occasionally
  • **
  • Posts: 34
  • Karma: 1
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 1.8
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Can't mail to my imported mail db
February 07, 2014, 04:00:14 pm
Good call! Yea let me look at the 28 and see if they have something different. Thanks, I'll report back.

apotropaic

  • I post occasionally
  • **
  • Posts: 34
  • Karma: 1
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 1.8
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Can't mail to my imported mail db
February 07, 2014, 05:40:17 pm
petednz, that worked like a charm! Compared a few different records and found that the ones that were sending had do_not_mail set to 0 and the rest had NULL... I guess thats no longer acceptable in 3.4+ code, so my import would have kept the null status. Thanks for the tip, seem to be working great now!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Can't mail to my imported mail db

This forum was archived on 2017-11-26.