Welcome Guest, Not a member yet? Register   Sign In
language file creation with Google Spreadsheet

Hi, I find it quite handy to create language files from a google spreadsheet
  • You can copy&paste the field list from the model and quickly replace quotation marks and commas
  • You can use google translate (=GOOGLETRANSLATE(A1;'EN';'DE'))
  • You can sort everything later, so it is easier to have a look into it later and avoid dublicates
Therefore I create a spreadsheet with 3 columns:

A: variable/expression
B: translated text / string
C: comment (explanation for later translations to other languages; if needed)

After that I use this Google Script:
function createLanguageFile() {
  var ss    = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('data');
  var aLast = sheet.getDataRange().getNumRows();
  var data  = sheet.getRange("A1:C"+ aLast).getValues();
  var content;
  content = "<?php \n return [ ";
  data.forEach (function (row) {
    content = content + "'"+row[0]+"' => '"+row[1]+"',";
    if(row[2] != ""){content = content +"  //"+row[2]}
    content = content +" \n"
  content = content + "''=>'' \n";
  content = content + "];"
  var fileName;
  fileName  = "language" + new Date() + '.php';
  var newFile; 
  newFile = DriveApp.createFile(fileName,content)

If you want it a bit more comfortable you can add the script to the spreadsheets navigation bar with a second script:
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
      .addItem('Create', 'createLanguageFile')

The script creates a new file which you should find in your Google Drive base folder.
Let me know if you like it too ;-)

Theme © iAndrew 2016 - Forum software by © MyBB