Some records are not importing every field

[JoniS]

I started having this problem yesterday, I've slept on it, and I still can't get it working today. It is driving me crazy!

I have a script to delete all records from a FileMaker table and then re-import all the records from an external datasource (SQL) into that now empty FileMaker table.

It worked like a charm for the first 26 records. Now, when I add a new record into the SQL table and run the FileMaker script to delete/re-import the records into FileMaker, the first 26 records import correctly. The 27th - 30th records import the first few fields correctly, but to my disappointment, the "status" field stays completely blank.

If I open the SQL table to look at the records, the "status" field has a 1 in every record. When I look at the table in FileMaker, the "status" field has a 1 in all but the last 4 records I've added.

If I open up the script and look at my settings for the import, I can click through the records to see exactly what field values are going to be imported for each record from S. The last 4 records have a 1 pointing to the "status" field. It is only when I actually run the script that it doesn't import the 1.

What am I doing wrong?

Am I going crazy?

[Wim Decorte]

If you have FileMaker Pro Advanced I would run the script in the debugger and see if it generates any errors. Also check to see if a file named "import.log" is created, it may contain clues as to what is going wrong.

The problem may not be in the script but in field auto-enter calculations, lookups or validations. Are you importing with the "auto enter" option toggled on? If so, turn it off and import again. If all the fields now have data you know the problem is in the auto-enter part.