Importing issues to redmine: Difference between revisions

From Phobos Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
  NB! Enable module '''importer''' in your project settings.
== Prepare your CSV file ==
  The first line of the CSV file contains headings, which you need to use later
* '''Start date''' column
* '''Start date''' column
** Rename '''kuupäev''' to '''Start date'''
** Rename '''kuupäev''' to '''Start date'''
Line 7: Line 8:
* '''Author''' column
* '''Author''' column
** Rename '''Teate vastuvõtja''' to '''Author'''
** Rename '''Teate vastuvõtja''' to '''Author'''
** Use only first name
* '''Subject''' column
* '''Subject''' column
** Create a new column
** Create a new column
Line 14: Line 16:
** Create a new column
** Create a new column
** Concatenate data from two columns ('''teade''' and '''kommentaar''')
** Concatenate data from two columns ('''teade''' and '''kommentaar''')
*** =IF(LEN(L9)=0, F9,CONCATENATE(F9, CHAR(10) , "Lisainfo: ",L9))
*** =IF(LEN(L9)=0, F9,CONCATENATE(F9, CHAR(10) ,CHAR(10) , "Lisainfo: ",CHAR(10) ,L9))
*** L9 - kommentaar; F9 - teade
*** L9 - kommentaar; F9 - teade
* '''tracker''' column
* '''tracker''' column
Line 29: Line 31:


  Save file as CSV
  Save file as CSV
== Importing in Redmine ==
You need to be an administrator to import!
# Enable module '''importer''' in your project settings.
# Go to import tab in the project
# Select your file
# Assign column names to data
# Import

Latest revision as of 15:31, 21 February 2011

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