User talk:Wolfganguhr
Actual Work
Data Conversion from Petra to Openpetra
Error Messages and Error Messages
Notes
File:Code-overview.JPG
https://dev.solidcrp.com/wiki/index.php/Restore_the_Petra_Data_Base
Snippets
Getting the correct number of digits
Actually there is one efficient way to get the information about the maximal precision of a currency. The table a_leder provides the column a_country_code_c. The value in this column shall be used to create a .net CultureInfo class. Actually the values are two character codes for example "DE".
try { numberFormatInfo = new System.Globalization.CultureInfo( ledger.CountryCode, false).NumberFormat; } catch (System.NotSupportedException) { numberFormatInfo = new System.Globalization.CultureInfo( String.Empty, false).NumberFormat; }
If the countryCode is "DE" then the NotSupportedException will be thrown. You really need a code in the syntax <languagecode2>-<country/regioncode2> where the two digits for the language code are based on ISO 639-1 and the regicode is based on ISO 3166. Then numberFormatInfo.NumberDecimalDigits holds the correct value.
TODO: We have to investigate if an automatic conversion of this values may be necessary. Italic text