Excel data Import QC operation process

Environment:

QC9

Windows xp

Office2007

 1. Preparation

1. Import QC through Excel, you need to download Microsoft Excel add-in:

Http://update.external.hp.com/qualitycenter/qc100/msoffice/msexcel/index.html

2. Install Microsoft Excel add-in, you need to close the Excel application before installing and run as Administrator.

Note: If you have previously installed an earlier version of the plugin, it is best to uninstall it before installing it.

3, after the installation, open the Excel table (take Excel2007 as an example), click "Add-ons", appear in the bounds of the red box "Export to Quality Center".

Figure 1?1 Export to Quality center button

Note: When importing Test into QC from Excel, you may need permission to write files under "X:\Program Files\Microsoft Office\office12\xlstart" (Office installation directory), or you will not be able to import them.

2. Data Import QC

The plug-in supports the requirements, test plans, defects related data from Excel Import QC, these 3 steps are basically the same, the following to import test plan data as an example.

1, the first requirement of the Excel document format to be consistent with the QC data field, sample format as shown in 2-1.

Figure 2?1 Excel Data sample

2, select the content that you want to import QC, (note: not including column header) Click the menu "add-ons->export to quality Center", as shown in 2-2.

Figure 2?2 Data Import Step 1 Enter the QC server address

3, enter the address of the QC, click "Next", as shown in 2-3.

Figure 2?3 Step 2 Enter the user name password

4, enter the QC username and password, click "Next", as shown in 2-4.

Figure 2?4 Step 3 Enter the domain and project name

5. Select the desired domain name and project, click "Next", as shown in 2-5.

Figure 2?5 Step 4 Select the type to import

6. Select the type you want to import (requirements, test cases, defects), select "Tests" Here, click "Next", as shown in 2-6.

Figure 2?6 Step 5 new Map (map rule)

7. Select an already set map (map rule), or add a map again, click "Next", as shown in 2-7.

Figure 2?7 Step 6 establish a mapping relationship

8, the QC in the parameter name and EXECL table in the design of the column name to match the corresponding. The red parameter name in the figure is required, as shown in 2-8.

Figure 2?8 Example of a relationship between QC field and Excel Column name Mapping

9. Select a field on the left and click the ">" button to enter the corresponding column name in Excel, as shown in 2-9.

Figure 2?9 Enter the column for the QC field that corresponds to Excel

Note: You need to first select the data that you want to import before you can import successfully .

10, 2-10, select all OK, click "Export".

Figure 2?10 Examples of mapped rules that have been built

11, 2-11, the requirements are successfully imported.

Figure 2?11 Import Success

3. Summary

The import of requirements and defects and the import of the plan is basically the same, except that the Excel document structure is different, just note that all column data in Excel can find the corresponding field in QC, and must ensure the legitimacy of the data value, such as the field type in the QC inconsistent, will cause the import to fail.

For more detailed documentation, see the Microsoft Excel add-in Guide in the plug-in download page.

Attention:

1, the "test name" in the QC plan does not support \/:% ' *?<>| ".

2, the "subject" in the QC plan refers to the folder path, so the Excel writing mode is: ***\***, such as: Credit Application \2011 version of the Personal report \ batch processing \ Bulk Query request.

Accessories: QC test case templates. zip

Excel data Import QC operation process