6 Replies Latest reply on Feb 21, 2012 1:49 PM by colcustard

    Custom XML export

    colcustard

      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

        • 1. Re: Custom XML export
          comment

          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".

          • 2. Re: Custom XML export
            PepEspunyes

            Alan,

             

            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:

            http://www.w3schools.com/xsl/

             

             

             

             

            --

            Pep Espunyes

            Andròmina eBusiness, SL

            La Triola

            17171 Sant Martí Sacalm

            Telèfon: (+34) 972 19 09 97

            http://www.andromina.com

            http://www.androminarent.com

             

             

             

            <https://fmdev.filemaker.com/index.jspa>

            creato da colcustard <https://fmdev.filemaker.com/people/colcustard>  in

            Scripting and Calculations - Visualizza la discussione completa

            <https://fmdev.filemaker.com/message/71135#71135>

             

            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

            <mailto:discussions-community-discuss-scripting_and_calculations@fmdev.filemak

            er.com>  o in FileMaker Technical Network

            <https://fmdev.filemaker.com/choose-container!input.jspa?contentType=1&contain

            erType=14&container=2035>

                                    Manage your email preferences

            <https://fmdev.filemaker.com/index.jspa/user-notification-preferences!input.js

            pa> . FileMaker Developer Conference 2012 € Miami, Florida € July 16-19 €

            www.filemaker.com/devcon

             

            • 3. Re: Custom XML export
              beverly

              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).

               

              Beverly

              • 4. Re: Custom XML export
                colcustard

                Hi Michael,

                 

                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.

                 

                Alan.

                • 5. Re: Custom XML export
                  colcustard

                  Hi Pep,

                   

                  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.

                   

                  Alan

                  • 6. Re: Custom XML export
                    colcustard

                    Hi Beverly,

                     

                    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.

                     

                    Alan