Android Tutorial [B4X] - Google sheets and localizator

Hi everyone,

there is a new way to create the localizator class csv file and it is as easy now as it could never be in the past. Just watch the following video:

(23-6-2019)

In order to download it as excel sheet (xlsx) you will have to press in Google Sheet
Ctrl+A > Copy > Select A1 > Paste special only values
And then download because if you download it directly it downloads also the formulas and excel gets confused.

(16-4-2019)

In order to correct the text in Greek after you download the csv open it with notepad > Save as > (select [Unicode] as encoding)

Edit: I just saw that I forgot the key column
Edit 2: Also the first language in all translated cells must be "$A$2"
Edit 3: Please ignore the misspelling of the word "phrase".


Cheers

 

[AnandGupta]

Hi hatzisn,

Very good idea and thanks for it.
I use google translate for our local language, see screen shots,





and was going to ask "How can I find the 'language code' i.e. second row values for 'Hindi' say ?" BUT I found it googling
https://ctrlq.org/code/19899-google-translate-languages

Result,



It may help members.

Regards,

Anand

 

[hatzisn]

Hi,

You can also have a look at the following URL. It's the column 639-1 for the language codes.
https://en.m.wikipedia.org/wiki/List_of_ISO_639-1_codes

 

[hatzisn]

Please also note that for all Unicode written languages including Hindi it is valid what is written for Greek.

 

[hatzisn]

I added a useful comment in the first message for those who wish to download the xlsx type.