snake Posted August 2, 2014 Report Share Posted August 2, 2014 in what table are the email templates in the database ? I need to bulk update them, but cannot find where they are stored. Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 3, 2014 Report Share Posted August 3, 2014 the table name is emails . make a backup before any change . Quote Link to comment Share on other sites More sharing options...
0 Michael Posted August 2, 2014 Report Share Posted August 2, 2014 Why not just update them one by one? you can break stuff in the database if it's not done probably? Quote Link to comment Share on other sites More sharing options...
0 snake Posted August 3, 2014 Author Report Share Posted August 3, 2014 because there are loads of them to do one by one, would take me a few seconds in the db. it should be a straight forward query to replace value a with valueb, so I don;t think there is must chance of breaking anyhting Quote Link to comment Share on other sites More sharing options...
0 snake Posted August 3, 2014 Author Report Share Posted August 3, 2014 so does anyone know what table they are in ? they are clearly not in something obvious like "email_templates" Quote Link to comment Share on other sites More sharing options...
0 Michael Posted August 3, 2014 Report Share Posted August 3, 2014 so does anyone know what table they are in ? they are clearly not in something obvious like "email_templates" Â Not being cocky but I just looked just for you and when you say not in something obvious.. how obvious would "emails" be? Quote Link to comment Share on other sites More sharing options...
0 snake Posted August 3, 2014 Author Report Share Posted August 3, 2014 yes I just discovered this about 10 mins ago.. I had looked at this table several times, but I had assumed that "EMAILS" was copies of emails sent to users, which is what the name implies, and is generally the convention I have found in other billing systems I have used which save copies of all outgoing emails. Email_templates would be more obvious :-) Quote Link to comment Share on other sites More sharing options...
0 snake Posted August 4, 2014 Author Report Share Posted August 4, 2014 ok got all that sorted and have made my bulk updates.  However the support email templates do not seem to be in this table, are they stored somewhere else ? Specifically I want to edit the default email  that goes out when a user opens a ticket, and add a signature and change the from address so that users can actually tell where it is from, otherwise it just looks like spam. I have searched through the admin but couldn't find this anywhere. Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 4, 2014 Report Share Posted August 4, 2014 the template email for support is in the config folder . but after the install it go to the database , same table . Quote Link to comment Share on other sites More sharing options...
0 snake Posted August 5, 2014 Author Report Share Posted August 5, 2014 thanks for confirming, is there no place in the admin to edit this one then ? Quote Link to comment Share on other sites More sharing options...
0 Paul Posted August 5, 2014 Report Share Posted August 5, 2014 Support emails are under Settings > Company > Emails, under "Plugins" as it's a plugin. Look for templates in this section labeled "Support Manager". Blesta Addons and Michael 2 Quote Link to comment Share on other sites More sharing options...
0 snake Posted August 5, 2014 Author Report Share Posted August 5, 2014 thanks Paul, I had in fact already looked here and only had client emails and staff emails. so I tried disabling and re-enabling the support plugin, and now the support templates are showing. got there in the end :-) Quote Link to comment Share on other sites More sharing options...
Question
snake
in what table are the email templates in the database ? I need to bulk update them, but cannot find where they are stored.
Link to comment
Share on other sites
11 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.