Export all epics for a given project with child issues nested beneath each epic

Question

I have Project XYZ, which is composed of Epic A, Epic B, Epic C. Within each epic there are tasks.

I would like to export all epics within the project with each task nested below each epic to a CSV. The ultimate goal is to get a view of the status of the tasks within each epic in spreadsheet form. (I am able to export all epics and stories/tasks, each having a separate line item, but there is nothing connecting a task with a given epic in the spreadsheet and they are not nested.)

Rhys Diab _Rogue Wombat Software_ · Answer

Hi @Danielle Barringer

As mentioned above, you can represent the link to each parent using the Epic Link field in a Company Managed Project or Parent field in a Team Managed Project.

If you also want your issues to be nested in your CSV, we created a plugin called Agile Docs which can do this.

If you're using a Company Managed Project, bring up your project in Agile Docs, set the Epic Link field to display, and click "Export CSV".

This will generate a CSV file which:

- Shows your Tasks directly under each Epic

- Connects your Tasks to Epics via the Epic Link field

- Represent the level depth with the "hierarchyLevel" field so you know what level of hierarchy you're on

It looks like this:

Let me know if this is what you're looking for.

Best Regards,

Rhys

Rahul_RVS · Answer

Hi @Danielle Barringer

f you would be interested in a third party add-on, you can try out Agile Tools. We have csv export option which exports epic hierarchy and progress based on story points and time estimates, as screen shot attached.

Agile Tools - Epic Tree and Time in Status

The add-on allows you to manage and visualize your Epics hierarchy with option to view all your custom fields on a single screen.

Key features of Epic Hierarchy:

* Epic Sum up - Roll up for Time estimates and Story Points
* Excel like editing for key fields
* Excel export of hierarchy data. Progress % on "remaining estimate" or "original estimates"
* Support for custom names for Epic & Story fields
* Epic Tree on Issue Screen
* Custom field roll up

Along with Epic Sum, you also get 2 other important functionalities within the same plugin, Links Hierarchy and Multiple Time in Status reports (to track your issues)

Jack Brickey · Answer

Is this associated with CMP projects? If so you can use the epic link to associate the epic children to the epic. So you may need to use Excel‘s sorting capabilities to build it out the way you want but you should be able to do so.

if this is TMP you can use Parent in a similar manner.