2114336 - Lumira Desktop Data Access Extensions do not display currency symbols

SAP Knowledge Base Article - Public

2114336 - Lumira Desktop Data Access Extensions do not display currency symbols

Symptom

  • Data access extension displays incorrect characters when using currency symbols.
  • Example: £ displays as A'':

 

Untitled.png

Environment

  • SAP Lumira 1.20 and 1.21 (internal testing - v. 1.22)
  • Visual Studio .NET 2013, framework 4.0
  • WIN 7, 64 bit

Reproducing the Issue

  • Follow the instructions in the following blogs to setup Lumira for Data Access Extensions:

 

http://scn.sap.com/community/lumira/blog/2014/09/24/my-personal-guide-to-sap-lumira-data-access-extensions

http://scn.sap.com/community/lumira/blog/2014/09/26/data-access-extensions-part-two-the-simplest-lumira-data-access-extension-possible

 

  • Use the following code:

 

          var encoder = System.Text.Encoding.GetEncoding(858);    
                    byte[] c = new byte[] { 156 };
   
                    Console.WriteLine("beginDSInfo");
                    Console.WriteLine("csv_separator;,;true");
                    Console.WriteLine("csv_date_format;yyyy-m-d;true");
                    Console.WriteLine("csv_number_grouping;,;true");
                    Console.WriteLine("csv_number_decimal;.;true");
                    Console.WriteLine("csv_first_row_has_column_names;true;true");
                    Console.WriteLine("endDSInfo");
                    Console.WriteLine("beginData");
                    Console.WriteLine("Name," +  encoder.GetString(c) + " Amount , Date");
                    Console.WriteLine("Jim Doe, 24.5, 2024-10-31");
                    Console.WriteLine("Amit Doe, 30, 2010-12-25");
                    Console.WriteLine("Jane Doe, 24.5, 2024-10-31");
                    Console.WriteLine("Amit Doe, 30, 2010-12-25");
                    Console.WriteLine("endData");

Cause

  • This is a known issue in Lumira SP 22.1

Resolution

  • This issue is resolved in Lumira SP 23 by setting the code page for Lumira to use in the saplumira.ini file.
  • To set the code page for Lumira to use edit the saplumira.ini file in the installation directory and add the following line to the end of the file:

-Dfile.encoding= <code page>

  • Code page can be one of the items found here. For example:

-Dfile.encoding=UTF-8

Keywords

acess aces  code page 437 (Default MS-DOS) 858 curency , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP BusinessObjects Lumira, desktop edition all versions ; SAP Lumira, desktop edition all versions