Hello:
I have created a SQL Query to export all the translations in a Moodle language pack to .tmx format. This format can be analysed with tools that detect some typical errors (unclosed tags, incorrect HTML and so on) and is very useful for translators.
The query runs fine in PHPmyadmin (see the attached file), but I would like to publish it in Configurable Reports Repository. Unfortunately, I have not been able to run it in CR block.
This is a sample unit in the output (in PHPmyamin):
<tu tuid="core|abouttobeinstalled">
<tuv xml:lang="en"><seg>about to be installed</seg></tuv>
<tuv xml:lang="eu"><seg>instalatzeko zorian</seg></tuv>
</tu>
I think that the problem is with the tags.
- I have tried to use entities, but the editor does not allow ;
- I have tried to use char function but I have got no success.
Is it possible to create a query that creates that kind of output?