[FX.php List] Re-That sinking feeling: FileMaker 12 & FX ?

[Troy Meyers]

Unless I really goofed, the spreadsheet shows that the XML from the WPE is messed up.

What seems to be happening is that the XML from the WPE shows all of the expected field names including the field names in the portals, but if any of the portals have NO related records in them, then in the <RESULTSET> section, all of those <COL>...</COL> items are totally omitted, instead of having place-holders in the form of <COL><DATA/></COL>.

Since, in this example record I've been looking at, there are 145 normal + portal fields, and 4 of the 6 portals have no related records, there are way fewer <COL>...</COL> items returned than there should be, so as soon as the first column that has an empty-portal field is encountered, all the data is misaligned. That is, good data from real, filled fields, starts falling in the spots that empty portal columns should be.

Am I being incomprehensible?

Anyway, is this a huge bug in the WPE in FileMaker Server 12? Can anyone reproduce this?

-Troy



> Dear Troy,

> Is there an XML-reading tool that I can dump this into to correlate  
> the field names in the <METADATA> section with the values in the  
> <RESULTSET> section? Obviously this is what FX is supposed to be  
> doing, but the FX array returned has the field names and values  
> misaligned. Is there an XML tool that I can use to quickly check to  
> see if the alignment is off as coming from the WPE, or if the error  
> is introduced in the FX interpretation of the XML?

> 
> Short answer: No. The FileMaker XML is kinda brain dead and extra  
> wordy, and I've yet to meet an XML tool that will let you compare the  
> metadata with the actual data like that...
> 
> Cheers
> 
> Webko