import user field fail from csv file,the excel export display full name of user field,it's not the correct format to import

[fabby]

i export the excel from jira,user field like "assignee","reporter" display full name like "Li Xianwei(李先伟)",

while the correct user field import format is "xianwei.li" --should use the users' "username" or login name

so i have to replace the value of "assignee" ,"reporter" to "username" format in the excel file.

if i have 100 issues in the excel ,i have to parse all user filed of the 100 issues one by one

it's not realistic.

is there any methods to resolve my problem?

[Wojciech Seliga · Accepted solution]

I have no good news here for you. Currently CSV importer does not support it. You would have to "search and replace" all full names into usernames in your exported CSV file.

I've raised an issue for it in JIRA Importers Plugin - https://studio.atlassian.com/browse/JIM-679 - feel free to comment/vote there.

[fabby]

i have temporary resolved it by using vba to replace the "display name " to "user name " in the excel file .

then transfer the excel file to csv file