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?
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.