AnsweredAssumed Answered

XML Import

Question asked by PatrickR on Jan 10, 2011
Latest reply on Sep 30, 2011 by TSGal

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).

Outcomes