Export user list file

[Sue Lund]

Starting very recently (I think within the last 2 weeks), the user export has changed, for me, in Jira.  Or, I have forgotten how to do it.

 I export the list of active users and include their groups:

 

The exported list used to show the users as many times as the groups they were members of (very nice to sort by group) and now it shows the user one time, and the last column shows all the groups they belong to (comma separated).

 

 Am I doing something wrong?  I really can't work with it like this.

[Sue Lund · Accepted solution]

Atlassian has changed it back to the way it was.

[Daniel Ebers]

Hi @Sue Lund

testing on my instance I can see the new behaviour you described.
This could mean it will be the standard and your instance probably was reverted as a exception - maybe it would be needed to prepare steps to work with the new format.

Assuming the new format will be rolled out at large that could mean it includes your instance again.

Regards,
Daniel

[Sue Lund]

Well, that's unfortunate.  I suppose you'll have to enter your own support ticket to have it done for your instance, too.

I really don't understand why this was viewed as an improvement, other than possibly the speed of the download.

[Esther Strom]

@Sue Lund - you're not doing anything wrong; it does appear they've changed how the export files are formatted. I'm unable to find any documentation regarding this change, but confirmed it in my own instance. 

For my own use, I posted a question on SuperUser to see if there's an easy Excel formula that would reformat the file to the way it used to be. Hopefully someone will have an answer.

[Sue Lund]

I hope they change it back.  This makes it almost impossible for me to maintain our Support groups.

[Sue Lund]

I've also entered this as a bug, to try and get Atlassian to look at it.  https://getsupport.atlassian.com/servicedesk/customer/portal/23/JST-689228

[Bill Sheboy]

Hi Sue and Esther,

There is probably no easy Excel formula to solve this.  The built-in text-to-columns and split-cell features would work for one cell...not for a row which has multiple columns and one column with the values list.

You could either create a macro in VBA in Excel to do it, or parse the CSV outside of Excel.  For example, pull the CSV into a database and script it back into many rows to de-normalize.

Best regards,
Bill

[Esther Strom]

I figured there's probably no easy way, but I'm not a regular Excel user, aside from viewing files, so I figured I'd put it out there in a community where there are a lot of Excel experts. 

[Sue Lund]

@Esther Strom @Bill Sheboy 
Atlassian changed it back to the way it was.  Just in time for me to do a monthly group audit :)