CSV Import - Skip Columns on Update Duplicates
3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: September 11, 2019 (RSS)
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,
Technical Lead
interactivetools.com
By Ryan - September 11, 2019
Hi Daniel, we receive the data combined and it's uploaded via a RPA Bot process. We might be able to split the CSV data and carryout 2 uploads though. I'll try that approach.
Thanks,
Ryan