This guide explains how to enable and use localization (language translation) in Helical Insight using a simple patch.

The goal is to make the application support multiple languages in a way that’s easy for both developers and end users.

1. Installation Steps

  1. Download the LocalizationPatch.zip file and unzip it.
  2. Inside the extracted folder, you’ll find a folder also named LocalizationPatch. Copy this folder and paste it into the following directory:

    …/hi/apache-tomcat-9/webapps/hi-ee/js

  3. Open the file loginBody.jsp in edit mode. It is located at:

    …/hi/apache-tomcat-9/webapps/hi-ee/WEB-INF/jsp/login

  4. Add the following script tag to the file:

    <script src="${baseURL}/js/LocalizationPatch/home.js"></script>
    This script connects the localization functionality to your application.

2. Folder Structure

The LocalizationPatch folder contains:

  • A folder named langs:
    • en-US.json
    • fr.json
    • es.json
  • A JavaScript file: home.js

Explanation:
– The langs folder contains JSON files for different languages. Each file has key-value pairs — where the key is the English text and the value is the translated text.
– The home.js file is responsible for translating the application’s text based on the selected language.

3. How It Works

Language Detection and Translation

  • When you pass a language (locale) in the URL, the app uses that language for translation across all pages — even if the URL doesn’t continue to show the locale.
  • If no locale is passed in the URL, the application automatically checks the browser’s preferred language and translates the text accordingly (if a corresponding JSON file exists).

Example:
If a user’s browser is set to French, the application will automatically use the fr.json file for translation.

4. Language JSON Files

  • These files contain key-value pairs (e.g., "Hello": "Bonjour").
  • The structure is the same for all language files.
  • To add a new language:
    • Create a new JSON file with the same structure.
    • Name the file using the appropriate locale code (e.g., de.json for German).

5. Code Overview

Single File Used: home.js

This file contains two main functions:

  1. getParams()
    – Extracts the locale and timezone from the URL.
    – If nothing is passed, it falls back to the browser’s preferred language.
  2. textTranslator()
    – This is the main function responsible for translating the UI.
    – It:

    • Loads the correct language JSON file based on the locale.
    • Traverses each HTML element and replaces the English text with the translated version.
    • Uses MutationObserver to detect and translate new elements added dynamically to the page.
⚠️ Important: A sentence may appear as a single line in the UI but be made of several HTML elements (like <div> and <span>). Each part must have a separate translation entry in the JSON file.

6. Updating Existing Language Files

If a word or sentence isn’t translated:

  1. Use the browser’s Inspect Tool to find the exact English text.
  2. Get the correct translation for your language.
  3. Add the new key-value pair to the relevant JSON file (e.g., add to fr.json for French).
  4. Save the file and refresh the page — the new text will now be translated.

7. Adding a New Language

To add support for another language:

  1. Create a new JSON file in the langs folder.
  2. Follow the same format as the other JSON files.
  3. Use the locale code as the filename (e.g., it.json for Italian).
🔴 Note: The translation function is case-sensitive. Ensure the keys in the JSON file exactly match the text in the UI.

For example:
– If the UI says Hello, then the key must also be Hello, not hello.

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered