AnsweredAssumed Answered

Checking data when importing

Question asked by trent.fowler@hci.utah.edu on Jun 14, 2013
Latest reply on Jun 18, 2013 by philmodjunk

Title

Checking data when importing

Post

     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.

Outcomes