Trying to understand import anomalies

I have noticed some oddities on using import. We are using hosted Jira, and of course, some things may be a result of using a relatively "out of the box" version of Jira (company policy is to keep customization to a minimum):

  1. On import, I am asked to which project. I'd happily have that be a field in the CSV, but this seems to be hardwired. So, one project per import file?
  2. On import, I am asked for a date format, but I can't find any field that accepts a date that can be imported. Ideas? (and why would the system default to DD-MMM-YY instead of the less-language-dependent, ISO standard, YYYY-MM-DD format?)
  3. I seem to have to both manually specify mappings, (e.g., Summary -> Summary) and THEN map the field. Missing something? This seems like an unusually awkward process. Do others do the same? Move through it and just save the setup for the next import (I haven't because I am still evolving what I can include/what is desirable in an import.)
  4. Has anyone explored exporting a project, modifying stories in Excel, then importing updates?
  5. Finally, with all of the extra steps and warnings, I still managed to import a story to the wrong project. Any way to modify/move the project in which a story sits, after the fact? This is not really an import-specific issue--could happen with any story and any project (although most people probably take more care and never make this mistake?

Many thanks,


1 answer

You can select project before import or set the project target in a column inside the csv file.
For the date you can use the syntax that complies with the Java SimpleDateFormat.
CSV import is a not easy at the beginning but once the CSV file is built it is ok. Do not hesitate to save the configuration, which you can use at the first step of the CSV file import.


Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,307 views 14 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot