Importing data from CSV

JIRA comes with a number of importers to import data from other popular issue trackers. If you want to import data from an unsupported issue tracker, JIRA provides a generic comma-separated values (CSV) importer. This is also quite useful if you want to import data from some generic applications, such as MS Excel.

In this recipe, we will look at importing data from a CSV file.

How to do it…

Perform the following steps to use the CSV importer:

  1. Navigate to Administration | System | External System Import.
  2. Select the Import from Comma-separated values (CSV) option.
  3. Select the source CSV file in the CSV Source File field:
    How to do it…
  4. Expand the Advanced section and select the file encoding used in the CSV file and the delimiter if you are not using the default comma (,) character. Click on Next to go to step 2.
  5. Select the project you want to import your CSV data to and the format used to represent the date. This is important; otherwise, JIRA may not be able to parse the date values contained in the file. Click on Next to go to step 3:
    How to do it…
  6. Map the CSV columns to the JIRA fields. For this step, you have to at least map a column to the issue summary field. Check the Map field value checkbox for fields you want to map values for, such as for select list fields. Click on Next to continue.
  7. Map values from the CSV file to the JIRA field values. The CSV importer will use this as a mapping rule while processing the CSV file. Click on Begin Import to start importing data.
  8. Review the import result. You can click on the download a detailed log link to get a full log of the process if the import has failed. You can also click on the save the configuration link to get a copy of the mapping files so that the next time, you do not have to remap everything from scratch.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset