AnsweredAssumed Answered

Checking data when importing

Question asked by on Jun 14, 2013
Latest reply on Jun 18, 2013 by philmodjunk


Checking data when importing


     Hello FM Forum,


     My database has a list of patient records, I get an updated list of patients every month in an excel format from an outside source. I am wondering the best way to import these records in such a way that the data that I have entered will not be changed, but the updated data will be. Is there a way to compare the records as they are importing and have the system ask me which version it ought to import? Also, is there a way to have filemaker let me know when a record has been removed from the excel sheet (patient deceased)?

     Each patient has a unique identifier given by the external source. Any thoughts or suggestions would be very welcome.