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.

First line of file will not import.

Roger E
in Importing & Exporting

Featured Replies

  • Newbies

HI all

I am trying to import a .csv file into FM5. The fields are mapped to import into global fields, which is all working well but for one thing.

I simply cannot get the first entry in the file to import. It is an 8 digit number mapped to import to a global number field. If I import it on its own to a normal number field, that works fine, but not if I try it to the global number field.

Does anyone have any ideas?

Many thanks

Roger E

Importing into global fields (which are record-independent) doesn't work very well. A few tests seem to show that the global field will accept whatever lines up in the "second record imported", so if you move (or copy) the data to the correct position in what will import into the second imported record, it just might work.

  • Author
  • Newbies

Thanks danjacoby, I've changed the data format so that the first field is blank and everything has 'moved down one' and it's working just fine now. smile.gif

Create an account or sign in to comment

https://fmforums.com/topic/10975-first-line-of-file-will-not-import/
Go to topic listing

Important Information

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

I accept

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.