Localization in EJ 1 ASP.NET MVC PivotChart

13 Feb 2019 / 2 minutes to read

Localization in PivotChart

We can localize the PivotChart controls text with a collection of localized strings using ej.PivotChart.Locale for different cultures. By default, the PivotChart control is localized in “en-US”.

Following code example illustrates on how to localize PivotChart based on “French” culture.

  • cshtml
  • @Html.EJ().Pivot().PivotChart("PivotChart1").Url(Url.Content("/RelationalChartService.svc")).Locale("fr-FR").Size(size => size.Height("320px").Width("100%"))
    
    <script type="text/javascript">
        ej.PivotChart.Locale["fr-FR"] = {
            Measure: "Mesure",
            Row: "Rangée",
            Column: "Colonne",
            Value: "Valeur",
            Expand: "Développer",
            Collapse: "Effondrement",
            Exit: "Quitter"
        };
    </script>

    Following table localizes the in-built keywords to “French” culture for PivotChart.

    Keywords Values
    Measure “Mesure”
    Row "Rangée "
    Column "Colonne”
    Value "Valeur "
    Expand "Développer "
    Collapse "Effondrement "
    Exit “Quitter "

    Localization and Globalization of Cube Info (Client Mode)

    Content displayed within the PivotChart control are obtained from the OLAP Cube. So following are the steps that needs to be done to get the localized and globalized Cube content.

    • To get localized data from OLAP Cube, we need to set “Locale Identifier” in the connection string to a specific culture in the “Data” property present inside “DataSource”.
    • To bind the globalized content in PivotChart control, we need to set “Locale” property to a specific culture and want to refer specific culture file in the sample.

    NOTE

    Culture files are present under “[installed drive]:\Users[user name]\AppData\Local\Syncfusion\EssentialStudio\X.X.X.X\MVC\Samples\web\Scripts\cultures”.

  • cshtml
  • //1036 refers to “fr-FR” culture.
     @Html.EJ().Pivot().PivotChart("PivotChart1").Locale("fr-FR").CommonSeriesOptions(comm => { comm.Type(SeriesType.Column).Tooltip(tool => { tool.Visible(true); }).EnableAnimation(true); }).Size(size => size.Height("350px").Width("100%")).PrimaryXAxis(primaryXAxis => primaryXAxis.Title(title => title.Text("Date - Fiscal")).LabelRotation(0)).PrimaryYAxis(primaryYAxis => primaryYAxis.Title(title => title.Text("Internet Sales Amount"))).Legend(legend => legend.Visible(true).RowCount(2)).ClientSideEvents(
                      oEve => { oEve.Load("loadTheme"); }).IsResponsive(true).DataSource(dataSource => dataSource.Rows(rows=>{rows.FieldName("[Date].[Fiscal]").Add();}).Columns(columns=>{columns.FieldName("[Customer].[Customer Geography]").Add();}).Values(values => { values.Measures(measures => { measures.FieldName("[Measures].[Internet Sales Amount]").Add(); }).Axis(AxisName.Column).Add();})
    .Data("https://bi.syncfusion.com/olap/msmdpump.dll;Locale Identifier=1036;").Catalog("Adventure Works DW 2008 SE").Cube("Adventure Works"))

    Localization and Globalization of Cube Info

    Content displayed within the PivotChart control are obtained from the OLAP Cube. So following are the steps that needs to be done to get the localized and globalized Cube content.

    • To get the localized string based on different cultures, from OLAP Cube, we need to set “Locale Identifier” in the connection string to a specific culture.
    • To bind the globalized content in PivotGrid control, we need to set “Culture” and “OverrideDefaultFormatStrings” properties in OlapDataManager class to a specific culture.
  • c#
  • //1036 refers to “fr-FR” culture.
    string connectionString = "Data Source=localhost; Initial Catalog=Adventure Works DW; Locale Identifier=1036;";
    DataManager = new OlapDataManager(connectionString);
    DataManager.Culture = new System.Globalization.CultureInfo(1036);
    DataManager.OverrideDefaultFormatStrings = true;

    Localization support in ASP NET MVC pivot chart control