How do i perform a mass import of User Stories in RTC?
A S (58●5●32)
| asked Aug 24 '17, 4:11 p.m.
retagged Sep 01 '17, 11:49 a.m. by Ken Tessier (841●1●7) I need to import User stories with limited fields into an existing Stories area for the project. the file has 4 fields while the Story schema for the project has many times more.. Can I link the Requirements field to the imported with the record to the one in DOORs? |
3 answers
Ralph Schoon (63.5k●3●36●46)
| answered Aug 25 '17, 6:47 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Aug 25 '17, 6:47 a.m. The only ways I am aware of that allow importing work items are
CSV import is built in like Bugzilla, but there are limitations what can be done especially when recreating work item links or links to other items. The unsupported Work Item Command Line is an alternative for the built in import, where you can create your own logic. If can create links to other items in some cases. |
basically you have to ensure that you map the column headings of your spreadsheet to the field names in the user story work item in the system. You MUST include the Type field which is the work item you are importing into. You must also ensure that any fields that you're importing that are "enumerated" that the values match exactly e.g. High versus high will not setup correctly. Additionally if there is any operational behaviour on your work item e.g. mandatory fields required on creation, they must also be populated in your spreadsheet otherwise they will not load.
Comments
A S
commented Sep 01 '17, 9:59 a.m.
I decided to do it manually because there were too many inconsistencies between the fields they wanted me to import versus the ones already existing in the Story 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
It appears that you're talking about something very specific to your environment. Others may not understand what you're trying to do if you don't provide more details.