HowTo import issues

Since 3.2.0 Redmine can import issues from CSV files (#950).
In the issues tab there is a import link on the right. You can import any CSV-type file. The first line must contain the column names. You can freely assign them to the different fields of an issue.

Notes on different Fields

Parent Issue

If the field starts with an #, the issue with that id is referenced. If the field contains a number it references the index of the issue in the import. Note that it's not the line number as line 1 contains the header.

From #23396#note-2:

Jean-Philippe Lang wrote:

When importing issues, the content of a the parent colum can be:
  • a number without # (eg: 10) => the parent will be the 10th imported issue
  • a number with # (eg: #10) => the parent will be the existing issue with id=10

Assignee

This must be the username. (Name and lastname works, tested on redmine 3.3)

Category and Target version

During test with 3.3, the assistant allowed me to use an option to automatically create version or category.

Project

The assistant will let you choose on which project you want to import the issue.

Assistant

The assistant will help you (tested on 3.3):

  1. Will ask for options with the file:
    Field separator
    Field wrapper
    Enconding
    Date Format
  2. Then next step will ask for the fields to match
    This is very interesting, because no matter what the names of the columns are, here you map which column is which field on the issue.

Attached issues.csv has the CSV used during test with 3.3.

example_import_options1.jpg (13.1 KB) Pablo Estiga, 2017-02-01 20:18

example_import_csv.jpg (62.1 KB) Pablo Estiga, 2017-02-01 20:18

issues.csv Magnifier (310 Bytes) Pablo Estiga, 2017-02-01 20:20