Workitem Creation with Parent ID using CSV Import is not working.
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
|
One answer
I wrote a script that did this successfully. The CSV looked like this:
Attribute1,Attribute2,etc...,"Parent",AttributeX,AttributeY,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) Comments 
Geoffrey Clemm
commented Jul 24 '13, 1:47 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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
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.
Comments
Moreover, I am unaware about How to upload the Values for WORKITEM type fields.