@Phil Before you boot me, I found this previous post of mine which you answered. Although I am working on a different database, I suspect your answer of last year may be the problem. I am looking now.
PS: Good example of not searching the forum first...
It's possible that such records where skipped because a validation rule specified in field options excluded them.
I just had a .fp7 file give me this result this morning, but I already knew the file was damaged (I was trying to pull the most recent data from that file to the previous night's back up) and a recover of the file fixed the issue for me.
You might, at least as a test, try exporting to a text file and then importing from the text file to see if this makes any difference. (And compare the number of records exported to the number imported in case issues keep some records from exporting to the text file.)
It was a Validation set as "Always" in new programing on old data import. Lesson learned is to set Validation to "On data entry" when converting or updating database records, then return to "Always" after a transfer of old data, if needed.
@Phil your tip of export as text and importing again has been noted.
Hey, no problem and good to here from you again!