5 Replies Latest reply on Jul 2, 2017 12:17 AM by Johan Hedman

    Import XML with german numbers in german file on US-Windows is failing

    mrwatson-gbs

      Context

       

      Windows Server 2012 R2

      FileMaker Pro 15.0.3

      FileMaker Server 15.0.3

       

      Issue

       

      We have a database developed in Germany which uses XML-Export + Import to move numbers around in the DB. This has been in use for years on German systems, and the decimal separator, a comma, has always been exported and imported correctly.

       

      We now have a problem on a Windows machine (set up as US-English) where the comma is incorrectly being converted to a dot.

       

      The problem seems to be that:

       

           The XML-import is using the system's decimal separator whereas it should be using the file's decimal separator!

           (Maybe it is a general problem when the system's and file's decimal separators are different)

       

      I'm afraid I can't upload images to the forum at the mo, as it has a bug, so here is the situation textually:

       

      Steps to Reproduce

       

      Set up a file and system with these settings + actions:

       

      • Windows Region = English (US), decimal separator = dot
      • FileMaker Pro UI Language = English (or German - didn't have any effect)
      • Target FileMaker File decimal separator = comma (1/2 -> ,5 = "comma-five")
      • XML to Import = <Number>7,88</Number>
      • Target field is a number field with NO AutoEnter calculation
      • XML-Import is matched on names with NO AutoEnter calculation
      • Import with dialog => The number is VISIBLE in the import dialog with a COMMA as separator
      • Directly after the import, the target number field contains a dot. (7.88)
      • The target number field is  formatted to show two decimal places

       

      Expected result

       

      • The number field should show 7,88
      • Clicking in the field shows 7,88 too

       

      Actual Result

       

      • The number field shows 788,00 - 100 times too much
      • Clicking in the field shows 7.88

       

      Bummer!

       

      Workaround

       

      The workaround seems to be to ensure that the system and the file decimal separator are the same.

       

      • You can change the separator in the operating system (On Windows you can change it (dynamically ) to a comma -> and then it works)

       

      Alternatively, you can clone the file to change its internal decimal separator to a dot -> this is what we do for our Swiss customers, who also work with a decimal point = dot.

       

      The bug

       

      In my opinion, however, this is a bug in the FileMaker XML-Import which should NEVER convert the decimal separator to the system decimal separator. This CLEARLY will NEVER create correct numbers in a file where the decimal separator is something else!

       

      While this bug exists, it will never be possible to use such a file in an international organization that uses OSes set up with different decimal separators.

       

      Please consider fixing this.

       

      Thank You

       

      MrWatson