AnsweredAssumed Answered

Prevent Overwriting Records on Import

Question asked by KristopherKruger on Jan 23, 2015
Latest reply on Jan 24, 2015 by KristopherKruger

Title

Prevent Overwriting Records on Import

Post

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.

 

Outcomes