Export & Transform with multiple XML sources

[sirius50]

Edited April 23, 2006 by Guest

[Fenton]

I'm not quite sure what it is you want to end up with. You posted some xml before the xsl. But your xsl has a lot of different elements, such as

, etc., which are not in the xml you posted.

I also don't see why you need to use the document() function to bring in an xml file, since FileMaker can call the xsl file during the import, to transform its xml output.

I've made an example, using a FileMaker file and a simpler xsl. It produces the xml at the top of your post. But that may not be what you need. It is exporting from the Student table, with the report data as related fields.

It has really only 1 trick, which is to capture the position() of the first related field into a variable, then to use this to specify the following sibling field(s) (only 1 other in this case). This essentially provides:

DATA[1]

DATA[2]

which is what you need to get the related fields (I think of it like "portal row #"; though no portal is required).

StudentReports.zip