how to preserve workitem external id when importing from CSV?
It was discussed in https://jazz.net/forum/questions/128225/how-to-upgrade-existing-workitems-from-csv-file but I have decided to create new one.
I have RTC 4.0.3.
1. I have following CSV file:
"Type";"Id";"Status";"Priority";"Severity";"Summary";"Owned By";"Created By"
"Task";"1000000";"New";"Unassigned";"Normal";"Define permissions";"admin";"admin"
Id - is identifier from external system
I use import from CSV option. After import there is created new work item number 98 (I leave Id value as 1000000)
2. I modify only summary field in CSV file
3. Use import from CSV option to import work item. Select "Update Matched Work items" option.
What is => New work item number 99 is created
What I would like to have => summary of work item number 98 is modified.
How can I acheive that? How should I modify my CSV file/importing options to achieve what I want to?
I have RTC 4.0.3.
1. I have following CSV file:
"Type";"Id";"Status";"Priority";"Severity";"Summary";"Owned By";"Created By"
"Task";"1000000";"New";"Unassigned";"Normal";"Define permissions";"admin";"admin"
Id - is identifier from external system
I use import from CSV option. After import there is created new work item number 98 (I leave Id value as 1000000)
2. I modify only summary field in CSV file
3. Use import from CSV option to import work item. Select "Update Matched Work items" option.
What is => New work item number 99 is created
What I would like to have => summary of work item number 98 is modified.
How can I acheive that? How should I modify my CSV file/importing options to achieve what I want to?
One answer
Hello Krzysztof,
have you tried in step "2" modifying the "Id" field as well? In your example to make it match the 98 of the previously created item. That would be the way to uniquely identify the work item you are willing to update.
Regards,
Jorge.
have you tried in step "2" modifying the "Id" field as well? In your example to make it match the 98 of the previously created item. That would be the way to uniquely identify the work item you are willing to update.
Regards,
Jorge.
Comments
Joerg Ihle
Mar 04 '14, 11:52 a.m.sam detweiler
Mar 04 '14, 11:44 a.m.