Forums

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

Exporting from Jira - name vs. ID

Trixie Johnson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 6, 2018

When viewing filter results on Issue Search screen, Assigned PO displays as a name (last name, first name).  When this data is exported to a .CSV file, the data is the users ID (not the readable name).  Is there a way to request the name be exported?

3 answers

1 vote
Ken Wells March 7, 2019

This may seem trivial, but my end users find this extremely frustrating, to the point that they'd rather not use Jira because it is so user UNfriendly. As an admin, I don't have any way to get at the Full Name instead of the user ID on their behalf. This seems like a simple thing that Atlassian could do to make the export better. Offer the name or the ID instead of forcing use of the ID.

0 votes
Thomas Deiler
Community Champion
February 6, 2018

Dear @Trixie Johnson,

Gaston is right.

But you have one chance to do a 'post-export-data-manipulation':

With a script sending a 

GET /rest/api/2/user?username=<username>

for each CSV line. You can extract the "displayName" and replace with this the username(id).

So long

Thomas

Trixie Johnson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 6, 2018

Sounds interesting but I would need more instruction.  :(  I get the concept, but not really how to execute.  Since the name I want is displayed on the screen, I was hoping there was just a way to 'tell' the export to pull that display name vs. the persons ID value.  Sounds like its not quite that easy, per se.

Thomas Deiler
Community Champion
February 6, 2018

Dear @Trixie Johnson,

yes, it is not easy. You need some scripting skills ore someone who writes the script for you.

What's your technical background?

So long

Thomas

0 votes
Gaston Valente
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.
February 6, 2018

Trixie,

I think there's no standard way, you need to look for a plugin or a script customer field of some sort.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events