Versionone 简明教程

VersionOne - Import Data

VersionOne 支持导入数据以创建故事、缺陷和其他 Excel 数据。考虑以下内容以从 Excel 导入数据。

VersionOne supports to import data to create stories, defects and other data from excel. Consider the following to import the data from excel.

  1. Rules for Excel file.

  2. Import the excel file into system.

此外，VersionOne 提供了一个导入数据的模板。用户可以下载该模板以使用。

Additionally, VersionOne provides a template to import data. A user can download the template to utilize.

Download Import Template

VersionOne 提供要导入的示例模板。它结合了必填项和可选项。用户可以根据需求输入详细信息。在以下部分中，我们将讨论如何下载示例模板。

VersionOne provides sample template to import. It is a combination of required and optional fields. A user can enter the details based on the requirement. In the following section, we will discuss how to download the sample template.

  1. Select Product Planner → Import. It opens the Import page.

  2. Click on the Download Basic Excel Template to download basic template. It is used to import the backlog items such as stories, defects, tests, tasks, etc.

  3. Click on the Download Advanced Excel Template to download advanced template. It is used to import more complex system assets, such as projects, iteration schedules, change sets, requests, etc.

以下屏幕截图显示了如何下载模板 −

Following screenshot displays how to download template −

download basic excel template

基本 Excel 模板如下所示 −

A basic Excel template looks like the following −

AssetType

Name

Scope

Description

Estimate

Priority

高级 Excel 模板如下所示 −

An advanced Excel Template looks like the following −

advanced excel template

Rules for Excel File

每个模板都有一些在导入数据之前要考虑的基本规则/检查点。如果这些检查点失败，将不会导入数据并显示错误消息。在本部分中，我们将讨论 Excel 规则 −

Every template has some basic rules/checkpoints to be considered before importing the data. If these checkpoints fail, data will not be imported and error message displays. In this section, we will discuss the excel rules −

创建 Excel 文件时，请考虑以下几点 −

Consider the following points while creating an excel file −

  1. The header of the first column should always be "AssetType". The column should have the system name for the asset type. The system names for basic asset types are included in the comments in the templates. For example, for story it should be Story, Defect for each Defect and Issue for each issue, etc.

  2. The attribute data for the new backlog item should go to the remaining columns. The column header should be the name of the attributes. The column should contain the corresponding attribute value for that asset.

  3. Worksheets are imported into alphabetical order of worksheet name. In the same excel file, a user can reference a work item that was created in an earlier worksheet. For example, to create a project and stories within the project, first add the project in the first worksheet and then add the stories in the new project in a second worksheet.

  4. The backlog import template includes system names for default assets and fields. To include other assets or fields, including custom fields, please contact system administrator for the corresponding system names. User can remove unnecessary fields by deleting the column.

  5. To maintain data integrity, each Import is conducted within a single transaction. For this reason import is limiting to 500 items per import file.

  6. In the advanced template, there are 7 worksheets to upload 7 different items in single transaction. The Epics, Stories, Tasks, Tests, Defects, Requests and Issues form the order of the worksheet.

Import Excel File

可以使用 Excel 文件将数据导入到 VersionOne 中。用户必须在导入 Excel 工作表之前选中工作表的检查点。如果导入成功，用户将收到成功消息以及已导入的计数，否则会显示错误消息。对于部分成功导入，成功和错误消息都会显示。在本部分，我们将讨论如何导入 Excel 文件。

Data can be imported into VersionOne using excel file. A user must check the checkpoints of the excel sheet before importing it. If the imports are successful, a user will get success message along with the imported count otherwise an error message displays. For partial successful import, both success and error message get displayed. In this section, we will discuss how to import the excel file.

按照以下步骤导入 Excel 文件 -

Follow these steps to import the excel file −

转到产品规划人员 → 导入并单击上传已完成的 Excel 模板文件，如以下屏幕截图所示 -

Go to Product Planner → Import and click on Upload A Completed Excel Template File as shown in the screenshot below −

my home

将出现一个 Excel 导入弹出窗口，其中用户可浏览文件并上传。现在，单击如下图所示的导入按钮 -

An Excel Import pop-up appears wherein, a user browses the file and uploads. Now, click on the Import button as shown below −

choose file

  1. Once the import is done, a successful message displays or an error displays if there is any data issue.

  2. It also displays the type of asset imported and the total number of assets imported.

以下屏幕截图显示一条成功消息 -

The following screenshot shows a success message −

excel import