ID Numbers & importing from excel

[sherrick]

I imported a list of contacts from an excel spread sheet and when doing so the the imported items do not get ID numbers for each contact. If i switch to a table view I am able to enter ID numbers into the field, however when I create a new blank record the ID numbers given to the new record can and do repeat the same number and cause the database issue when linking to other database files.

Any help on how I can get the data base to recognize all the existing ID numbers would be appreciated.

[bcooney]

Welcome to the forums!

If you are importing contacts that are new to your database, you need to make sure that the checkbox for perform auto-entry is selected, and that you have an auto-enter serial ID field in the table.

Then the last part of your script should sort the table by ID (desc), go to last record, and use the SetNextSerialValue to the ID +1. This sets the counter so that any new record will have an ID greater than all existing records.

[comment]

If auto-enter options are allowed to perform during the import, there should be no need to adjust the serial generator afterwards. Whether auto-enter options SHOULD be allowed to perform is another question.