How Do I Remove a Work Item Link via CSV Import?
I have used CSV imports in the past to successfully create links between work items (whether new or existing). I now have a user who would like to perform a CSV import to remove a link from existing work items (actually they want to change all of the "Blocks" links to "Depends On" links).
When I tried to do this for them, I was able to add the desired link, but was unable to remove the previous one. So exporting a query for the existing work items and their relationship to one another, it looks like this:
"Id","Depends On","Blocks"
"104478","#154409",""
"154409","","#104478"
We tried changing this to look like this:
"Id","Depends On","Blocks"
"104478","","#154409"
"154409","#104478",""
After this import, both work items block each other AND depend on each other. So the desired link was added, but the other link was not removed. Is this not possible via CSV import?
Accepted answer
Comments
how do you replace with NO info? or does it delete everything, and then just add the ones found in the import (no).
This deserves a "duh" directed toward me. I feel like I knew about this checkbox, but for some reason forgot about it when it came up in this case. That was the problem. I checked the box and the CSV worked as desired. Thanks for jogging my memory.
ok, well, I am wrong.. scary that it deletes all links before adding
One other answer