Importing issues to redmine: Difference between revisions
Jump to navigation
Jump to search
(Uus lehekülg: ' NB! Enable module '''importer''' in your project settings. * '''Start date''' column ** Rename '''kuupäev''' to '''Start date''' ** Use date format 2011-02-21 * '''Instigator''' c...') |
No edit summary |
||
| Line 27: | Line 27: | ||
* '''assignee''' column | * '''assignee''' column | ||
** rename '''teostaja''' column to '''assignee''' | ** rename '''teostaja''' column to '''assignee''' | ||
Save file as CSV | |||
Revision as of 12:08, 21 February 2011
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
- 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) , "Lisainfo: ",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