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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't batch update to overwrite email to null
Pages: [1]

Author Topic: Can't batch update to overwrite email to null  (Read 564 times)

Heather O.

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.x.x
  • CMS version: Drupal 6 & 7
  • MySQL version: 5
  • PHP version: 5
Can't batch update to overwrite email to null
July 05, 2012, 01:41:52 pm
Hi,

Trying to remove the email address from over 400 records. When I use the Batch Update Via Profile it all appears to work but when I return to the records, the email is still there.

Is there any other way I can batch overwrite so that the email field is null?

Many thanks,

Heather

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 batch update to overwrite email to null
July 05, 2012, 02:11:11 pm
possibly not through the UI - would it work to convert them all to xyz@xyz.com and then run a query in the DB to remove them if you have access to DB.

Other options via UI (if deleting is not the ONLY acceptably solution) is to set them all to 'do not email' and/or 'no bulk mail' assuming both are possible via the Batch update process or from the 'actions' button (haven't been to check.
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

Heather O.

  • I’m new here
  • *
  • Posts: 21
  • Karma: 0
  • CiviCRM version: 4.x.x
  • CMS version: Drupal 6 & 7
  • MySQL version: 5
  • PHP version: 5
Re: Can't batch update to overwrite email to null
July 06, 2012, 01:03:23 am
Many thanks for that. It's really helpful!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't batch update to overwrite email to null

This forum was archived on 2017-11-26.