3 Replies Latest reply on Jan 22, 2014 2:54 PM by philmodjunk

    Write to text file

    JonathanOxborrow

      Title

      Write to text file

      Post

           I need my database to write information from a number of fields to a .txt file that I'll be able to send via FTP.  Does anyone know if Filemaker 12 is capable of writing data to .txt?

        • 1. Re: Write to text file
          philmodjunk

               Export Records can export data to a file of type .txt. There are several options, in fact that can produce a file of that type and extension: Merge, CSV and Tab.

               But each of these put delimiters, either commas or tabs between different fields of the same records specified in the export so this may create an issue to solve for getting the results that you want.

               And you can use Export Field contents to export the contents of a single field to a text file so that may also be an option to consider.

               And I've seen mention of a plug in that allows a script to repeatedly write data to the same file, appending the new data to that already found in the file...

          • 2. Re: Write to text file
            JonathanOxborrow

                 That does sound like it will work since I'll need to write to a new file every time I use this option, though I only need to export a few fields at a time.  Does the export field option let me move only 3 fields? 

            • 3. Re: Write to text file
              philmodjunk

                   Yes