Import Errors,... PLEASE HELP!!!

[Golden Mean]

I've got a problem. I just performed an update for a client and out of 947 customer records, 37 will not import because of errors.

Additionally, Filemaker will not generate an import log file so I can't find out what the problem is (the one time I need it to )

Here's what I've tried so far:

I've tried recovering both files.

I've tried FileMaker Pro 8 Advanced and 8.5 Advanced.

I've restarted everything.

I've tried exporte to and importing from .tab , .xml, etc. and get the same errors.

I've reviewed the data to look for commonalities and found nothing obvious.

Does anyone know how to get FileMaker Pro to generate import logs?

Before I ran into errors Filemaker would spit out an import log in the folder I was working and now that there's errors, it doesn't.

Any help would be greatly appreciated.

Thank you for your consideration.

[Oldfogey]

How do you know it's "because of errors" if you don't have a log?

Have you tried exporting directly to Excel? There's a slim chance Excel will get upset about some of your data. (I'm assuming it is data-related.)

Have you tried to import the data into an empty copy of your old file?

I've done a lot of importing/exporting and never had a problem of some records not being imported. (Had every other problem!)

[Golden Mean]

I finally figured it out...

The new version had a field that had validation setup for "always" with no override. Those 37 records were missing this critical data and would not import. As soon as I put data in those fields, importing worked fine.

I'm a bit embarrased that it took me 4 hours to figure it out when that should have been one of the first things to look at. However, I rarely set up validations that way and this was at the clients request in the middle of the development cycle.

Live and learn ;)

[Oldfogey]

All's well that ends well.

I don't think 4 hours looking for the bleedng obvious is any major record. :

[Lee Smith]

All's well that ends well.

I don't think 4 hours looking for the bleedng obvious is any major record. :

ROTFLMAO

Lee