Export Sub-task hierarchy to excell file???

[Deleted user]

Hello,

our customer had asked us how to create an excel file from his JIRA Tasks with the following structure:

Task1

Subtask T1S1

Subtask T1S2

Subtask T1S3

Task2

Subtask T2S1

Subtask T2S2

...

is this possible in JIRA? How can we achieve this?

[Igor Sereda [ALM Works] · Accepted solution]

You can give it a try with our Structure plugin. Take a look at this video (at the end of it), where Excel export is demonstrated: http://youtu.be/pcIW7U8nDGE?hd=1

To solve your problem:

1. Search for "Structure" in Administration | Plugins | Install, or install the plugin from the Plugin Exchange.
2. Open Administration | Structure | License Details tab, get and install a Free 30-day evaluation license.
3. Open Administration | Structure | Configuration and enable Structure for this project. Optionally, limit access to Structure to only those people who'd use it to solve this problem.
4. Exit Administration, open Structure | Manage Structure menu.
5. You'll have a single "Global Structure" there. Local "Sync With" column and press "Settings".
6. Install a Sub-Tasks synchronizer. Select "Sub-Tasks" and go through the installation
7. Open "Structure" top level menu. You'll see an empty Global Structure. Now you need to add "Tasks" there, all sub-tasks will be added automatically.
8. One way to add tasks: Click "Search" button, click (or don't click) JQL to search by text or by JQL. Click "More Issues" in the toolbar. Add with drag-and-drop.
9. Another way to add tasks: Use Issue Navigator to search for them, then click Views | Structure and add like in (8).
10. Another way to add tasks: Open an issue view with the task and in the Structure section, click "Add to Structure".
11. Another way to add tasks: Create a saved filter that shows these tasks, and install a "Saved Filter" synchronizer like you did in (6).
12. Once you have issues in the structure, sub-tasks will be added automatically. Configure which columns you'd like to have in Excel and press the Excel button.

Hope you're not much overwhelmed by this instruction :)

Hope this helps!
Igor

[Jobin Kuruvilla [Adaptavist]]

Looks like you need a report plugin to do this if you want the same format. You might also want to scan the plugin exchange to see if any of the existing plugins can get you something close.