4 Replies Latest reply on May 4, 2017 6:07 AM by beverly

    FM 15 Adv - Export to FMPUR file?

    synergy46

      I have a 'main' table (Members) and numerous related tables that are placed on the Members layout as tabs with portals.

       

      I want to export/save all the 'Inactive' members AND their related tables in the form an single fmpur file that users can 'reimport' if they want to see the inactive records.

       

      Export seems to require me to produce several files and Save copies the ENTIRE file and not just the found set.

       

      Is this possible?  How should I proceed?

       

      Thanks

       

      Ron

        • 1. Re: FM 15 Adv - Export to FMPUR file?
          brucewilson

          I use a script to gather and format ALL the related information into a single field, in XML-like format, then export just that field.

           

          Import is a reverse process, a script imports everything into a holding field, then creates and populates the required records.

           

          Bruce

          • 2. Re: FM 15 Adv - Export to FMPUR file?
            Markus Schneider

            tables to tables, fields to fields...

            xml could be used - but You can also create several exports, put them in a folder, then You could import the data via scripts. Automatically

             

            (in this case, the fmpur file needs to be enhanced, otherwise it's a manual process)

            • 3. Re: FM 15 Adv - Export to FMPUR file?
              philmodjunk

              Export records exports the current found set. You can export a merge file to just export the data and yet be able to re-import the data using the matching names option.

              1 of 1 people found this helpful
              • 4. Re: FM 15 Adv - Export to FMPUR file?
                beverly

                FMPUR = ??

                if you are talking about a database/file linked to a Runtime, then your options may be limited.

                 

                Exporting parents and children as raw XML would work. It would allow you to import (directly) the parent records using the 'FMPXMLRESULT' grammar. The children could be imported with an XSLT stylesheet. Once created (unless the fields and import order changes), this can be used again and again.

                 

                Regardless of 'method', you cannot import child record(s) at the same time as the parent records. It will always involve multiple imports.

                 

                Export as .mer will be the same as .csv, but include field names (for matching upon import).

                 

                beverly