You can use the Jira REST api to get the list of projects.
JIRA_URL/rest/api/latest/project
You will then get a json which you can convert to csv by going to https://json-csv.com/
I hope it helps.
Ravi
the call brings only the latest projects (not all of them) could you point to call that list all projects
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Best answer and no need for expensive plugins. thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How can we get the most visited Project, most active users, etc in JIRA v6.3.11?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The "latest" in the URI path refers to the API version- it does not filter the projects that are returned. See https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/. You could instead use /rest/api/2/project, since "2" is the current version.
If you aren't seeing all projects it might be because the signed in user does not have the right permissions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Ravi Sagar _Sparxsys_ , thanks for that! Worked like a charm!
Just had to then use something like https://data.page/json/csv to convert it to CSV.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Another, simpler way of exporting Jira projects to Excel and creating relevant reports is by using the built-in template and export option of Better Excel Exporter. The options exist for both the Jira Data Center (Server) and Jira Cloud versions.
You can generate an Excel report of Jira projects like this in seconds:
(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm Leo from DEISER (Solution and Makertplace Partner)
Are you using Jira Data Center? If yes, have you tried Projectrak?
https://confluence.deiser.com/projectrak/8.1.1/export-to-excel-110953960.html
With Projectrak you can export to excel your projects, also, you can create some script fields like "Date last updates" or "Number of issues", this is an example for "Number of issues":
package deiser.profields.scripts
import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.jql.builder.JqlQueryBuilder
import com.atlassian.jira.web.bean.PagerFilter
// Components
def searchService = ComponentAccessor.getOSGiComponentInstanceOfType(SearchService.class)
def jiraAuthenticationContext = ComponentAccessor.jiraAuthenticationContext
// Script variables
def loggedInUser = jiraAuthenticationContext.getLoggedInUser()
// Make JQL query
def query = JqlQueryBuilder.newBuilder()
.where()
.project(project.id).and()
.buildQuery()
// Returns the issue count
return searchService.search(loggedInUser, query, PagerFilter.unlimitedFilter).results.size()
I hope it helps you!
Try Projectrak:
https://marketplace.atlassian.com/apps/1210816/projectrak-project-tracking-for-jira?hosting=datacenter&tab=overview
Leo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, @Caitlin Bell
When you have administration access you can export from Jira in optimizer plugin.
at the first, please download optimizer for Jira from Atlassian marketplace then add it to your Jira, so you can get any export you want.
here is 2 link that I know help you:
https://optimizer.forjira.com/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.