How / why has my download csv had Assignee & Reporter ID added as a new column?

[Karyn Tooke]

The export csv option within Jira filters appears to have the Assignee & Reporter IDs added yet it's not presented as an option in the column options to select? This has occurred within the last 2/3 weeks & I haven't seen anything in release notes.

[Daniel Eads · Accepted solution]

Hi @Karyn Tooke ,

This change took place on October 19. User fields (reporter, assignee, creator, watchers) are now split into actual name and ID fields in the CSV export. Each of those columns selected for export will result in two separate columns (the actual "name", and the ID) in the CSV. Details of the change are readable in this Developer Community post if you're interested in the particulars.

Cheers,
Daniel | Atlassian Support

[Karyn Tooke]

Hi @Daniel Eads - Thanks for this, if the CSV Headers are split into two surely those headers should be selectable in the column options?

Due to limitations with reporting features (see my comment on this article) we already have to export our data into excel/google sheets to produce charts/graphs so having to manually remove two fields (assignee ID & reporter ID) prior to the import is another manual step I'd like to avoid. Thoughts?

[Daniel Eads]

For Google Sheets, you could consider a script function to do any cleanup work after import. This script will trim any columns not in the array (line 2) of desired columns. If you're doing any other work after import, you could also add that to the script function and reduce all the "cleanup" down to one click to start the function.

[Vero Rivas]

What version of Jira are you using? In version 8.5.1 I just exported a csv and it doesn't happen to me

[Karyn Tooke]

@Vero Rivas - We're on Jira cloud :)

[Vero Rivas]

@Karyn Tooke 

You are absolutely right, I have done the test in my cloud version and the fields appear in the CSV export

Sorry for the confusion

[John Funk]

Hi Karyn - I have noticed this, too. I will see if I can get someone from Atlassian to comment. 

[Karyn Tooke]

Thanks @John Funk !!

[John Funk]

A quick response from a fellow Community Leader (not Atlassian) was the reminder that it used to ONLY download the ID and not the name, But now the name is getting downloaded as well. So there's that.  :-)

Still digging for something though.