Prevent Overwriting Records on Import
I'm sure this question has been asked before, but I wasn't able to find an answer.
I have an ODBC connection to a website's mySQL db. It imports records submitted by a webpage form.
I have a script that successfully imports those records. My problem is that when our "back-office" edits the records that have been submitted, the records are overwritten on the next import - reverting them back to the original info.
How can I prevent records from being overwritten if they already exists in the database?
These are the settings for importing.
ID = ID
Info 1 > Info 1
Info 2 > Info 2
etc...for about 30 fields.
Under Import Action
Checked : "update matching records in found set
Checked: "add remaining records as as new records"
I've tried setting the ID field in the table to "unique" value, but that only creates duplicates upon importing.
I've heard of proxy fields, but i have over 30 fields - that seems pretty complex.