Issues when importing work items from CSV
When importing workitems from CSV we've hit an issue.
The issues are related to the Filed Against and Planned For fields. Here is an example of the csv file:
Id Type Summary Owned By Filed Against Priority Planned For
1 Task Task 1 Member 1 Category 1 Medium Release 1
2 Task Task 2 Member 2 Category 2 Medium Release 2
3 Task Task 3 Member 3 Category 3 Medium Release 3
Even if the Category (Filed Against) and the Iteration (Planned For) exist in the Categories list and Timelines respectively (Project Area configuration), when importing the file it creates new (duplicate) category and iteration instead of mapping to the existing one.
The issues are related to the Filed Against and Planned For fields. Here is an example of the csv file:
Id Type Summary Owned By Filed Against Priority Planned For
1 Task Task 1 Member 1 Category 1 Medium Release 1
2 Task Task 2 Member 2 Category 2 Medium Release 2
3 Task Task 3 Member 3 Category 3 Medium Release 3
Even if the Category (Filed Against) and the Iteration (Planned For) exist in the Categories list and Timelines respectively (Project Area configuration), when importing the file it creates new (duplicate) category and iteration instead of mapping to the existing one.
One answer
Hi Paul,
for the iteration there was an issue in RTC 3.x. This was, as far as I remember, related to the fact that an iteration can have a name and an ID. The mapping algorithm only checked for one match. I had the impression that there was puta lot of work in improving matters for 4.0. See: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=189433&tab=com.ibm.team.workitem.tab.links
Which version are you looking at?
There are also several questions in the forum with similar questions. You might want to browse through them https://jazz.net/search_results.jsp?q=csv+import+iteration#page=0&type=&q=csv%2Bimport%2Biteration
One mentions: Make sure to use the fully qualified name of the iteration as described
at http://jazz.net/library/techtip/69 and things should work fine.
for the iteration there was an issue in RTC 3.x. This was, as far as I remember, related to the fact that an iteration can have a name and an ID. The mapping algorithm only checked for one match. I had the impression that there was puta lot of work in improving matters for 4.0. See: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=189433&tab=com.ibm.team.workitem.tab.links
Which version are you looking at?
There are also several questions in the forum with similar questions. You might want to browse through them https://jazz.net/search_results.jsp?q=csv+import+iteration#page=0&type=&q=csv%2Bimport%2Biteration
One mentions: Make sure to use the fully qualified name of the iteration as described
at http://jazz.net/library/techtip/69 and things should work fine.