Transforming Outputted Data

[fmsavey]

I am working on a solution that records employee overtime data. Periodically I will export records to our payroll system. The payroll system is very specific as to how imported data must be formatted. Someone suggested in this forum to export using xml and transform it using an xsl style sheet. This sounds like the best answer to this requirement. Problem is I have no experience writing style sheets and do not have any xsl editor. Can anyone recommend an inexpensive (preforably free) xsl editor (windows xp) and where I might get a crash course in style sheet writing.

Also, which FM xml grammar is better suited to a task like this, fmpxmlresult or fmpdsoresult?

[Martin Brändle]

- "crash course": the book of Beverly Voth, FileMaker Pro 6 Developer's Guide to XML/XSL, Wordware Publishing, 2003, ISBN 978-1-55622-043-2 (Beverly, I hope you forgive the crash course :-) )

- free editor: http://www.freexmleditor.com/

- grammar: fmpxmlresult