Google Apps Script Multi-language environment

[Tim Lai]

I have the below block of codes...

function findEvents(user, keyword, start, end, optSince) {

  var params = {

    q: keyword,

    timeMin: formatDateAsRFC3339(start),

    timeMax: formatDateAsRFC3339(end),

    showDeleted: true,

  };

  if (optSince) {

    // This prevents the script from examining events that have not been

    // modified since the specified date (that is, the last time the

    // script was run).

    params.updatedMin = formatDateAsRFC3339(optSince);

  }

  var pageToken = null;

  var events = [];

  do {

    params.pageToken = pageToken;

    var response;

    try {

      response = Calendar.Events.list(user.getEmail(), params);

    } catch (e) {

      console.error('Error retrieving events for %s, %s: %s; skipping',

          user, keyword, e.toString());

      continue;

    }

    events = events.concat(response.items.filter(function(item) {

      return shoudImportEvent(user, keyword, item);

    }));

    pageToken = response.nextPageToken;

  } while (pageToken);

  return events;

}

where keyword can be...

['out of office', 'offline', 'vacation', 'ooo', '不在'];

I am scripting in a multi-languages environment the english keywords work fine but not the Kenji/Japanese characters. Any idea? Thanks for your help!

[Tim Lai]

Hmmm...no taker on this? 

Let's try simplifying the question. The params object property q the search keyword can be Japanese and English words as our Calendar uses both the languages. For example, the out of office event can have 'Out of office' or '不在' in the event title. 

So what is the way to handle multi-languages Calendar environment? The event listing works only with English keywords but not the Japanese. Any idea? 

Thx and appreciate your help!

-Tim

var KEYWORDS = ['out of office', 'offline', 'vacation', 'ooo', '不在'];

var params = {

    q: keyword,

    timeMin: formatDateAsRFC3339(start),

    timeMax: formatDateAsRFC3339(end),

    showDeleted: true,

};

 var response = Calendar.Events.list(user.getEmail(), params);

[Tim Lai]

No luv here...anyone else programming app script in a multi-language environment?

[ChiefChippy2]

I code Google Apps Script in English, but the environment doesn't seem very friendly with emojis, which might relate to your problem.

Google might be your friend ( I found some results but I am not sure if you want that or not )

[Andrew Apell]

Since you want any answer (kidding...), try playing around with JSON

Please note that this is a little more than a hunch and less than a guesstimate

[Tim Lai]

Thx for the reply! I think I am on to it...

[Tim Lai]

Hi Andrew:

Right on!

I tried using js to do the encoding and it was no bueno.

So I just use PHP to convert the Japanese character...

<?php

  echo json_encode('不在');

?>

and I got:

var KEYWORDS = ['out of office', 'offline', 'vacation', 'ooo', '\u4e0d\u5728'];

Now, the Calendar.Events.list() is returning Out of Office in Japanese too. Awesome!

Thanks for your help!

Tim

[Andrew Apell]

You are welcome Tim! I'm glad it worked.

[Alex]

cross https://stackoverflow.com/questions/57918647