AnsweredAssumed Answered

XML import field mapping setting no longer ignored in FMP 11

Question asked by isisdesign on Sep 21, 2011
Latest reply on Dec 21, 2011 by isisdesign

Summary

XML import field mapping setting no longer ignored in FMP 11

Product

FileMaker Pro

Version

11.0v3

Operating system version

Mac OS X 10.6.8

Description of the issue

For an in depth description please read  http://forums.filemaker.com/posts/8504da1792. Didn't see the tab for "Report an issue..."

Summary:

So to sum up, FMP 9/10 appears to have ignored the "Arrange by:" setting in "Specify import order" settings when importing XML and using XSLT. Now FMPro 11 is not ignoring the "Arrange by:" setting.  If in an import script step of an xml file using xslt you set "Arrange by:" settings to use "matching names" the xml data winds up in the correct fields; if you specify the "Arrange by:" settings to some random order that is not the order as specified in the xslt file, then FMPro puts the data into the wrong fields.

Steps to reproduce the problem

1. Specify an import file script step to use XML file with XLST.
2. Specify the "Arrange by:" settings to use some random specified order that is different than the order of the elements as defined in the XSLT file.
3. Run the script and the data will be put into the fields as specified by the order in the "Arrange by:" settings, not by element to field name matching as FMPro 9/10 did.

Expected result

In FMPro 9/10, the "Arrange by:" setting was ignored and the implied matching of XML/XSLT element names to table field names worked. I expected it to be the same in FMPro 11. Or there should be documentation in the Import script step or the XML import online help to clarify how one should set the "Arrange by:" setting when using XML; there is none.

Actual result

In FMPro 11, the "Arrange by:" setting is not ignored and the implied matching of XML/XSLT element names to table field names is ignored and FMPro 11 puts data into the fields as specified in the "Arrange by:" setting.

Exact text of any error message(s) that appear

No error message.

Configuration information

none.

Workaround

Specify "Matching names" in the "Arrange by:" setting. Or is this the way it is supposed to be and FMPro 9/10 had a bug in ignoring the "Arrange by:" setting? Dear Filemaker, please let us know.

Outcomes