9. Import/Export OpenOffice

You can export the product backlog to an OpenOffice document and you can import a product backlog from it. If you want to use the import method the OpenOffice document must fulfill the following requirements:

  • The product backlog must be in the first table of the document.
  • The backlog items or tasks are listed from row 2 on. The first row contains the optional description of the colums
  • The items must be listed continously from row 2 to row n.
  • The table must have the following structure:
    • Column A: Priority (optional).
    • Column B: Topic of the backlog item (mandatory).
    • Column C: Title of the task (optional).
    • Column D: First name of the team member (optional).
    • Column E: Surname of the team member (optional, if a value is set in column D this column must be set, too).
    • Column F: Estimation of the task (optional).
    • Column G: Status (optional).
    • Column H: Sprint (optional).
    • Column I: Begin of the sprint (optional, if the value in column H is set, this column must be set, too).
    • Column J: End of the sprint (optional, if the value in column H is set, this column must be set, too).
    • Column K: Description of the backlog item. The description of a backlog item occurs on its first appearance (optional).
    • Column L: Description of a task (optional).
    • Column M: Acceptance of a backlog item. The acceptance must occur on the first appearance of the backlog item (optional).
    • Column N: Requirements of the backlog item. The requirements must occur on the first appearance of the backlog item (optional).
    • Column O: Name of the epic. The epic must occur on the first appearance of the backlog iem (optional).