Sorry- forgot to include the platform info
FMPro 7 Win XP and FMPro 10 Advanced Mac both exhibit this same behavior on .fp7 database.
Sounds like something that would make a nice new feature request.
Two possibilities come to mind and neither are simple or fast.
- Import your data into a table where all your fields are defined as text with no validation rules, then compare this import to your earlier import to try and figure out which records were excluded. THen examine those records to see what might have caused the problem.
- Examine your validation rules on your fields and disable the validation for half your fields and try another import. If the import is successful, look at the fields where you disabled the validation. If the records were still excluded, look at the half where you did not disable the validation. If you have a lot of validated fields, repeat this "divide in half" strategy a few more times to narrow down possibilities to just one or a few fields.