LinkBack URL
About LinkBacksHow do I delete the mail settings for all users at once?. What is the MySQL table that stores that data?.
Thanks
Senior Member
Delete emails
How do I delete the mail settings for all users at once?. What is the MySQL table that stores that data?.
Thanks
Sugar Community Member
Re: Delete emails
Truncate inbound_email
Regards,
Angel Magaņa
Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
Blog: http://cheleguanaco.blogspot.com.
Twitter: @cheleguanaco.
________
| Projects: |_____________________________________
|
| CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
| GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
| CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
| Round Robin Leads Assignment
| Phone Number Formatter
| CaseTwit (Twitter Integration)
______________________________________________
Senior Member
Sugar Community Member
Re: Delete emails
That's what the "truncate" command would do...
Regards,
Angel Magaņa
Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
Blog: http://cheleguanaco.blogspot.com.
Twitter: @cheleguanaco.
________
| Projects: |_____________________________________
|
| CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
| GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
| CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
| Round Robin Leads Assignment
| Phone Number Formatter
| CaseTwit (Twitter Integration)
______________________________________________
Senior Member
Re: Delete emails
Ok, you're all deleted.
The meetings and the cache (the last shows that you have reviewed) can also be removed?
Sugar Community Member
Re: Delete emails
truncate meetings;
truncate tracker;
I am assuming you have a backup of your database already in place....yes?
Regards,
Angel Magaņa
Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
Blog: http://cheleguanaco.blogspot.com.
Twitter: @cheleguanaco.
________
| Projects: |_____________________________________
|
| CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
| GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
| CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
| Round Robin Leads Assignment
| Phone Number Formatter
| CaseTwit (Twitter Integration)
______________________________________________
Senior Member
Re: Delete emails
Yes, I have backup.
If I delete the cache of a user only, would be the same table?.
There is some document of the relationship of the tables?
THANKS!
Sugar Community Member
Re: Delete emails
Yes, same tracker table, but you would need to use the DELETE command instead so you can specify the WHERE clause to narrow it down to a single user.
See here for diagram: http://www.sugarcrm.com/forums/showthread.php?t=21948
Regards,
Angel Magaņa
Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
Blog: http://cheleguanaco.blogspot.com.
Twitter: @cheleguanaco.
________
| Projects: |_____________________________________
|
| CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
| GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
| CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
| Round Robin Leads Assignment
| Phone Number Formatter
| CaseTwit (Twitter Integration)
______________________________________________
Senior Member
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks