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.

Import Field Names from Tab File

Featured Replies

I have a tab-delimited file and the first record is the field name. I want to create an fp5 file with the same field names. Dragging the file to Dev. 6 creates a record out of the names. crazy.gif

When I start by creating a new file, it wants the field names. ooo.gif

And I can't import until I create a file! wink.gif

I searched forums ... I really did. But I admit I only looked for an hour, trying every keyword I could think of. Still, here I am ... Please tell me I won't have to manually create 205 field names for a migration file? Lie if you have to ... smirk.gif

OK -

How about converting this Tab delimited file to an Excel spreadsheet, with the first row containing your field names?

Then you can drag that straight onto Developer 6 and it will create a new file with your field names.

No manual creation required (except opening into Excel of course )

HTH

Ooh, that's neat, Andy!

  • Author

Andy, this is absolutely brilliant! You just saved me HOURS worth of work. yay.gif

Thank you so much! Bang-zoom-done. And you didn't even have to lie!! grin.gif

For the one or two of you that don't have Excel, you can get the same effect by converting the first line of the text file into the format of a Merge file. Move the 1st line out into its own file, then substitute commas for tabs.

You will get basically:

fieldname1,fieldname2,fieldname3, etc.. (no leading spaces, no quotes)

Open the 1 line file with FileMaker.

You've got a file with the field names.

Import the rest of the lines.

Obviously easier to open with Excel.

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.