how do i remove a tag in csv file import to rtc
When using a csv file import to RTC, how do I format a tag field to remove a tag already on the work item? |
One answer
Have you tried specifying blank values in the "Tags" column of your CSV. Comments
Michelle Rivera
commented Mar 08 '17, 5:04 p.m.
Maureen,
I tried a simple Export of work items (used RTC Eclipse) - of the Id and Tags. I then removed the 'unwanted' Tag from the CSV file, re-Imported and it seemed to work. I imagine you'd need to do a find/replace of the unwanted tag in your CSV - if you're dealing with many records/work items.
Exported
"Id","Tags"
"100","keepthis, removethis"
Imported
"Id","Tags"
"100","keepthis"
The problem here is assumptions. I created my own importer and for attributes with multiple values such as tags you have to make assumptions a bout how this is supposed to work. There are several potential conflicting requirements such as
1. In the import I want to remove all tags and only set the tags from the import data
2. In the import I want to add tags that are in the import data
Looking at Michelles test the approach taken was 1. Which means if only one tag should be removed you have to find all tags first, remove the one you don't want and import the rest.
I am not aware of an option to switch behavior between 1 and 2 in the RTC importer.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Yes and then all tags were removed. I would like to be able to remove one tag and leave the rest.
I also found that if I add a new tag that also replaces all the tags previously added with just the new value.
Michelle, thanks for the suggestion.