Import not working!!!!

[sean o mac]

Trying to do a really simple import that I have done before, namely importing an older set of contacts into a newer file, this time a modified version of the Task Management template which comes with Filemaker 8. I do the import as always, it says it works fine then nothing... no new records, just the same template with no records at all.

When it displays the import Report at the end of the process it says:

- 830 of 830 records created

- number of records skipped due to errors; 830 (??!!)

- number of fields skipped due to errors; 0

The weirdest thing is that when I look at the Record ID field, it indicates that the next number to be increased by is the combination of all the times I have tried this import. This means that on some level the file THINKS its importing the data even though its not. Very strange.

Any idea what is going on here??? How can I find out about these so called errors? I see no place to find a log of what transpired in these imports that would give me a clue what is going on.

Finally, just in case it was a corrupted file I was importing from, I imported the old contacts file into a similar template built for Filemake Pro 8 (the original was made from a FM5 template or earlier) and that worked just fine. Then I tried importing from THAT file and still the same problem. I honestly can't figure this out. Please offer some ideas if you have any.

thanks

Edited February 2, 2007 by Guest

[bcooney]

This is probably not the case, but could you be working with a zipped database or somehow read-only.

I had a customer that couldn't create new records, and I was stumped. Turned out, he was using the database while it was still in a zipped archive.

[sean o mac]

I finally figured it out. It turns out it had to do with my Validation setting. I had set a validation level as 'must not be empty' for one of the fields and this caused errors to occur in each record so each attempt at an import stopped cold in its tracks.