Is it possible to export a list of all projects with their category?

Is it possible to export a list of all projects with their category?

4 answers

1 accepted

This widget could not be displayed.

No direct way, you can do it if you are comfortable with jquery to run a short script in your browser console to extract it.

Will try to get you one script if time permits.

Try this in the javascript console:

AJS.$('.inall').each(function(i){

var category = AJS.$(this).find('h3').text();

AJS.$(this).find('div div table tbody tr').each(function(i) {

console.log(category + ',' +
	AJS.$(this).children('td:nth-child(1)').text().trim() + ',' +
	AJS.$(this).children('td:nth-child(2)').text().trim() + ',' +
	AJS.$(this).children('td:nth-child(3)').text().trim() );

});


});

Copy paste the output in the console (comma separated to an Excel)

This widget could not be displayed.

The quickest way I know is using the Jira API:

Log in to Jira and open a new browser tab.

Go to https://[yourdomain].atlassian.net/rest/api/2/project

That gives you a json object with all your projects.

Then use a json to csv converter like https://json-csv.com/ and a few seconds later you have a file you can open in Excel.

There's a lot more you can do with the API; it's also an easy way to export users and groups.

This widget could not be displayed.
Paul Greig Atlassian Team Feb 04, 2013

Hi Furore,

Yes you can, the 'Search for Issues' screen allows you to create your custom filters and then export to multiple formats using the 'Views' option. The following guide outlines this process: https://confluence.atlassian.com/display/AOD/Exporting+Search+Results+to+Microsoft+Excel

Cheers,

Paul

Thanks Paul, but We already export all Issues from Jira, with all Excel fields.

No one field has the Category.

Any other idea?

Thanks!

That would only export a project's issues – The problem trying to be solved is how to export a list of projects.

This widget could not be displayed.

Here is a low tech version of how I did it:

  1. Click Projects>View all Projects
  2. Select the whole table with the mouse, including the Title Row
  3. Copy
  4. Open Excel
  5. New Blank Worksheet
  6. Past (Match Destination Formating)
  7. Delete Rows where Name=="Blank"
  8. Save in format you need ;-)

Hope this helps

The All Project page shows only 25 projects on a single page, and you have change page to the next 25 projects. Which makes this process very cumbersome.

On other hands, Instead of all projects in "Projects" tab


Goto Jira Admin section(cog icon) on right top corner --> choose "Projects"

It will list all available Jira projects in the current instance.

Hope this will help you guys...

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

580 views 25 15
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you