AnsweredAssumed Answered

XML export from portal fields

Question asked by squire on Jan 17, 2015
Latest reply on Jan 18, 2015 by squire

Sorry if this post appears twice. I appear to have posted it in a personal discussion area first, and can't see how to move it.

 

I need to export data in XML format from a college database for a government department. This is the first time I've used FileMaker's XML export capability. Analysing output in my initial tests, I find FileMaker omitting some duplicated data when exporting from portal rows. E.g., if fields in the portal rows contain:

 

Apples     Red

Berries     Red

Grapes     Green

 

then the XML output for this section reads:

 

<COL>

     <DATA>Apples</DATA>

     <DATA>Berries</DATA>

     <DATA>Grapes</DATA>

</COL>

<COL>

     <DATA>Red</DATA>

     <DATA>Green</DATA>

</COL>

I can see this adding significant complications to the XSL transformations I will need to do. Does anyone know how to address this issue, please?

Outcomes