Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

export all issues and all related fields for each issue type from Jira Server to Excel

Our management is asking for exporting of all 100,000+ issues with all related fields including comments or activities associated to each issue type (100+) from all projects into an excel/csv/html spreadsheet. Is there is a feasible way through native Jira, Sql query/view or addon that would help to accomplish the exporting of this data?

1 answer

0 votes

Hi,

The first question is why do they need to export all theses issues ? 

You could use REST API and play with the startat maxresults parameter to achieve this.

https://confluence.atlassian.com/jirakb/filter-export-only-contains-1000-issues-in-jira-server-191500982.html

https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/#searching-for-issues-examples

 

Hope this helps

Hi @Mohamed Benziane

Well it is still a million dollar question on why do they need ALL issues w/ fields :(

Meanwhile, I tried exporting first 1000 issues w/ ALL fields by adding &tempMax=1000 to the URL and the data view looks so odd, as it added 1024 columns in the export file for each issue, lol,lol...

I will run this by our management to find out if it makes any sense and keep you posted.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you