...
Updating changes existing records. This page describes in detail how data is handled by updates.
Only fields/columns included in the CSV are affected by an update
Existing record:
...
CSV:
...
Note that it only has two columns.
...
Only the numberOfObjects field has been changed.
Only populated fields/columns in CSV are changed by an update
Existing record:
In the rest of this article, the updated record from the previous example is the existing record for the following example.
...
Also note that this update did NOT add “Architecture and Design” as a second responsibleDepartment value. This leads to the next point…
A field affected by an update is completely updated/replaced by the CSV values
Let’s say in our previous example, we were trying to add “Architecture and Design” as a second responsibleDepartment value, but now it’s the only responsibleDepartment in our record. Here is what we need to import to get what we wanted:
CSV:
...
Updated record:
...
Individual fields in repeating field groups can be updated
CSV:
...
Updated record:
...
Even though the Other number Value and Type are repeatable together as a group, we are able to just update numberType.
...
Then we realize we don’t really know what kind of number “1234” is. We could update ‘lender’ to ‘unknown’ like so:
...
Resulting in:
...
Caution: not including all values when updating a repeatable field can cause data loss/corruption
After some research, we determine ‘1234’ is actually a serial number.
...