about "total xxx records skipped due to errors"

[saralee]

Hi, when I import records from one table to another one, I got a summary dialog with information like "xxx records skipped due to errors" I just wonder what kind of errors would that be?

I'm migrating data about babies and households from an old database to the new design that I'm working on. When I was migrating data from tblBabies to tblHouseholds in order to match babies with households, I got this msg with the number of errors. I think my algorithm works fine for the matching. Basically I'm taking a single copy of the household info from the siblings' records and match that with all the siblings' records.

Maybe anybody can tell me what the general errors would be when you do data importing? Thanks!!

[BrentHedden]

It is quite frustrating that FMP doesn't mention what the error(s) are, leaving you to figure it out. But from experience, here are two of the most likely causes -

Some kind of field validation was not met. Example - a number field is validated to contain a minimum of 4 characters, and in one or more of the records from the data you're importing only contains 2 or 3. Supposing the table is fairly simple, you can (temporarily) shut off any field level validation to see if this corrects it.

If you're performing a match import, one or more of the records are currently being used be another user.

[saralee]

Thank you for the info!

I was doing matching stuff, and one of my fields was set to be unique value and validate always. And if the algorithm works, I'm supposed to get less records after the importing. So the total number of records skipped seems just about right, but I don't expect it is what the message refers as "errors".. Would the normal skipping considered as errors during FM data migration?

Thanks!

[comment]

Yes, validation errors. It's too bad Filemaker doesn't deliver the import log they promise in the help:

http://www.fmforums.com/forum/showtopic.php?tid/209893/