Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Moving Data from FMP to a Text File

Featured Replies

Hi Gang,

I'm on FMP 6.0 and Win XP. I would like to build a text file (filename.txt) from info contained in FileMaker.

I've tried using the SendMessage with an echo statement but no luck. Any ideas?

Thanks,

-Ted

Concatenate the fields which contain the information that you want in the txt file, into one text field, and export that field alone to a tab seperated file.

Se enclosed demo.. Run the script Export, and it will create a file named Export.txt in the root of your C: drive.

Just my 0.02

exporttotxt.zip

Why not use the export command found in the file menu do the following:

pick the file export menu item, select a type tab, comma, etc. Pick the fields to export, choose a filename and location, perform the export, check it by importing into whatever you want. If ok go back to Fm, set up a one line script choose the command export in the script menu under records heading, click the restore export order box, perform without dialog if you want and select the test file name after you click the check box next to the dialog. close the script, now all the settings for the export are saved in this one line script, if you need to change them run the export command again from the menu then open the script and just close it, a dialog will appear asking if you want to replace the export settings, say yes and your modificatons are saved.

Rod

Because as far as I understod TedS's wish, it was that he wanted to build a text file with information from various fields, and most probably also additional text..

Using the approach I described, and show in the examplefile attached, he can build the text for the file in the global textfield statically or dynamically, and only export that field, thereby avoiding the tabs or comma's between each field, in the exported text file.

Just my 0.02

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.