Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to import CREATED DATE and CLOSED DATE of issues

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?

1 answer

1 accepted

0 votes
Answer accepted

Hi @ichirof ,

 

welcome to the community.

 

The field names are Date Created and Date Resolved.

2021-12-08 09_30_24-Clipboard.png

@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

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)?

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

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

Hi @ichirof ,

 

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

Hi @Bastian Stehmann ,

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

385 views 18 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you