Reload Default Email Templates Tool

[vlilloh]

Please,

I'm trying to create a small script in tools folder to install the default email templates in the empty tables 'email_templates_default' and 'email_templates_default_data' for all installed languages.

I'm trying with the next code:

Code: Select all

<?php
require(dirname(__FILE__) . '/bootstrap.inc.php');
$emailTemplateDao =& DAORegistry::getDAO('EmailTemplateDAO');
$emailTemplateDao->installEmailTemplates($emailTemplateDao->getMainEmailTemplatesFilename());
foreach ($this->installedLocales as $locale) {
     $emailTemplateDao->installEmailTemplateData($emailTemplateDao->getMainEmailTemplateDataFilename($locale));
}
?>

or

Code: Select all

<?php
require(dirname(__FILE__) . '/bootstrap.inc.php');
$emailTemplateDao =& DAORegistry::getDAO('EmailTemplateDAO');
foreach ($emailTemplateDao->installEmailTemplates($emailTemplateDao->getMainEmailTemplatesFilename(), true) as $sql) {
     $this->executeSQL($sql);
}
foreach ($this->installedLocales as $locale) {
     foreach ($emailTemplateDao->installEmailTemplateData($emailTemplateDao->getMainEmailTemplateDataFilename($locale), true) as $sql) {
          $this->executeSQL($sql);
     }
}
?>

but when I run the script (i.e. "php tools/reloadEmailTemplates.php") nothing happens. Still empty tables.

How would you fix it? Have you thought to include something like this in OJS? It would be very useful!

On the other hand, how to make the script clear tables before without having to do it manually?

Thanks,
Cheers.

[jmacgreg]

Hi Vicente,

I'm going to ask another developer to get back to you regarding why the script may not be working -- but in the meantime, have you tried the "Reset all templates" link at the bottom of the Prepared Emails journal management page? It should reset all prepared emails for that locale; I'm not sure if it does so for all locales on the system or not, so you may have to press it for each locale.

Cheers,
James

[vlilloh]

Hi James,

"Reset all templates" button, reset from "locale/xx_XX/emailTemplates.xml" to the table "email_templates_default_data"? if so, it is not working for me.

That is my wish in the script, or add a feature en OJS for that. Actually, "locale/xx_XX/emailTemplates.xml" is forgotten after an installation, and there is no way to modify the default templates in OJS after an installation.

I thought that "Reset all templates" button in a journal delete all entries in the "email_templates_data" table for that journal, and so again back to capture from "email_templates_default_data" table.

Thanks,
Cheers.

[mcrider]

Hi Vicente,

I think you'll have to declare your code in the scope of a custom class, and have that class inherit from the 'CommandLineTool' class. This will set up everything needed for your script to interface with OJS. As an example, the rest of the scripts in the tools/ directory do this.

Cheers,
Matt