Enhanced Export to Excel Translation

Owned by Saranya S
Last updated: Apr 23, 2024 by Mayuresh Balaji Kamble (Unlicensed)Version comment
2 min read

Read Complete Release Notes

Feature released in SummitAI Service Management (Tahoe SP3 HF01, Platform)

What's New?

Earlier, the translation was not supported for the following components in the Export to Excel functionality inside the downloaded excel in the selected language: 

  • Title   
  • Column Header  
  • Column Data 

The users can now translate these components into the selected language by configuring a few keys in the Web.config file throughout the application.

Prerequisites

Before you translate the Columns, check the following prerequisites:

  • Column Data must be in English language. 
  • To translate the Column Data, you need to configure the Column details in the JSON script. For configuration and additional information, contact the SummitAI Support Team. 

Benefits

Following are the benefits: 

  • Better user experience. 
  • Flexibility to use the application. 
  • Reduces time to use the application.


Configurations

To enable this feature, the admin must add the following keys in the Web.config file and add Weglot key in “App:WeglotKey“ 

  • Provide the Weglot URL in the following key 

    <add key="App:WeglotURL" value=https://api.weglot.com/translate?api_key= /> 

  • To Integrate the Weglot into SummitAI Application, provide the API key in the following key 

    <add key="App:WeglotKey" value="" /> // need to provide the Weglot key in value 

  • To translate the Export to Excel functionality the value must be ‘true’ in the following key 

    <add key="App:IsWeglotExportToExcelEnabled" value="true" />  

Note: The above 3 values must be configured correctly for exporting translated data to Excel or PDF formats. 

 

Limitations

The following are limitations where the translation is not applicable. 

  • If the sheet names in the Excel file exceed 31 characters. 
  • Abbreviated words and if there is no space provided in the text, for example, textboxname, then the translation is not applicable. 
  • If any images or graphs are present in excel.
  • The Excel sheet is attached to the e-mail. 
  • Download Template used to Import the data.  
    For example, if the downloaded templates are in a different language, when the user imports, it would not recognize the column names while mapping the data since they are mapped in English. 
  • Izenda Reports for Export to Excel not supported. 
  • Push Reports.