by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM.

Free Trial

By clicking you consent to share your profile with the developer

#4253 - How to mass delete activities

Closed Feature created by mailchimp 2 years ago

Our sugar cloud provider has warned us about the size of our database.

We have over a million sugarchimp activities from our many years running the software. To use mass delete would take far too long as it will only select 5000 at a time.

Is there a quicker batch way to delete?

Thank you.

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Happy to help! You should be able to reach out to Sugar directly to request they delete activities older than a certain date.

    Let me know if you need anything further!

    Best, Heidi

  2. mailchimp member avatar

    mailchimp

    2 years ago

    Heidi,

    Thanks for the response, I made the request of sugar and they came back with this....

    Below is a list of database tables related to Sugarchimp. Please confirm which of these should be truncated. sugarchimp sugarchimpactivity sugarchimpactivity_accounts sugarchimpactivity_audit sugarchimpactivity_contacts sugarchimpactivity_leads sugarchimpactivity_prospects sugarchimpactivity_tasks_1_c sugarchimp_activity_tracker sugarchimp_backup_queue sugarchimp_batches sugarchimp_lock sugarchimp_mailchimp_backup sugarchimp_mc sugarchimp_mc_activity sugarchimp_mc_campaign sugarchimp_mc_cleaned_email sugarchimp_mc_list sugarchimp_mc_people sugarchimp_optout_tracker sugarchimp_sugar_backup

    I'm not sure how to respond. Can I say "delete the lot" or would that be a very bad move?

    Thanks.

  3. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Thanks for this response. If you're looking to remove and delete activities, they can truncate the following:

    sugarchimpactivity_accounts sugarchimpactivity_audit sugarchimpactivity_contacts sugarchimpactivity_leads sugarchimpactivity_prospects sugarchimpactivity_tasks_1_c

    It's worth noting that truncating will remove all activities. If you only want to remove activities beyond a certain date, you'll want to let Sugar know.

    Let me know if you have any other questions!

    Best, Heidi

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    2 years ago

    Apologies! I missed a table. Here are the tables again in full:

    sugarchimpactivity sugarchimpactivity_accounts sugarchimpactivity_audit sugarchimpactivity_contacts sugarchimpactivity_leads sugarchimpactivity_prospects sugarchimpactivity_tasks_1_c

    Let me know if you have any questions!

    Best, Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "The best platform for synchronizing our contact information. Great job." - danielolivas

    Read More Reviews