I have a database containing many tables and relations that I need to export as a series of custom XML files. The XML files will be used in a Flash based application so the format is decided by the application developer.
The built-in XML export doesn't help, I need to export parts of the full data set to many files and wondered what the best way of doing this would be?
The database is a multiple language product catalogue, I need to split the languages out separately, one XML file per language as well as the product details without the languages.
Would I need to script the data out into an XML file, or dump the entire database and then process the FileMaker XML files in an external XML application?
Any help or suggestions would be appreciated.