AnsweredAssumed Answered

Importing Data and Inactive Records

Question asked by kwinder on Dec 13, 2013
Latest reply on Dec 17, 2013 by kwinder

I am new to FM Pro so be patient...I am importing a monthly complete list of contacts in a csv file that can have new contacts and/or be missing contacts from the previous import. I don't want to delete any records from my FM database but would like to mark the existing records as inactive if they don't exist in the lastest import. Right now I am importing into a ContactImport table seperate from my normal Contacts Table as the data needs minor cleanup prior to moving into a couple of different tables. I am assuming this could be done in a script but not sure how this works given its an import, and also should I be importing into a ContactImport Table or into my main Contacts Table initially on import?

Outcomes