Jump to content

Import Errors,... PLEASE HELP!!!


Golden Mean
 Share

This topic is 5778 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5778 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.