You are here

Export & Import

Export
Stories can be exported for further analysis, reporting, or printing cards for the radiator board. Either the entire project, or a single iteration can be exported depending on where the export is selected from. When selected from the ‘Iterations’ Menu, only the current iterations worth of stories is exported, if selected from the ‘’ menu all stories for the project are exported. Remember that this includes Epic Stories and if you do a simple sum() of the points you will end up double or triple counting.
Stories are written to a csv file that can easily be imported into a spread-sheet, printed etc. (The backlog is simply treated as another iteration).

Import
To help transferring project information a rudimentary import feature it provided. You can only import stories for a single project. Release, Iteration and Owner columns are reference columns and must be configured for the project before attempting an import.
The import file must be in the same format as export file and all columns must be present and in the correct order, they can however be empty. The first line of the import file will always be skipped so make sure that it does not contain data. To get a sample file, simply export you smallest iteration (It must contain at least 1 story!!).
When importing, if a Story ID exists, the import will issue an update command, otherwise it will attempt to insert a new record.

Import Behaviour is as follows:

  • The first line of the import file will always be skipped so make sure that it does not contain data.
  • When importing, if a Story ID exists, the import will issue an update to that story, otherwise it will attempt to insert a new record.
  • Both a Status and summary must be present, otherwise the import record will be skipped
  • As weird as it sounds, the import routine also deletes records. To do this, a story ID must exist, Status an summary must be present and the “Iteration” must contain the string "** Delete **"

The parent column is never updated , so any relationships will need to be manually created after the import has taken place. Stories that are updated will be handled appropriately.

Notes:
Where an iteration does not exist, the story is put into the backlog.
If there is an error when importing a record, it will simply be skipped.
All large text columns for a story are limited to 32000 characters