Every day we export data in .csv format from a Filemaker file hosted on Server 5.5 via Client 6.1. The export includes all records in the table, about 120,000 records.

From time to time we get additional rows inserted into the csv file for which no record exists and that contain no data. They are correctly formatted, containing the correct number of fields, all of which are empty.

And we have noticed that these only appear in locations where records have been deleted. All our records are given a serial number when they are created, and the empty rows are inserted between serial numbers where we can deduce there have been deletions.

So it is almost as if, when exporting, Filemaker sometimes forgets it has deleted a record.

Has anybody else seen this? Is it a a known bug? Is there a fix or workaround?

And just for the record, we only have to do this because Filemaker's ODBC connectivity with SQL Server 7 is so lousy...

I've never had this happen except when the file was corrupted. You may need to recover your database.

I would also try using a tab delimited file rather than csv if possible. I've seen way too many things go wrong with comma delimited, because the data often contains embedded commas )which shouldn't cause problems, but sometimes do).