I am trying to update values of a single field in a collection by exporting the entire collection to CSV, updating values of a single field, then importing just the ID and relevant field (lets call it Field X) to my collection.
My problem is that when I select the option to "Replace with imported items" as an option when configuring the import of the ID field, ALL other fields and data are deleted! (I guess because I am only importing 2 of the original fields?) . If I select "Do not import items" as an option the Field X data remains unchanged.
So can you advise the correct procedure to import 1 column/field into a collection, to update / overwrite the existing data in that field, whilst leaving all other data untouched?
A possible workaround could be to export the whole collection, change the data in the Field X, then import the entire collection again to overwrite it. However I can't do this as the other fields are user generated, so in the time I export, amend and re-import some user data may have changed and so I would be overwriting these changes with old data.
Another method may be to import the amended Field X data into its own collection and link it to the original collection somehow. But I dont know how to achieve this (and it is a more complicated version of the first and preferred option).
Note I am testing this in Sandbox to prevent overwriting live data.
Any assistance would be appreciated.