Importing issues to redmine

From Phobos Wiki
Jump to: navigation, search

Prepare your CSV file

The first line of the CSV file contains headings, which you need to use later
  • Start date column
    • Rename kuupäev to Start date
    • Use date format 2011-02-21
  • Instigator column
    • Rename Klient või algataja to Instigator
  • Author column
    • Rename Teate vastuvõtja to Author
    • Use only first name
  • Subject column
    • Create a new column
    • use formula to get 254 characters from teate string
      • LEFT(F2, 254)
  • Description column
    • Create a new column
    • Concatenate data from two columns (teade and kommentaar)
      • =IF(LEN(L9)=0, F9,CONCATENATE(F9, CHAR(10) ,CHAR(10) , "Lisainfo: ",CHAR(10) ,L9))
      • L9 - kommentaar; F9 - teade
  • tracker column
    • Create a new column
    • =IF ( G2="X", "bug", "feature" )
  • % done column
    • Create a new column
    • if issue is fixed set value to 100, else 0
  • status column
    • Create a new column
    • if issue is fixed set value to closed, else new
  • assignee column
    • rename teostaja column to assignee
Save file as CSV

Importing in Redmine

You need to be an administrator to import!
  1. Enable module importer in your project settings.
  2. Go to import tab in the project
  3. Select your file
  4. Assign column names to data
  5. Import