Issues when importing work items from CSV
Paul Tasillo (106●6●5)
| asked Nov 08 '12, 1:10 p.m.
JAZZ DEVELOPER retagged Nov 08 '12, 8:01 p.m. by Millard Ellingsworth (2.5k●1●24●31)
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. |
One answer
Ralph Schoon (63.3k●3●36●46)
| answered Nov 09 '12, 7:36 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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. |
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.