Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to - export a list of jira service desk users into excel?

Maria Burrows
Contributor
November 5, 2018 edited

Jira SD v 3.3.0,   Jira Server Version 7.3.0

Please advise if there is a method to get an excel spreadsheet of all users setup in the system.?  

 

thanks,

Maria

2 answers

1 vote
Angélica Luz
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 6, 2018

Hi Maria,

On Site administration > Users there is an option to Export users where it generates a CSV file that you can open on Excel.
For customers, you can also download on Site administration > Jira Service Desk > Portal only customers > Export users.

Regards,
Angélica

David Eedle December 25, 2018

This does not work. I go to: https://XXXXX.atlassian.net/admin/jira-service-desk/portal-only-customers

I click Export Users

The spinner shows for a while and the button disables

The spinner stops, the button enables

There is no file created or offered for download.

Like • Colin McDermott_GLiNTECH likes this
Angélica Luz
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 31, 2018

Hi David,

I've tested here using Google Chrome and it downloads automatically when clicking on "Export users".
Can you please let us know what browser are you using? Can you test using another one?
This will help us better understand what is happening and try to replicate this issue to check if it's a bug.

Regards,
Angélica

David Eedle January 1, 2019

Hi Angelica

I was on Firefox Mac 64 and definitely does not work. If I check the console I can see the call to https://edsmart.atlassian.net/rest/servicedesk/customer-management/noeyeball/1/local-servicedesk-user?start-index=0&max-results=20000 and it's returning data, but the file is not produced. There's no obvious error message in the Console.

On Chrome Mac 71.0.3578.98 the file DOES download as you note.

So maybe something going on with FF?

 

David

Maria Burrows
Contributor
January 1, 2019

Thanks Angélica  for your response, and apologies for such long delay in replying.

 

Wondering if there is a method for displaying - producing excel (csv) of users on Jira server version.  

Site admin function is available only in cloud version.

 

thanks

Maria

Angélica Luz
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 3, 2019

Hi @Maria Burrows,

You can export users directly from the database.
Please check the steps on the documentation below:
- How to export users to CSV from a JIRA application

Regards,
Angélica

Angélica Luz
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 3, 2019

Hi @David Eedle,

Thank you for helping us with this test.
This issue that we are facing was reported as a bug and it's only related to Firefox because Firefox is able to read this file, that's why it does not download the CSV.
- https://jira.atlassian.com/browse/JSDCLOUD-6458
Please, click on vote and watch to receive updates about the bug.

Regards,
Angélica

0 votes
Lasse Langhorn
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 11, 2019

You can use the Jira User Export app for Jira Server. It is free to download and use: https://marketplace.atlassian.com/apps/1220535/jira-user-export?hosting=server&tab=overview

Suggest an answer

Log in or Sign up to answer