4 Replies Latest reply on Sep 30, 2011 9:21 AM by TSGal

    XML Import



      XML Import


      FileMaker Pro



      Operating system version

      Windows XP

      Description of the issue

      Importing an XML file into FileMaker will result in wrong numbers.

      Steps to reproduce the problem

      0. Prepare a Windows System with the regional settings for Germany (decimal separator is , ).
      1. Export a XML file (choose some number field with have digits like 81.2500007) - 81 before the decimalseperator 2500007 after the decimalseparator). The XML standard uses a . as a decimal separator.
      2. Import the XML file in a FileMaker  file. Match the number field with a number field.

      Expected result

      The number should show in FileMaker as 81.2500007 (that means 81 before the decimal separator and 2500007 after the decimal separator).

      Actual result

      The number shows in FileMaker as 812500007 (the decimal separator . is ignored.

      Exact text of any error message(s) that appear

      Additional Info:
      A number less than 0 will import correctly  (like .625).

        • 1. Re: XML Import


          Thank you for your post, and I apologize for the late reply.

          Was the FileMaker database file created under German language or English language (and then switched to German)?  I mention this because there have been some display issues when a file is created in one language and then switched to a different language.

          Does this also occur with numbers with less decimal places?  For example, 81.25 (rather than 81.25000007)

          Do negative numbers encounter the same issue?

          Any other information you can provide may be helpful.

          FileMaker, Inc.

          • 2. Re: XML Import

            Hello TsGal

            The files were created under the swiss german file settings. It is not just a display issue. The data gets rather faulty imported. The import is also wrong with less numbers, even 1.1 will be imported as 11.

            I have not tested it yet with negative numbers.


            • 3. Re: XML Import

              Hi TsGal


              are there any news about this bug?





              • 4. Re: XML Import


                In your example, you show your decimal separator as a comma, but your field shows a period, so this would be ignored.  Can you verify?

                FileMaker, Inc.