We have an excel list contains a list of tasks. Is there a document on how to upload these data efficiently? Any template or tutorial? Thank you!

5 answers

1 vote

Hi Abul,

Are you referring to importing data from a CSV file into JIRA?  If so there is an article titled Importing data from CSV that will be of the most assistance.

Take a look at the CSV file structure section for specifics on how the CSV should be structured. 

Cheers,

Branden

thanks, Nic and Branden, 

Yes, it's Jira cloud. I'm not able to find a template. I am looking for a template so I can enter the data in the template and upload the file. 

Hi Abul,

Casecomplete has an example csv file at the bottom of their article JIRA Import / Export via Excel.  While it doesn't have an example csv another page from Valiantys has a good explanation and screenshots titled How to import issues into JIRA that may help.

Cheers,

Branden

You don't need a "template", just fill in the data as laid out in Branden's links.  A "template" is only going to be useful for one specific user's needs, which will almost certainly be different to yours.

Thank you, I think I am missing something. I created a CSV file entered the data, My columns are 

Issue ID Issue Type Reporter Due Date Summary Assignee Labels Priority

But when I import this file and on the Fields page, I  just see one field to map. Is there something I am missing I think my file is not correctly created. Please see the screenshot by following the below links. 

https://files.fm/u/qc5rjwzg#/view/Step+1.docx

That's not a CSV file.  There's a clue in the name - "comma separated variable"

Hi Abul,

I'm not sure if you can export that as CSV or convert it to CSV but if so you would need to open it and verify it's format.  The best way to create a  CSV file that is custom to your needs is going to be to follow Importing Data from CSV

Cheers,

Branden

Thank you! I am able to create a CSV file and load it.. however, we are facing issue with parsing date.. See below. I checked the formatting looks the same. 

 

2017-12-18 16:13:39,471 INFO - Import started by abul.khair using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2017-12-18 16:13:39,639 WARN - Unable to parse date: 1/Sep/17
2017-12-18 16:13:39,644 WARN - Unable to parse date: 1/Sep/17
2017-12-18 16:13:39,648 WARN - Unable to parse date: 1/Sep/17
2017-12-18 16:13:39,652 WARN - Unable to parse date: 1/Sep/17
2017-12-18 16:13:39,656 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,659 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,663 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,667 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,671 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,674 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,678 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,682 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,685 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,689 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,693 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,696 WARN - Unable to parse date: 13/Sep/17
2017-12-18 16:13:39,700 WARN - Unable to parse date: 5/Sep/17
2017-12-18 16:13:39,704 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,708 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,711 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,715 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,719 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,723 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,727 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,731 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,734 WARN - Unable to parse date: 15/Sep/17
2017-12-18 16:13:39,738 WARN - Unable to parse date: 2/Oct/17
2017-12-18 16:13:39,742 WARN - Unable to parse date: 2/Oct/17
2017-12-18 16:13:39,745 WARN - Unable to parse date: 2/Oct/17
2017-12-18 16:13:39,749 WARN - Unable to parse date: 2/Oct/17
2017-12-18 16:13:39,753 WARN - Unable to parse date: 9/Oct/17
2017-12-18 16:13:39,757 WARN - Unable to parse date: 19/Oct/17
2017-12-18 16:13:39,760 WARN - Unable to parse date: 15/Oct/17
2017-12-18 16:13:39,764 WARN - Unable to parse date: 1/Dec/17
2017-12-18 16:13:39,768 WARN - Unable to parse date: 15/Feb/18
2017-12-18 16:13:39,772 WARN - Unable to parse date: 15/Feb/18

Hi Abul,

There are a few reasons this could occur:

  • The format of dates is not correctly set in the import configuration file. The date format for custom fields must match the "Date format in input file" which has a default format of yyyyMMddHHmmss
  • JIRA system date fields such as Created, Updated and Due Date use "yyyy-MM-dd HH:mm:ss" but may need an offset added
  • Date Picker and Date Time Picker formats are not consistent, e.g.

    jira.date.picker.java.format=dd/MMM/yy
    jira.date.time.picker.java.format=MMM/dd/yy hh:mm a
    

    should be corrected to,

    jira.date.picker.java.format=dd/MMM/yy
    jira.date.time.picker.java.format=dd/MMM/yy hh:mm a
    

 (info) See Changing the Due Date Input Format for more information about changing these values.

Take a look at Commonly Asked CSV Questions and Known Issues for more information.

Cheers,

Branden

Hi Branden, still no luck.. I tried.. different format but it's the same issue.. I tried this format but still not working. 

dd/MMM/yy

Parent ID,Issue ID,Labels,Issue Type,Summary,Assignee,Due Date
YE2017-00,YE2017-01,YE2017,Task,Configure Year-End Performance Template - CCI (60/40 w/o Approval),xx,1/Sep/17
YE2017-00,YE2017-02,YE2017,Task,Configure Year-End Performance Template - CCI (75/25 w/ Approval),xx,1/Sep/17
YE2017-00,YE2017-03,YE2017,Task,Configure Year-End Performance Template - CCI (75/25 w/o Approval),xx,1/Sep/17
YE2017-00,YE2017-04,YE2017,Task,"Configure Year-End Performance Template - Cox Auto, CEI, CMG",xx,1/Sep/17
YE2017-00,YE2017-05,YE2017,Task,Update Extensibility for Notifications (Document Name),xxx,1/Sep/17

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

64 views 0 5
Read article

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