CSV Import - Skip Columns on Update Duplicates

By Ryan - September 9, 2019 - edited: September 9, 2019

Hi, is there a way to skip certain columns / fields  (i.e. createdDate, updatedDate, status) when updating duplicate records using the CSV import plugin? 

I'm thinking that i might be able to unset some of the field mappings if it's a duplicate record, but i'm not having much joy figuring it out.  

By daniel - September 11, 2019

Hi Ryandoc,

The CSV Import plugin allows you to skip columns entirely, but I don't think it's readily possible to change these between updated/inserted records in the same import job. Likely the easiest way to achieve this would be to manually process the CSV file first and split it into two files - one of the duplicate records, and one of the new. This would give you better granularity for which columns to skip in the column mapping options. We can also keep this feature in mind for future iterations of the plugin.

Let me know if you have any questions!

Thanks,

Daniel
Technical Lead
interactivetools.com