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. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.
#4253 - How to mass delete activities
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.
-
"It works perfect!" - audoxcl
Read More Reviews
- Most Recent Love from Users
melissa- Westcoat
- Mark Westerhoff
- danielolivas
- kgm
- Evolution Marketing
5 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
5 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.
5 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
5 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