by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Cancel at any time!
Free Trial

#4253 - How to mass delete activities

Closed Feature created by mailchimp a year 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

    a year 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

    a year 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

    a year 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

    a year 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
  • "Support was fantastic. Great bit of programming and we will be using it for the foreseeable future."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.