2. PHPRunner General questions
  3. Importing Duplicate Records
This topic is locked

Importing Duplicate Records

 		1/5/2009 9:21:20 PM
PHPRunner General questions
L
 livenletlove08 author

We wish to import multiple records to the database a few times a month (.xls format) - sometimes the records will be duplicates of the existing record(s). Can we set up to "warn" us of duplicates and allow field by field (or selected fields) to be replaced instead of replacing the entire record?
J
 		Jane 1/6/2009

Hi,
unfortunately PHPRunner do not allow do check each field in the imported record.

If record exists in the database PHPRunner replaces it with new record.
You can edit import process in the generated ..._import.phpfile manually. But this task requires a lot of custom coding.
R
 		ringah 1/6/2009

We wish to import multiple records to the database a few times a month (.xls format) - sometimes the records will be duplicates of the existing record(s). Can we set up to "warn" us of duplicates and allow field by field (or selected fields) to be replaced instead of replacing the entire record?



Might be easier to do it in XL first...something like this..XL duplicates