Upload Data

[Abul Khair]

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!

[somethingblue]

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

[Abul Khair]

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. 

[somethingblue]

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

[Nic Brough -Adaptavist-]

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.

[Nic Brough -Adaptavist-]

Assuming server, https://confluence.atlassian.com/adminjiraserver071/importing-data-from-csv-802592885.html - still valid through to 7.6

[Abul Khair]

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

[Abul Khair]

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

[somethingblue]

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
  

  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

[Abul Khair]

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

[Abul Khair]

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

[Nic Brough -Adaptavist-]

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

[somethingblue]

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