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