Import backlog items

Import stories and defects into your ALM Octane backlog from an MS Excel file.

Step 1: Prepare the import file

In an Excel (.xls or .xlsx) file, list the user stories, quality stories, and defects you want to import. If you exported items to the file from another tool, you must update the file according to the specifications described below.

Supported versions: Microsoft Excel 2010 and higher.

Note: You can download a template file to help you build an import file according to the specifications. Expand Settings and select Import > Backlog Items. In the Import Backlog Items dialog box, click View import file example.

To prepare the import file:

  1. In an Excel file, create a separate named tab for each item type to import: User stories, Quality stories, and Defects.

    You only need to create tabs for the item types you want to import.

  2. In Row 1 of the sheet, list the fields for which you want to enter values. You must use the fields' logical names, not the field labels. You can list both system and user-defined fields. See the tables below for a list of possible fields. The mandatory fields required for a successful import are noted.

    Note:  

    • The values described in the tables below are the default system values. Your ALM Octane workspace may use different values depending on the workspace configuration.

    • Localization: You must use the English field names, even if your UI is in a different language.

    • Team Edition: In Team edition you cannot create epics. If you open the import file example, you will see the columns that are relevant for Team edition.

  3. On separate rows, enter field values for each user story, quality story, and defect to import.

    Each entity in ALM Octane has required fields, as determined by the entity form settings. If you do not enter values for all the required fields of an entity, ALM Octane imports the entity in Draft status. After the import, open these items and fill in values for all required fields.

    Tip: Use the Is Draft column to find items in Draft status.

    Localization: If your user language is set to another language, use localized values in the Excel sheet.

    By default, you can import up to 1000 backlog items in a single import. If you have more, prepare other Excel files to import all the items.

    If you want to import more than 1000 backlog items, have your site admin set the IMPORT_WORK_ITEMS_FUSE configuration parameter to the necessary number. For details, see IMPORT_WORK_ITEMS_FUSE .

Date formats

The following date syntaxes are supported:

Definition Example
Time with offset

"2015-05-12T10:15:30+01:00"

Time with zone ID "2015-05-12T10:15:30Z"
Time with offset and zone ID

"2015-05-12T10:15:30+01:00[Europe/Paris]"

"2015-05-12T10:15:30+00:00[Z]"

Back to top

Step 2: Import backlog items

For details on how to import backlog items from Excel, see To import items:.

Back to top

Next steps: