nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Updated Usernames are not reflecting in the exported reports

Vinay Poosa

Hello Experts,

Recently, in JIRA I have updated a couple of usernames as they were not set as per my standards of using company email IDs as usernames. Even after updating them I still get the old username formats in the exported reports.

Example: My Username was setup as vinay.poosa and I have updated it to vinay.poosa@JIRA.com. When I export my worklog details from JIRA to excel I still see my username as vinay.poosa but not as vinay.poosa@JIRA.com

Am I missing any steps here? Can someone please help with this?

Thanks much in advance.

Accepted answers

All comments

Olga Videc

Hello @Vinay Poosa

Have you tried re-indexing? Your database need's to be "updated" with fresh data, that's why when you make changes you re-index changing your username is one of those.

Here is documentation, but if you are doing this first time I recommend "Background re-index"

https://confluence.atlassian.com/adminjiraserver/re-indexing-after-major-configuration-changes-938847716.html

BR, Olga

Vinay Poosa

Hello @Olga Videc firstly appreciate your quick response and you answer your question yes we have performed re-indexing after updating the usernames in JIRA. Thanks.

Vinay Poosa

Also, for a few users, I get their usernames as "JIRAUSER18105" only in the exported excel reports.

Olga Videc

Okay,

Here is a explanation from Atlassian

Quoting Andy Heinzer (Atlassian Team) from https://community.atlassian.com/t5/Jira-Software-questions/Wrong-user-name-reference-when-renaming-username/qaq-p/665936

"You are not expected to be able to change this field in the jiraissue table. Actually the value in the jiraissues table is correct. I understand why you might believe it to be wrong, but that is because of the way Jira is tracking user account renames.

Jira tracks a user account being renamed inside the app_user table. When an account is first created in Jira the user_key field is set to match the cwd_user.user_name value. However after this account is first created, that user_key field is never expected to change in the Jira database. Regardless of whether or not the username changes, that user_key remains constant for that particular user account. Instead the app_user.lower_user_name value can change to correspond with the changes in cwd_user table when the user gets renamed, but there are several places within Jira that do not directly refer to the cwd_user table for the user account. Instead Jira is primarily looking at the app_user.user_key entry for historical records such as which user updated an issue, or executed a transition. This can also be seen when you look at the issue details view in Jira, if you click on the history tab, this view shows the app_user.user_key field for a username, and not the cwd_user.user_name field.

This way Jira can keep track of historical changes that take place through a specific account, even if that account's name changes over time. "

You are exporting tempo work logs or standard Jira work logs?

Can you export by full name instead of username?

BR, Olga

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server