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

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

 

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

• 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");

• This is a known issue in Lumira SP 22.1

• 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

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

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