Localization inside GetListAsExcelFileAsync() method #6667

9 उत्तर (ओं)

• 

  0

  liangshiwei बनाया था 3 months ago

  सहायता दल Fullstack Developer

  Hi,

  ABP internally uses Miniexcel to export Excel file.

  You need to use dynamic column names to support localization https://github.com/mini-software/MiniExcel?tab=readme-ov-file#7-dynamiccolumnattribute

  for example:

  var config = new OpenXmlConfiguration
  {
      DynamicColumns = new DynamicExcelColumn[] { 
          new DynamicExcelColumn("id") {Name = L["Id"]},
          new DynamicExcelColumn("name") {Name = L["Name"]},
          new DynamicExcelColumn("createdate") {Name = L["Createdate"]},
          new DynamicExcelColumn("point") {Name = L["Point"]},
      }
  };
  

  बचाना रद्द करना
• 

  0

  icoretchi बनाया था 3 months ago

  I know that. You didn't understand the question. The problem is in L, as StringLocalizer. It's not working properly. Try the example that you suggested to localize the colums for different language beside english.

  बचाना रद्द करना
• 

  0

  liangshiwei बनाया था 3 months ago

  सहायता दल Fullstack Developer

  Hi,

  Could you share some code? I will check it.

  बचाना रद्द करना
• 

  0

  icoretchi बनाया था 3 months ago

  Once again. Just try the code you have suggested:

  var config = new OpenXmlConfiguration { DynamicColumns = new DynamicExcelColumn[] { new DynamicExcelColumn("id") {Name = L["Id"]}, new DynamicExcelColumn("name") {Name = L["Name"]}, new DynamicExcelColumn("createdate") {Name = L["Createdate"]}, new DynamicExcelColumn("point") {Name = L["Point"]}, } };

  I am doing absolutly the same.

  बचाना रद्द करना
• 

  0

  liangshiwei बनाया था 3 months ago

  सहायता दल Fullstack Developer

  Hi,

  This is a problem, You can open the AppService.Extended.cs class to update the LocalizationResource

  

  We will enhance the suite in the next version, your ticket was refunded.

  बचाना रद्द करना
• 

  0

  icoretchi बनाया था 3 months ago

  In my context the LocalizationResource is properly assigned for the Application Service and localization for exporting to excel it's not working. And I have to mention that for microservices template all the application services are inherited from the base class which properly assign the LocalizationResource. I think the problem is in this specific method GetListAsExcelFileAsync() how is called from UI (in my case from Blazor). I reiterate again the L, as StringLocalizer is working properly from any method of the ApplicationService, besides the GetListAsExcelFileAsync.

  बचाना रद्द करना
• 

  0

  liangshiwei बनाया था 3 months ago

  सहायता दल Fullstack Developer

  Hi,

  Sorry, I can confirm this issue. we will fix it.

  You can try to update the DownloadAsExcelAsync method. for example:

  private  async Task DownloadAsExcelAsync()
  {
      var token = (await BooksAppService.GetDownloadTokenAsync()).Token;
      var remoteService = await RemoteServiceConfigurationProvider.GetConfigurationOrDefaultOrNullAsync("Qa") ??
      await RemoteServiceConfigurationProvider.GetConfigurationOrDefaultOrNullAsync("Default");
      var currentCulture = CultureInfo.CurrentUICulture.Name ?? CultureInfo.CurrentCulture.Name;
      if(!currentCulture.IsNullOrEmpty())
      {
          currentCulture = "&culture=" + currentCulture;
      }
      NavigationManager.NavigateTo($"{remoteService?.BaseUrl.EnsureEndsWith('/') ?? string.Empty}api/app/books/as-excel-file?DownloadToken={token}&FilterText={Filter.FilterText}&Name={Filter.Name}&Title={Filter.Title}{currentCulture}", forceLoad: true);
  }
  

  बचाना रद्द करना
• 

  0

  icoretchi बनाया था 3 months ago

  It's still not working properly.

  बचाना रद्द करना
• 

  0

  liangshiwei बनाया था 3 months ago

  सहायता दल Fullstack Developer

  I could not reproduce the problem

  

  

  

  

  बचाना रद्द करना