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.
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!
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.