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

[Dale Bengston]

Troy, a clarification... are these portals with empty rows that are being skipped, or are they individual related fields that are on the layout?

In the olden days (maybe still true), individual related fields would be suppressed if they were empty, unless they were placed in a 1-row portal.

Just triangulating,
Dale


On May 8, 2012, at 5:24 AM, Beverly Voth wrote:

> What happens to the XML if you just EXPORT from the same layout? You should get the same set of elements. Yes, a portal can be empty, but it sounds like you are getting empty when there are portal rows with DATA. 
> 
> Also try an XML query via web publishing using one of the other grammers. 
> 
> -- sent from my iPhone4 --
> Beverly Voth
> --
> 
> On May 8, 2012, at 2:39 AM, Troy Meyers <tcmeyers at troymeyers.com> wrote:
> 
>> 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
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list