PROCESS TO EXPORT TEST SCRIPTS FROM EXCEL TO TEST DIRECTOR FOR QUALITY CENTER

1.    Install and Configure the Microsoft Excel Add-In.

The Microsoft Excel Add-In can be accessed from the main QC login page.  Go to qcenter.oit.umn.edu/qcbin/start_a.htm and select the hyperlink for the “Add-ins Page” on the far left.

From the Add-ins page, select the hyperlink for “More Mercury Quality Center Add-ins”

 

Then select the hyperlink for the Microsoft Excel Add-in:

 

Click on the link for the “Mercury Quality Center 8.2 SP1 Microsoft Excel Add-in Guide”, and follow the instructions in Chapter 1 to download, install, and configure the

Microsoft Excel Add-In:

Once the add-in has been installed, you will see “Export to Quality Center” as an additional option in the Excel Tools menu drop-down:

2.    Create or modify the Excel spreadsheet.

Create or modify a test plan spreadsheet in Excel, using a template similar to the following:

Some of the columns will only be used in the upload/import into Quality Center, and may be hidden, if you prefer, to facilitate updating the test plan steps.

Complete the additional information needed to load the test plan into Quality Center: 

·         Subject (Folder Name within Quality Center)

·         Test name (Manual Test Plan Name)

·         Designer (Owner)

·         Creation Date

·         Description (description of the test)

·         Step Name

·         Description

·         Expected Results

 

Note the following:

• The Subject (Folder Name) should include a single folder within Quality Center where you can place the imported test cases. From there you can move the test cases within Quality Center to any other folders you want to place them in.

• The Test Name (Manual Test Plan Name) should be the intended test plan name in Quality Center.

• Designer should be your x.500 ID

• Creation Date should be the date you are creating the test case
• Description should include a description of the test and any prerequisites or outcomes

• Step Name should be a sequential step label in the QC format:  Step 1, Step 2 . . .
• Description should include the description of each step
• Expected Result should include the expected result for each step

      The information specified in the Subject column of the spreadsheet is used to create or find the correct folder path in Quality Center.

      The information in the Test Name column of the spreadsheet is used to create the Test Plan name in Quality Center:

3.    Map and export the data from the Excel spreadsheet to Quality Center.

a)    From the Excel spreadsheet:
Select the data to be exported, without the column headings.

b)    Choose Tools >Export to Quality Center.  The QC Export Wizard dialog box (Step 1 of 8) opens:

Enter http://qcenter.oit.umn.edu/qcbin/ in the dialog box.

c)    Click Next.  The QC Export Wizard Step 2 of 8 dialog box opens:

Select the domain and project name to which the test plan is to be loaded.

d)    Click Next.  The QC Export Wizard Step 3 of 8 dialog box opens:

Enter your User Name and Password.

e)    Click Next.  The QC Export Wizard Step 4 of 8 dialog box opens:

Select the radio button labeled “Tests”.

f)     Click Next.  The QC Export Wizard Step 5 of 8 dialog box opens:

Enter a name for your new map in the new map name field (or select it from the “Select a map” drop-down list).

g)    Click Next.  The QC Export Wizard Step 6 of 8 dialog box opens:

This is the page where you will identify the standard mapping of QC fields to your Excel spreadsheet columns.

NOTE:  The QC fields highlighted in red are required.

For each field to be populated in Quality Center, select the QC field on the left and click the “>” pushbutton to move it into the list on the right. You will be prompted to identify the corresponding Microsoft Excel Column:

h)    Click Next. The QC Export Wizard Step 7 of 8 dialog box opens, with a message to please wait while QC is being synchronized.

When the upload is completed successfully, the QC Export Wizard Step 8 of 8 dialog box will open, with a message that your export has been successfully completed:

Click the “Finish” pushbutton and you will be returned to the Excel spreadsheet.

If the test plan upload was not successful, a dialog box will open that displays the error(s):

Click the “Launch Notepad” pushbutton to view or copy the entire error message.

Test plans that have been successfully uploaded will now be accessible in Quality Center (if you are already logged into QC and you have the test plan view open, you may need to refresh your folder list).