AnsweredAssumed Answered

Report of losing parts or all of records when importing new or updating matching records

Question asked by TimmyLew on Aug 6, 2013
Latest reply on Aug 7, 2013 by philmodjunk


Report of losing parts or all of records when importing new or updating matching records


FileMaker Pro



Operating system version

Mac OSX 10.6.8

Description of the issue

Hi, my name is Timmy from IT for Sweetwater County School District #1 in Wyoming.  We use aFileMakerPro 11 database as a means of keeping inventory for all technology items (19000+) in our district.  When adding new equipment to our inventory database, we use the import feature to save extensive amount of time.

Unfortunately, it appears that records entered into the database by another administrator are believed to be lost and/or deleted.  A possible explanation for these lost records would be a bug in the FMP system activated whenever an import occurs.  To clarify, the records that are reported as lost are not the records that we are adding or updating through the import.  We wanted to check and see if this is a valid explanation for the missing records.

Does anybody else have a similar issue, or is there a known bug that could cause this type of error when importing??

Any help you can provide is much appreciated!!

Steps to reproduce the problem

This is a fairly new issue that has been brought to our attention.  As of now, the only steps taken have been to no longer use the import feature, and entered/update records 1 by 1.

Expected result

Being able to import without compromising data already in the database.

Actual result

It is possible that importing has cost records already in the database to be lost.

Exact text of any error message(s) that appear

No error messages occur.

Configuration information

No additional configuration information to add.


Only workaround is to enter data 1 by 1.  Not an ideal situation at all!