Import Strings

Steps and excel template to import string

Path: Community Settings >> Customization >> Language and Strings >> Import Strings.

Import Strings allows us to import translations and customized strings with the help of an excel sheet in a single import. All you got to do is Export strings which needs to be
updated.

Steps to Import Strings:
1. Export Strings - Learn how to Export strings.

Once you have exported the sheet it will look like the screenshot below:

  1. In the column 'Strings', string will be shown, e.g. application.ideascale.ml.6.digit.code.

  2. In the column 'English Text', the original text will be shown, e.g. 6 digit code.

  3. In the column 'English Unverified', only the customized text will be shown, e.g. 6 digit code customized.

  4. In the column 'Customized/Verified', no data will be shown. It is intentionally kept empty so that the user can insert/add a new value to import/upload preferred customized text.

Export strings feature is provided with an ability to download a template for importing strings.


2. Update or customize the strings in the excel you have generated -
Once you have exported the strings from Search/ Manage Strings section you can update the last column Customized/ Verified.


You would require to update only the last column with the changes you would like to see. The above sheet exported was for the language English and so has third column as English Unverified. If it was another language for example Spanish the sheet would reflect like the screenshot below.


You can customise either all the strings or any strings of your choice. There is no restriction on how many strings needs to be customised.

3. Import the Strings.


When the sheet is ready select the Language in which the import has to be done and upload the file and click on Save. You will receive a message on top of the screen "Languages and Strings were imported successfully "

4. Receive email notification after the import.

On completion of the import the administrator will receive an email notification regarding the success of the import.

 

  • Since we recently stopped supporting HTML , strings containing HTML will NOT be imported .
  • The import the email notification will mention the excel sheet row number of the strings which were not uploaded, as seen in the screenshot below.
  • Please refer to the excel sheet and copy the string which was not uploaded .
    For eg. got to Row no. 110 of the excel sheet and copy the string , Search for the string from Language and Strings Section.
  • Update it and Save.

In case there is an error you should receive an email notification  with the errors specified in it.


The customized strings will now show the Customized checkbox checked and with the new updation in the box. In the below image the strings were updated in Spanish language.

 

Last Updated: August 4, 2023