Requirements Traceability Matrix

nisha.yates February 13, 2020

We have just setup a new Jira Next-Gen Project.  The requirements for this project have recorded in a Requirements Traceability Matrix (a fairly large Excel Sheet).  How do I import import this RTM into Jira and ultimately, make this my Backlog?  We have also bought Confluence.

 

2 answers

1 accepted

0 votes
Answer accepted
Tony Pham February 13, 2020

Hi Nisha,

In order for your import to be successful, you need to carefully view the hierarchy of the RTM and make sure to specified the correct issue type in the first column. If there are parents and children involved, then you need to include parent id column in your RTM. The other part would be make sure that all your fields exist in Jira.

Tony Pham

nisha.yates February 14, 2020

Thanks Tony.  Do you know if there is a user guide to help with this step by step?  I seem to get so far but don't get the results I want.  

Thank for your support.

Nisha

Tony Pham February 14, 2020

Nisha,

You  might want to use this link for more details:

https://confluence.atlassian.com/adminjiraserver/importing-data-from-csv-938847533.html

nisha.yates February 20, 2020

Hi Tony,

 

Thank you for your help with this.  I have now managed to get all of my requirements recorded as issue types in Jira! :-)

Thanks again

Nisha

0 votes
Tom Kakanowski May 14, 2020

Nisha, just to add my thoughts, I've been down this road literally several times, and while I have been able to do pretty much as Tony had suggested, the problem encountered is usually that there are not enough levels of hierarchy available to do an exhaustive trace.  I'm struggling with that again now, where I need

Stakeholder->Need (Epic?)->Feature (Issue?)->Requirement (task?)->Code->Test->deploy

I end up sacrificing something inevitably because I can only go three levels of hierarchy deep (its a bug tracking tool after all, and we've just overloaded it to do things like ALM and Requirements management that many people just don't understand deeply enough to see the weaknesses.

So in my model above, I would end up mapping Features to an Epic, Requirements to an Issue (which then naturally ties into linking version control code check-ins), test cases under the Issue, and that's about as close as I can get.  If I bastardize the Feature, I can combine the need there, but its challenging from an architecture and refactoring perspective, as the Need of a stakeholder drove a feature; In a forward trace model, we end up getting myopic about the Feature when we might in fact replace the Feature entirely with a different approach when focusing on the need.  From a reverse trace model, the Stakeholder for a Feature is probably someone like a Product Manager, but in fact the Need likely came from elsewhere before PM encountered it, and having trace back to the sources of the need allows for deeper digging and qualification of the need.  So you *might* be able to get Product Management to manage their own Need trace, perhaps including Need identifiers into the Epic when it is defined, but bottom line, I haven't seen how to do a full trace effectively in JIRA, Tony's approach gets you there but you need to evaluate what compromises you want to make.

Suggest an answer

Log in or Sign up to answer