I have an older EE2 site that will be rebuilt and not upgraded. There are almost 150 translations in the Transcribe module. Is there an easy way to export via db query or template code a list of variables and translations somehting like this:

  • variable_1 English French,
  • variable_2 English French,
  • variable_3 English French,
  • variable_4 English French,

This would save a lot of copy/pasting.

Digging into the database I see two tables that I need to combine to output the data correctly. I am completely unfamiliar with mysql so have no idea where to start.

exp_transcribe_variables and exp_transcribe_translations

Translations has a column variable_id which should match the variables column id see screenshots from navicat

enter image description here

enter image description here


You can export the data from the EE MySQL database if you have access to a MySQL utility such as Sequel Pro or Navicat.

You'll need to enter some SQL to isolate the data you want, something like this:

    t_variable.id AS entry_id,
    t_variable.name AS entry_name,
    t_translation.content AS entry_content
FROM exp_transcribe_variables t_variable
INNER JOIN exp_transcribe_translations t_translation ON (t_variable.id = t_translation.variable_id)
INNER JOIN exp_transcribe_variables_languages t_language ON (t_variable.id = t_language.variable_id)
WHERE t_language.language_id = '2'

This will generate a table with the translations in... hopefully... that you can then export as CSV or whatever works for you :D

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.