Failure in mass-data-update using the migration tool
I am using the migration tool provided my Zoho Creator to do mass data updates, so I don't need to write functions to do it. But during the update process I got "data already exists" errors... of course "data already exists" because I am using the ID as the unique identifier to update existing records with data from my spreadsheet... any clue?
| ID |
field1 |
status |
seriqla |
| 21677000010333591 |
dupe_48f86a66-e8e2-41d7-86a8-5263a83bd10b |
120 |
100001 |
| 21677000010333595 |
dupe_48f86a66-e8e2-41d7-86a8-5263a83bd10b |
120 |
100002 |
| 21677000013045011 |
dupe_48f86a66-e8e2-41d7-86a8-5263a83bd10b |
120 |
100003 |