How to change worklog userID to user initials (or name) in csv export

Tobias Vogt

When exporting a .csv (with all fields) from an advanced search the work log is included, which contains a timestamp, the user who logged the work, and the amount of seconds logged.

My issue is, that some users appear as an id and others appear as initials in the .csv:


I assume the ID is shown, when the user has no initials specified, so how do I add initials to users, so that users appear as initials in the log work fields of future exports?

Andy Heinzer

Hi Tobias,

If I understand the problem here, some values in this export appear to be using the accountID, while others the worklog author appears to be a username of sorts.  From testing this out in my own Jira Cloud site, I have found that many worklog entries are pulling the lower_user_name field from the Jira database for user accounts, outside the expected accountID. 

I'm afraid I don't have a clear means to generate the usernames as you have asked here, but I came across this bug ticket in https://jira.atlassian.com/browse/JRACLOUD-77921

That bug ticket doesn't exactly mirror your problem, but it is related here.  That bug ticket is actually reporting that some of these are usernames appear here when the user is instead expecting the accountid only to appear there.  That's actually the opposite of what I think you want here.

I think that the request in https://jira.atlassian.com/browse/JRACLOUD-77830 is more in line with what you see here, but this too doesn't really provide a solution here.

I believe that some of the values here are accountIDs and other usernames because of the time in which these accounts were created.  I suspect that some user accounts were created before GDPR changes, and others after.

Sorry I don't have a clear means for you to be able to change this behavior right now.  But that said, I am interested to better understand this problem. Is the problem in regards to trying to import this data to a different Jira site or an external system?  I am not sure if the problem is in regards to the different outputs, or if accountId is the problem here because it's not as apparent who that user is.  I am curious to learn more here about your use case.

If you happen to search in JQL by the specific worklogAuthor, perhaps this can better serve to return issues and expected users.  The JQL can accept various formats for this user value, but that might not be as helpful here.

Andy