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

    XML Import

    PatrickR

      Summary

      XML Import

      Product

      FileMaker Pro

      Version

      11.0v2

      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
          TSGal

          PatrickR:

          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.

          TSGal
          FileMaker, Inc.

          • 2. Re: XML Import
            prisch

            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.

            Patrick

            • 3. Re: XML Import
              PatrickR

              Hi TsGal

               

              are there any news about this bug?

               

              Regards

               

              Patrick

              • 4. Re: XML Import
                TSGal

                PatrickR:

                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?

                TSGal
                FileMaker, Inc.