Transcribe for EE2 - export all variables?

Question

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

Answer 1

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:

SELECT
    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