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.

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!)

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 ;)

All's well that ends well.

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

All's well that ends well.

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

ROTFLMAO

Lee