Semi-auto translation to module

Open module translation page and run next jquery in browser console: var ar = []; $('#translations_form .table input, #translations_form .table textarea').each(function(i){ if ($(this).css('background-color') == 'rgb(255, 187, 187)') { 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('<div><textarea id="output_array" cols="22" rows="3"></textarea><br /><input type="button" id="read_button" value="Fill new translations" /><br /><br /></div>'); $('#read_button').unbind(); $('#read_button').click(function(){ var text = $('#output_array').val(); //console.log(text); //var ar = []; var newa = text.split(/r?n/); var ar = []; var newa = text.split(/\r?\n|\r|\n/g); for (var i = 0; i < newa.length; i++) { var ar = newa[i].split(' || '); //$('input[name="'+ar[0]+'"]').val(ar[1]); console.log(ar); if (newa[i] != '') { var name = ar[0].trim(); var val = ar[1].trim(); val = val[0].toUpperCase() + val.slice(1); if ($('#translations_form input[name="'+ar[0].trim()+'"]').length > 0) { $('#translations_form input[name="'+ar[0].trim()+'"]').val(val); } else { $('#translations_form textarea[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