How to import CREATED DATE and CLOSED DATE of issues

ichirof December 7, 2021

I have had Excel sheet of issue list including closed or ongoing issues, and want to import all of them into Jira project. Then want to display them on Created versus Resolved Issues gadget.

I could not find CREATED DATE or CLOSED DATE in field mapping selection of importing process.

How to import these dates into Jira project, and display Created versus Resolved Issues graph correctly?

2 answers

1 accepted

1 vote
Answer accepted
Bastian Stehmann
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 8, 2021

Hi @ichirof ,

 

welcome to the community.

 

The field names are Date Created and Date Resolved.

2021-12-08 09_30_24-Clipboard.png

ichirof December 8, 2021

@Bastian Stehmann 
Thank you for reply!

I understand these fields names, but I can not find these fields in "Jira Field" selection list of Map fields. which is 3rd step of "Import issues from CSV".

Jira_FieldMapping20211208.jpg

Bastian Stehmann
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 8, 2021

Maybe you can not select them because you are currently looking with a field with a number. Are they also missing with fields, that have a date (according to the date format configured in step 2)?

ichirof December 8, 2021

@Bastian Stehmann 
It seems Date type fields also can not select Date Created or Date Resolved.
Jira_FieldMapping20211209.jpgJira_FieldMapping20211209_2.jpg

ichirof December 9, 2021

Hi, @Bastian Stehmann ,

I found another import function page which includes Date created and Date resolved as Jira fields selection list.

"Import Issue from CSV" from the drop down menu of the Issues at the top panel does not carries this functionality to update issue. On the other hand "External System Import" (Setting -> System) has Date created/resolved in Jira fields selection list.
image.pngimage.pngJira_Users20211209_4.jpg

Like Wong Zhao Cai likes this
Bastian Stehmann
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 9, 2021

Hi @ichirof ,

 

great to hear that. Yes, that's right. The Import from the issues menu is a bit more limited in functionality.

ichirof December 9, 2021

Hi @Bastian Stehmann ,

Thank you for your help.
Finally I got my Created versus Resolved Issues graph and more!
image.png

0 votes
Wong Zhao Cai September 17, 2023

exactly the answer i am looking for!! thanks Ichiro san!!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events