CSV import of related links, parent, children ...
I'm running RTC 2.0.0.2 iFix 6 and I cannot figure out how to import a work item with related links and parent (by storing the content in the CSV file).
Is there a way to import from a CSV file that can build a work item structure and set related link content? Also, is there a way to export the related links and parent/child ID to CSV or HTML? I don't see it in the column list. |
14 answers
You need to use RTC 3 for that. Links in CSV are not supported in RTC 2.
On 26.04.2011 12:23, mjforte wrote: I'm running RTC 2.0.0.2 iFix 6 and I cannot figure out how to import a |
That's unfortunate...
I've got another question. When importing from a CSV file, you can choose the custom mapping option but the syntax of that XML seams to not be documented anywhere I can find (at least not fully). Problem is, I have a CSV file with stories and tasks. The stories have a custom attribute "Story Points." This is a numeric value in the CSV file for each story and blank for the task type. When I import, the tasks are given a "Story Points" attribute and value of 0. Normally the tasks do NOT have a story point value. Is there any way to create the custom mapping to instruct the import to ignore the "Story Points" attribute for task type work items? Sample from the XML mapping file: <attribute sourceId="Story Points" targetId="com.ibm.team.apt.attribute.complexity"> |
There is not, I suggest to have 2 CSV files to import from, one with
defects and the other with stories. On 05.05.2011 11:08, mjforte wrote: That's unfortunate... |
https://jazz.net/library/article/69
On 05.05.2011 11:08, mjforte wrote: That's unfortunate... |
There is not, I suggest to have 2 CSV files to import from, one with That's what I ended up doing. Made some other observations too...posted on a different forum... (RTC 2.0.0.2 iFix 6) A couple of weeks ago I completed creating over 1500 work items for an upcoming release using a set of CSV files. Doing this took about 1 day. However, I will note that the majority of my work items to create were similar which made creating the CSV input predominately a copy and paste effort with minimal changes per set of work items. I created epics, stories, and tasks. |
https://jazz.net/library/article/69 Reviewed that article prior to starting this thread. Really, the help available on jazz.net for importing work items and the help for using the custom mapping file are not well developed. |
You need to use RTC 3 for that. Links in CSV are not supported in RTC 2. Is there anything that describes how to do this in RTC 3 as you alluded it was possible. |
What I ended up doing to find out the format the CSV file had to be in was to do an export of some work items to a csv file and chose additional attributes to export which were links. Like "Depends On", Duplicate Of" and "Duplicated By". Then examined the resulting CSV file.
Do this from the Work Items perspective File->Export->Work Items option. |
The shared library link says that we can not import attachments using CSV import. Do we have any work around for this?
P.S: We are migrating data from a legacy system to RTC and many workitems in legacy system have attachments with them. |
Attachments can only be imported from bugzilla.
On 02.08.2011 12:53, achal wrote: The shared library link says that we can not import attachments using |
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.