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 Import (Moderator: Yashodha Chaku) »
  • removing bad emails
Pages: [1]

Author Topic: removing bad emails  (Read 3503 times)

crayon

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
  • CiviCRM version: 3.3.6
  • CMS version: Drupal 6.2
  • MySQL version: 5.0.91
  • PHP version: 5.2.17
removing bad emails
September 05, 2008, 06:27:02 pm
I am trying to remove a large number of bad emails. I have the contacts whose emails are bad in one group. I have tried importing a file with the contacts' name with the email field left blank or with a space in it and I can't get it to replace the current email in the file.  Any suggestions?

dharmatech

  • I post frequently
  • ***
  • Posts: 280
  • Karma: 53
    • dharmatech.org
Re: removing bad emails
September 06, 2008, 10:25:59 am
Hey chartglass. You can easily do this using the "batch update via profile" feature. Basically, create a profile with at least an email address field. Search for all the members of that group and then in the "more actions" menu, select "batch update via profile." and select the profile you just created. Erase the email in the first row, then hit copy to erase all the others in the set.

this should work fine.

tony
http://dharmatech.org
oss@dharmatech.org
801.541.8671

crayon

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
  • CiviCRM version: 3.3.6
  • CMS version: Drupal 6.2
  • MySQL version: 5.0.91
  • PHP version: 5.2.17
Re: removing bad emails
September 06, 2008, 06:54:47 pm
THANKS!  It did work fine.  I had to repeat it 14 times to handle 1400 records but still very quick.

dharmatech

  • I post frequently
  • ***
  • Posts: 280
  • Karma: 53
    • dharmatech.org
Re: removing bad emails
September 08, 2008, 07:09:34 am
Cool. Glad it helped. I forgot to mention that doing a batch update, there is a limit of 100 contacts.

tony
http://dharmatech.org
oss@dharmatech.org
801.541.8671

crayon

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
  • CiviCRM version: 3.3.6
  • CMS version: Drupal 6.2
  • MySQL version: 5.0.91
  • PHP version: 5.2.17
Re: removing bad emails
November 04, 2008, 01:52:49 pm
I wanted to report a problem I had with the batch edit I did here.  I followed the instructions and removed the emails.  But when I look at the individual contacts or do a search, the email address shows up without the contact's name. I have to go into each record individually and click edit and save and then the email is gone and the name reappears.  Is this a bug?

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: removing bad emails
November 04, 2008, 02:47:50 pm

can you reproduce on the demo machine and if so file an issue along with instructions on how to reproduce

thanx

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

crayon

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
  • CiviCRM version: 3.3.6
  • CMS version: Drupal 6.2
  • MySQL version: 5.0.91
  • PHP version: 5.2.17
Re: removing bad emails
November 05, 2008, 07:55:09 am
I tried to use the demo machine but perhaps I don't know what I am doing?  I clicked on the TRY IT NOW button and then Civicrm 2.1 with Drupal.  I tried to import data (I've done this many times, CSV file) and it was merging my three fields into one and giving me errors.  Then I tried to add contacts individually and it crashed.  So I would like to duplicate my problem but I don't know where to begin with the demo machine.  :-)

ctarascio

  • I post frequently
  • ***
  • Posts: 334
  • Karma: 30
    • American Friends Service Committee
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: 5.5.20
  • PHP version: 5.3.13
Re: removing bad emails
November 05, 2008, 08:30:10 am
Hello,
  Here is the direct link to the demo site: http://drupal.demo.civicrm.org/. When you get the "home page", enter "demo" for both the username and password. Then, begin your testing.

Hope this helps,
Cynthia

crayon

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
  • CiviCRM version: 3.3.6
  • CMS version: Drupal 6.2
  • MySQL version: 5.0.91
  • PHP version: 5.2.17
Re: removing bad emails
November 05, 2008, 08:36:20 am
Yes, this is where I went to try to use the demo machine and had all the problems.

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: removing bad emails
November 05, 2008, 10:17:47 am
I have had a similar problem with cells being conjoined on an import, and simply had to select all data, copy, open new csv and paste and resave. Something to do with how NeoOffice handles csv that have been closed and then reopened. Just in case that is same issue for you.
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

crayon

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
  • CiviCRM version: 3.3.6
  • CMS version: Drupal 6.2
  • MySQL version: 5.0.91
  • PHP version: 5.2.17
Re: removing bad emails
November 06, 2008, 06:32:37 pm
Thanks, that worked.  I tried the demo machine and could not reproduce the problem.  So I guess I am stuck.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • removing bad emails

This forum was archived on 2017-11-26.