AnsweredAssumed Answered

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

Question asked by mrwatson-gbs on Jun 29, 2017
Latest reply on Jul 2, 2017 by Johan Hedman

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

Outcomes