First line of file will not import.

[Roger E]

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

[danjacoby]

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.

[Roger E]

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.