Details about this thread
  • State Not Answered
  • Replies 1 reply
  • Subscribers 309 subscribers
  • Views 459 views
  • Users 0 members are here
Related content from around SugarClub

Bulk delete from csv

Tom Repetti

Enterprise 9.3 on-demand.  I have been given a csv containing long list of bouncing emails and I need to delete the contacts associated with them.

Any options to make this easy?

Parents
  • 0

    I'm not sure deleting the Contacts is a good approach, once you will loose the historical relationship.

    Instead you may consider update the target emails setting the field invalid_email to true, by running the sql query:

    UPDATE email_addresses SET invalid_email = 1 WHERE email_ddress IN ({bounce_list});

    This will tell SugarCRM to don't send Email Campaigns to any target (Lead, Prospect, Contact, Account) if related email address is marked as invalid.

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
Reply
  • 0

    I'm not sure deleting the Contacts is a good approach, once you will loose the historical relationship.

    Instead you may consider update the target emails setting the field invalid_email to true, by running the sql query:

    UPDATE email_addresses SET invalid_email = 1 WHERE email_ddress IN ({bounce_list});

    This will tell SugarCRM to don't send Email Campaigns to any target (Lead, Prospect, Contact, Account) if related email address is marked as invalid.

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
Children
No Data