I think you need a XSLT file for each type of export. It's hard to be more specific with so few details. You can apply the XSL transformation during the export/s (all this can be scripted) or afterwards using a 3rd party processor. In any case, you can only export from one table at a time - so although you may include related fields in the export, there is no such thing as "dump the entire database".
You can format the XML file that FMP creates selecting a XSL style sheet
when exporting. So, your best bet is to script the export from FileMaker.
If you do not know XSLT, you can ask somebody to create your style sheet, or
you can learn XSLT. It's not that difficult.
There is a good XSLT reference here:
Andròmina eBusiness, SL
17171 Sant Martí Sacalm
Telèfon: (+34) 972 19 09 97
creato da colcustard <https://fmdev.filemaker.com/people/colcustard> in
Scripting and Calculations - Visualizza la discussione completa
Hi, 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. Thanks, Alan
Per rispondere a tale utente, rispondi a questo messaggio e-mail -o- accedi al
messaggio su FileMaker Technical Network
<https://fmdev.filemaker.com/message/71135#71135> Avvia una nuova discussione
in Scripting and Calculations per e-mail
er.com> o in FileMaker Technical Network
Manage your email preferences
pa> . FileMaker Developer Conference 2012 Miami, Florida July 16-19
remember that FMP uses XML 1.0 and XSLT 1.0. You cannot create multiple files with ONE export. you *can* create multiple files and combine them with the 'document' function, but that's not what you asked.
XML "export" can also be calculated (should you so choose, and if it's easier for you).
Custom web publishing is another option. You can "transform" with whatever application can process the data (as XML, or via xDBC).
Thanks for the reply, it looks like it will be easier to export the data in another format and process that externally. The spreadsheets that the client has supplied contain a mix of the data that I need in separate files, as well as related data from other tables.
Thanks for the XSLT reference link, I think that for this purpose based on the other replies that I'll need to go about it a different way.
Thanks, I've used AppleScript to export data for other apps so maybe that's the best way to move forward with this project. The data is across 10 or more tables and I need a subset of it in most cases.