AnsweredAssumed Answered

SERIOUS ERROR when importing updating matching records in found set,

Question asked by ericaconway on Apr 15, 2009
Latest reply on Apr 15, 2009 by ericaconway

Summary

SERIOUS ERROR when importing updating matching records in found set,

Description of the issue

Today I attempted to import records from .xls into FMP Server 8.5.  I set it up to update matching records in found set, add remaining data as new records.  I used the email address as my matching field and requested to update 4 other fields.  The result was elimination of many existing records, inconsistent omission of data in selected fields and elimination of data in existing but unselected fields. Example:  In master DB I have a guy named Matt Kunz, email addy: mkunz@gmail.com  In the data I imported, his email address was mkunz@uwm.edu, first name, last name etc.  My expectation was that I'd be able to search for Matt Kunz or any other person, and if a matching email didn't exist, they'd now have two records, the original and the new data associated with the unmatching email address.  INSTEAD, when I search for Matt Kunz all I get is one record with his imported email address and data.  HELP!!  I can send you the screen shot of what my import screen looks like, I did it right and I made copies of the DB and was able to duplicate the error.  

Outcomes