KevinMortimer

xslt export to csv problem when field to be exported is a related field

Discussion created by KevinMortimer on Mar 24, 2017
Latest reply on Mar 24, 2017 by KevinMortimer

If i run a normal export from Filemaker where the "specify field order for export" dialogue contains related fields (see attached pic), the export gives the first related record. This works fine with no problems.

 

If i do the same export using xml and xslt style sheet (using example from devcon 16 at time marker 48 minutes FM DevCon 16 / Core: Advanced Reporting and Dashboard Techniques - YouTube ). The export puts all the related data for a selected related field all in one cell instead of just the first value like in a standard export.

 

Is there a way to tel xslt stylesheet to only grab the first related value?

 

I hope this makes sense and that there is an easy solution.

Outcomes