Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Workitem Creation with Parent ID using CSV Import is not working.

Questions
Tags
Users
Badges
Muthukumar C
(327●1●28●33) Feb 19 '13, 12:34 a.m.
 hi,

I am trying to CREATE work items using CSV File import. I have a precondition that this type of work items must have Parent work item during the creation. Hence I need to create Task work items along with the Parent ID.

I have read some questions in this forum and came to know that this is possible After 3X RTC. I am using 4.0.0.1 RTC Client and when I am trying to upload the file with "Parent" column, same is throwing error from the Plugin Precondition. If I remove the Preconditions, then work item is getting created without Parent link. 

It will be helpfuk If I can get any sample file for creating work items with Parent Link.

Regards
Muthukumar.C

0 votes

Comments
Muthukumar C
Feb 19 '13, 1:31 a.m.
Moreover, I am unaware about How to upload the Values for WORKITEM type fields. When exporting, Its exporting the value in the format ID : Summary. But the same is not accepting when import. 

1 answer
6,760 views
0 votes

One answer

Permanent link
Nate Decker
(378●1●47●61) Jul 24 '13, 8:32 a.m.

I wrote a script that did this successfully. The CSV looked like this:

Attribute1,Attribute2,etc...,"Parent",AttributeX,AttributeY,etc...
Value1,Value2,etc...,"#ParentID",ValueX,ValueY,etc...

This worked initially. However, a short time later the same script began failing. The import would quickly create the work items and then it would sort of pause for a long time on the "resolving links" phase of the import process. Eventually, it would present an error message. This caused confusion for some of the users because they thought the entire import had failed and they would attempt it again. This resulted in duplicate work items being created (and none of them being correctly linked).

The only time I've gotten this to work is when I put Parent in quotes and the #ID in quotes as well. However, I don't think that should be required. I suspect there may be an RTC bug that is causing this import process to fail. I am on Jazz.net this morning to investigate whether just such a bug has been created.

Note that we are using RTC 4.0.1 (eClipse client)

0 votes

Comments
Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 24 '13, 1:47 p.m.
Are you importing into one of the pre-defined process templates, or using one you've customized?  If you are using a customized process, a useful debug step is to try importing the CSV file into a project area with one of the pre-defined process templates.  And then either way, I'd suggest creating creating a defect work item in jazz.net (or working with support to create one for you).  It sounds like you are doing the right thing, but are encountering some kind of bug.  If you are using a pre-defined process template, just attach the CSV file to the work item, and indicate which process template you used.  If you only get the error in a customized process, you'll need to also attach the process template to the work item. 

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Feb 19 '13, 12:34 a.m.

Question was seen: 6,760 times

Last updated: Jul 24 '13, 1:47 p.m.

Confirmation Cancel Confirm