It's all about the answers!

Ask a question

Issues when importing work items from CSV


Paul Tasillo (10665) | asked Nov 08 '12, 1:10 p.m.
JAZZ DEVELOPER
retagged Nov 08 '12, 8:01 p.m. by Millard Ellingsworth (2.5k12431)
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



permanent link
Ralph Schoon (59.0k23642) | 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


Register or to post your answer.