Jump to content

Export & Transform with multiple XML sources


sirius50
 Share

This topic is 5704 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 5704 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.