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
 
Last edited:

AnandGupta

Expert
Licensed User
Longtime User
Hi hatzisn,

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

2019-04-16_175305.png

2019-04-16_175227.png

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,

2019-04-16_181100.png

It may help members.

Regards,

Anand
 

hatzisn

Well-Known Member
Licensed User
Longtime User

hatzisn

Well-Known Member
Licensed User
Longtime User
Please also note that for all Unicode written languages including Hindi it is valid what is written for Greek.
 

hatzisn

Well-Known Member
Licensed User
Longtime User
I added a useful comment in the first message for those who wish to download the xlsx type.
 
Top