Android Tutorial [B4X] - Google sheets and localizator

Discussion in 'Tutorials & Examples' started by hatzisn, Apr 16, 2019.

  1. hatzisn

    hatzisn Active Member Licensed User

    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"



    Cheers
     
    Last edited: Jun 23, 2019
  2. AnandGupta

    AnandGupta Active Member Licensed 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
     
  3. hatzisn

    hatzisn Active Member Licensed User

    AnandGupta likes this.
  4. hatzisn

    hatzisn Active Member Licensed User

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

    hatzisn Active Member Licensed User

    I added a useful comment in the first message for those who wish to download the xlsx type.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice