What is the difference of email templates in "Workflow" and in "Translation"?

Software Support
1

We translated e-mail templates by using translation tool. However, the e-mail templates in “Workflow” in setting menu did not update. The system uses these templates. Are the templates in “Workflow” in emailTemplates.xml in local dir?

Thank you.

— Hiroshi

2

Hi @kawasaki,

Some pieces of the translations – including email templates – are installed from the XML files into the database. As Site Administrator, you can use the “Reload defaults” tool in the site’s Languages area to reload the templates from XML.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi asmecher,

I tried “reload”. “reload” reads templates from somewhere, and refreshes the templates. The results is different from the contents of /locale/ja_JP/emailTemplates.xml.
Where is the original file for the email templates at emails tab of Workflow setting page?

Thank you.

— Hiroshi

4

Hi Alec,

I had upgraded OJS from 2.8 to 3.1.0.0.
OJS 3.1 looks still read older OJS 2.8 template file.
How to change the link?

Thank you.

— Hiroshi

5

Hi @kawasaki,

I’m not sure I’m following – what link do you mean?

Regards,
Alec Smecher
Public Knowledge Project Team

6

Hi Alec,

Thank you for your reply.

The problem we have is that the result of reload or reset of email template at emails tab of Workflow page is unexpected.
Where is the default file for the email template? I want to replace it.
Editing the {OJS}/locale/emailTemplate.xml did not work.
Is the default file of email template stored in the database, which is difficult to replace?

Thank you again for your attention.

— Hiroshi

7

Hi @kawasaki,

When OJS is installed, the contents from the .xml files are stored in the database (see the email_templates_default_data table).

Regards,
Alec Smecher
Public Knowledge Project Team

8

Hi Alec,

Thank you.
Two questions.

  1. Is there easy way to edit the database by loading emailTemaplates.xml again

2)Is the email_templates_default_data table created when OJS is installed, not new journal is added?

Thank you again.

— Hiroshi

9

Hi Alec,

One more question.

If the email_templates_default_data table is deleted by sql command, can OJS create it again automatically by reading email Templaes.xml at locale dir?

Thank you for your help.

— Hiroshi

10

Hi @kawasaki,

As Site Administrator, try Removing the language and then Installing it again. I recommend making a backup of your database before doing this.

Regards,
Alec Smecher
Public Knowledge Project Team

11

HI Alec,

Thank you for your suggestion.
I saw language tab in Website Setting page.
I think I can change primary language and also remove the language (Japanese) by clicking check box for UI, Submissions and form.

Question

  1. Will Japanese disappear from language tab? If so, do I need to re-configure the site by editing configure.inc.php?

— Hiroshi

12

Hi @kawasaki,

After you remove Japanese from the list using the “Remove” tool, you can re-install it from the same area.

Regards,
Alec Smecher
Public Knowledge Project Team

13

Hi Alec,

Thank you.

I will try it.

— Hiroshi

14

Hi @asmecher,

I’m an admin for an OJS 3.1.0.1 journal. I’m trying to disable some of the nearly 100 email templates such that they don’t show up in dropdown menus for the editors. I’ve seen references to email_templates_default_data here and elsewhere. But I can’t find this file on the server. I can find email_templates.xml, but that doesn’t help. I’d appreciate any help you might be able to provide.

Patrick

15

Hi @pmfarrell,

That’s a database table – you’d normally use a tool like phpMyAdmin (often offered in CPanel) to browse its contents.

Regards,
Alec Smecher
Public Knowledge Project Team

16

Hi @asmecher,

Thanks! Using FileBrowser in CPanel, I coudn’t find the database table. I found it with phpMyAdmin. I deleted one of the templates in emal_templates_default and that removed it from the workflow. I also deleted it from email_templates_default_data. Not sure if I needed to do that too. I guess editing email_templates_default and putting a “1” in the can_disable column would work too and might be safer.