Once it is enabled, this App adds a button in the Backlogs view toolbar that allows Product Owners and ScrumMasters to upload and Excel file (xls or xlsx) that contains stories you want to import into iceScrum.
First, if the first row of your file contains column headers, be sure that the corresponding checkbox is checked. Uncheck it otherwise.
Then, choose the mapping between the columns of your spreadsheet and the fields of iceScrum stories. Columns are identified either by the headers if your file includes them or by the Excel default column names.
Available story fields are:
Name (mandatory): a string (<100 chars)
Type: either the type label as it appears in the application in your language, or a number (user story: 0, defect story: 2, technical story: 3)
State: either the state label as it appears in the application in your language, or a number (Suggested: 1, Accepted: 2, Estimated: 3)
Description: a string
Feature: either its name or its uid, must already exist
Depends on: either its name or its uid, must already exist
Tags: list of strings separated by a comma (,)
Effort: a positive number, will be taken into account only if state is Estimated
Value: a positive integer
Affected version: a string
Notes: a string
You can download a file template with these columns:
By default, stories are imported at the state Suggested, so you will find them in your Sandbox. Since iceScrum 7.23, you can also import them in directly into your Backlog by setting the State field to either:
– Accepted: you need to be Product Owner,
– Estimated: you need to be either both Product Owner and ScrumMaster, or Team Owner, and the Effort must be provided.
If iceScrum encounters an error (e.g. a story with the same name already exists), then it will skip the row, report the error and continue the import.