6 Replies Latest reply on Dec 6, 2016 11:44 PM by Lawrencex

    Saving FileMaker .fmp12 file as a "flat .fmp12" file.


      Dear FileMaker Pros,


      Would appreciate your tips/hints for the following:


      My database created in FileMaker 15  (Win 10) has more than 100 Fields,

      and over 80 million records in each Fields. The file size is approximately

      2.5 GB.   Those Fields contain calculations.


      I am NOT using scripts for the calculations as it consumes so much of

      time processing the entire records (takes 8 hrs.)


      So, when the calculations are complete, I export the Field data to a

      new .fmp12 file, so that the data becomes "flat" without any calculations.


      The problem again, the export process is time consuming, and it almost

      takes the same time as running the scripts for the calculations.


      Would appreciate your tips/hints, if there is a way to save the .fmp12 file

      as a "flat" file, meaning, saving the file/data without the calculations, but

      the calculated values only.  For example, in MS Excel, this is achieved by

      the "paste as value" options, and the calculations are pasted over with the

      calculated results/values.


      I use the data for analytics.


      Thanks in advance for your tips/hints.