Bulk delete from csv

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
  • 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
  • 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