- Open module translation page and run next jquery in browser console:
var ar = []; $('#translations_form .table input').each(function(i){ //console.log($(this).css('background')); if ($(this).css('background-color') == 'rgb(255, 187, 187)') { //console.log(i); var index = $(this).attr('name'); var text = $(this).parent().prev().prev().text(); ar.push(index+' '+','+' '+text); } }); for (var i = 0; i < ar.length; i++) { console.log(ar[i]); }
- Copy result from console and paste to clear excel table (en.xlsx), Find "VM1732:13 " and replace with "", save file.
- Upload en.xlsx to "Google Translate" or translate by yourself, and save translated file (fr.xlsx for example).
- Copy from fr.xlsx to a text editor and be sure that separator is " , " - space, not tab https://i.gyazo.com/752b447984e9e377e94af1f0a01e7f1f.png
- At module translation page run next jquery in browser console:
$('#translations_form > h2 ').after('
') $('#read_button').unbind(); $('#read_button').click(function(){ var text = $('#output_array').val(); //console.log(text); var ar = []; var newa = text.split(/r?n/); for (var i = 0; i < newa.length; i++) { var ar = newa[i].split(' , '); //$('input[name="'+ar[0]+'"]').val(ar[1]); if (newa[i] != '') { var name = ar[0].trim(); var val = ar[1].trim(); val = val[0].toUpperCase() + val.slice(1); $('#translations_form input[name="'+ar[0].trim()+'"]').val(val); console.log(name); } } });
- Copy from text editor to inserted textarea and click "Fill new translations" https://i.gyazo.com/d7a18c177aefa1612cd4c207c69cda5b.png
- Click Save