Import CSV File Creating Duplicates

  • Hi Team, awesome plugin. However, when using Duplicate Record Check Field set to Record ID (id), and Duplicate Record Preference (Update matching record with new data), which should result in OVERWRITE, the net result is a complete duplicated set of data.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Did you check the CSV to make sure the “id” field is present in the data? If that is missing, the plugin will create a duplicate record with the settings you are using.

    Thread Starter Ockert Cameron

    (@ockertc)

    Hi @xnau – indeed!

    Example below.

    id	province	town	suburb	postalcode	zone	monday	tuesday	wednesday	thursday	friday
GP00001	Gauteng	PRETORIA	BEREA PARK	2	North	Rotate Bi-Weekly	Yes	No	Yes	No
GP00002	Gauteng	PRETORIA	CENTRAL	2	North	Rotate Bi-Weekly	Yes	No	Yes	No
GP00003	Gauteng	PRETORIA	CLYDESDALE	2	North	Rotate Bi-Weekly	Yes	No	Yes	No
GP00004	Gauteng	PRETORIA	DEFENCE FORCE AREA	2	North	Rotate Bi-Weekly	Yes	No	Yes	No
    Plugin Author xnau webdesign

    (@xnau)

    Those are not valid values for the plugin’s “id” column, which can be integers only.

    If you want to maintain your own custom ids for your records, you must add that as a new column.

    Also, be sure your CSV header line corresponds to the “name” of your fields, not the field titles.

    Thread Starter Ockert Cameron

    (@ockertc)

    Thank you, and my sincerest apologies, should have done a little more reading.

    Kindly yours.
    Ockert.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import CSV File Creating Duplicates’ is closed to new replies.