Importing issues to redmine
Jump to navigation
Jump to search
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