How to - Adding languages to database

In this HOWTO solution, we will explain to you how you can add desired languages to be available


When it comes to languages, the ones that are active by default in Atomia are English and Swedish. Atomia also supports:
  • Dutch
  • French
  • German
  • Spanish
  • Italian
  • Portuguese
  • Polish
  • Danish
  • Norwegian
  • Finnish
In order to use any of these, you need to add them into the database according to the following instructions:

  1. In case that languages are not listed in field “Available languages” you have to follow next steps:
    • First, it is necessary to insert the desired language in database AtomiaAccount , table languages using next query (this language is only an example)

    In MSSQL dialect:


    Begin tran

    Insert into AtomiaAccount.dbo.language (id, name, iso639name, culture)

    values(NEWID(), ‘British’ , ’EN’, ‘GB’)
    commit

       

      In PostgreSQL dialect, against AtomiaAccount database:


      Begin;
      Insert into language (id, name, iso639name, culture) values(uuid_generate_v4(), ‘British’ , ’EN’, ‘GB’) commit

       

        • It is necessary to add resource files *.resx into folder in this location
      C:\Program Files (x86)\Atomia\Store\App_GlobalResources .  It is important that you name files like in this case Common.en-GB.resx and CustomerValidation.en-GB.resx. The easiest way to make resx files is to make a copy of default ones and name it as it is said already. After that, using some text editor you have to make a translation for text between

      <value> Some text for translation </value>  to the desired language.

        1. After making resx files for desired language it is important to edit Common.resx files and add following blocks:
           <data name="EN_GB_name" xml:space="preserve">
           <value>English British</value>
           <comment>Language resource convention</comment>
          </data>
          <data name="EN_GB_shortname" xml:space="preserve">
           <value>GB</value>
           <comment>Language resource convention</comment>
          </data>