4 Replies Latest reply on Mar 11, 2011 9:45 AM by JPetersen

    Export to same document

    anicolais

      Title

      Export to same document

      Post

      Is there a way in the same script to find some criteria and export it to an XLS file then perform another find and export that data to the same XLS file as before??

       

      Thanks

        • 1. Re: Export to same document
          davidhead
            

          An export has no ability to append to an existing file (although that would be a good feature request - similar to the Append to PDF function).

           

          What you could consider is importing to a holding table in the same file. This could be done multiple times to build the record set and then finally export from the holding table to Excel.

          • 2. Re: Export to same document
            comment_1
               Why don't you simply find all the records you need at once - or even piecemeal, by using Extend Found Set?
            • 3. Re: Export to same document
              philmodjunk
                

              comment wrote:
              Why don't you simply find all the records you need at once - or even piecemeal, by using Extend Found Set?

               

              Perhaps each export is separated by events that generate additional data?
              • 4. Re: Export to same document
                JPetersen

                The ability to append to file rather than over-writing it isn't a feature, it's a basic need of any data processing application.

                It should be a global ability, not just a "feature" of exporting to PDF files. I hope Apple gives more comprehensive thought to Filemaker structure in the future.

                It's impractical to think the user can simply find all the records and export.

                1. The information might not be in individual records or even in individual fields. It might be in a container, or in a field that holds dynamic data like a URL. No way to export this all at once... you may need to record one Monday, three Tuesday, and five on Wednesday.

                2. Populating fields into a list and exporting all of it is inefficient compared to appending a file, and clutters up the administration of fields.

                3. There might be many users using the app at different times for different needs, but with common ground, such as a file that saves aggregated info from various users on stock picks, or favorite YouTube vids, newly scheduled meetings, or recommended blog posts. Some kinds of data generate many lines and contain information that is ephemeral. You don't want to create hundreds of records containing a single field for something with a limited lifespan that would have to be deleted again. For this, an appended file log is better than storing data in individual records or repeating fields.

                Append is not the icing on the cake or even the cake itself. It's the plate that holds the cake. It should be accessible to all file export functions.

                So... has anyone solved this? I too need to append to files.