Skip 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.

Importing ascii comma file using 'matching names'

Featured Replies

  • Newbies

Hi,

I'm having a problem importing an ascii comma file. When I try to import it, I am unable to specify by 'matching names'; It appears to be disabled. However, when I try importing an excel file, 'matching names' is enabled. I was originally using excel, but I have to import more than excel's column limit allows.

What I need to do is be able to import a file with more than 256 columns and be able to at least map it correctly for the first run.

Anyone know how I can do this?

When importing ASCII files, FM doesn't recognize any format for what might be interpreted as "Names". It would be useful if you could specify "use first record and field names" or such, but this type of operation is not supported. Excel allows such an option. In order to use the "matching names" option, you must import one of the file types that supports it (FileMaker, SYLK, DBF, etc.).

-bd

Import it as a merge file. These are comma delimited, but use the first line for field names. You can select the "matching names" option with this format.

  • Author
  • Newbies

Importing as a merge file worked great - Thanks!

Since the program I was extracting data from couldn't export merge files, I just used ascii comma and changed the extension.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.