Troubleshooting
Space shortcuts
Child pages
  • Importing Data from CSV file

Versions Compared

Old Version 1

changes.mady.by.user Jayesh Baviskar

Saved on

compared with

New Version Current

changes.mady.by.user Jayesh Baviskar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

Assignee, Summary, Description, Attachment, Comment
Admin, "Issue demonstrating the CSV attachment import", "Please check the attached image below.", https://localhost:8080/secure/attachment/imagename.png

2. Running the CSV file import wizard

Before you begin: If your JIRA installation has existing data — Backup your existing JIRA data.

  1. Log in to JIRA as a user with the JIRA Administrators.
  2. Select Administration > System > Import & Export > External System Import > Import button associated with the Comma-separated values (CSV) option to open the CSV File import page.
  3. On the CSV File import page, select your CSV Source File.
  4. Leave the Use an existing configuration file check box cleared.
  5. Click the Next button to proceed to the Setup project mappings step of the CSV file import wizard.
  6. On the Setup project mappings page, 
    1. Select a project.
    2. Enter the email address domain for any new users specified in the CSV file which will be added to JIRA during the import.
    3. Specify the date format used in your CSV file. Use the syntax that complies with the Java SimpleDateFormat.

  7. Click the Next button to proceed to the Setup field mappings step of the CSV file import wizard.
  8. On the Setup field mappings page, specify each CSV Field (determined by your CSV file's header row) you want to import into your chosen JIRA project by selecting their check boxes under the Import column on the left.

    Please Note:

    • At least one of these fields must contain data for JIRA's Summary field.

  9. In the JIRA field column, select the JIRA fields you want to match to fields defined in your CSV file.

    Please Note:

    • The Summary field must be specified for one of your JIRA fields and the Next button will remain unavailable until you do so.

  10. To modify the values of any fields' data in the CSV file before they are imported into JIRA, select the Map field value check boxes next to the appropriate fields.
  11. Click the Next button to proceed to proceed to the Setup value mappings step of the CSV file import wizard.
  12. On the Setup value mappings page, specify the JIRA field values for each CSV file field value.
  13. Click the Begin Import button when you are ready to begin importing your CSV data into JIRA. The importer will display updates as the import progresses, then a success message when the import is complete.

 

 

Custom Field need to be created in Jira

Available fields in Jira
Jira Mapping FieldsCase IDIssue TypeReporterSummaryCustomer NamePriorityAssigneeAssigned GroupDate CreatedDate ResolvedLabelsDescription
CSV Format HeadingsCase #,Case Type,Reporter,Case Subject,Company,Priority,Assigned Agent,Assigned Group,Created At,Resolved At,Labels,Body