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 |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== 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 27: | Line 29: | ||
* '''assignee''' column | * '''assignee''' column | ||
** rename '''teostaja''' column to '''assignee''' | ** rename '''teostaja''' column to '''assignee''' | ||
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!
- Enable module importer in your project settings.
- Go to import tab in the project
- Select your file
- Assign column names to data
- Import