Importing issues to redmine

NB! Enable module importer in your project settings.

• 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