Import doesn't serialize new records

[gregm1]

I can't believe I've fallen at such an early stage of reacquainting myself with FMP. I have a very simple database set up with ten fields which will be an asset register. I want to import several Excel files into it that my colleagues have filled out. When I try this, even though I select the option to auto-serialize, it doesn't. What could I possibly be doing wrong?

[myopus]

Hi,

wether you've adjust your field to be serialized, you can see another window within the manual import process.

You must pick the option "Perform auto-enter options while importing".

Gilles

[IdealData]

Unfortunately this also performs lookups and resets the creation/modification dates if they exist.

If you just need to reset the serial number(s) then after the import go to the last record of the import layout and reset the serial number(s) with

YourSerialNumber = YourSerialNumber + 1

[gregm1]

Yes, I'm already selecting the option to perform auto-enter options when importing. When I create a new record it populates the serial number field, and the number is as if it had incremented the field during the import process correctly. So if I import 10 records, when I create an eleventh record manually, the serial number is 11. But the previous 10 records have no serial number displayed in the field. Is it a field format thing maybe?

[myopus]

Are you sure that nothing is imported in your ID's field during import ?

[gregm1]

Good point. The fields are empty after the import, and each row of the csv file starts with a comma. So it looks as though nothing is being imported into these fields. If I insert a numeral at the beginning of each line of the csv file, those get imported into the field.

This is doing my nut in!

[comment]

it looks as though nothing is being imported into these fields.

Literally - you are importing NOTHING (an empty value) into the field. You should remove the field entirely from the import field mapping (make sure there is no arrow pointing to it).

[gregm1]

Thank you, easy when you know how!