1. Test Case Management
  2. Test Case Upload

8 Test Case Upload

This topic explains the systematic instructions to upload the excel template along with data.

  1. On Homescreen, under Browser, click on Test Case Data Upload.
    The Test Case Upload screen displays.

    Figure 8-1 Test Case Upload


    Description of Figure 8-1 follows
    Description of "Figure 8-1 Test Case Upload"

  2. On the Test Case Upload screen, click the choose button (add icon) and select the Test Case ID.
  3. By default, the system displays the following fields.
    1. Description
    2. Function ID
    3. Branch Code
    4. Action Code
    5. Service Name
    6. Original Release
    7. Operation Code (If applicable)
  4. Click on Upload Excel button, to upload the excel template.
  5. While uploading the excel sheet, refer the below points.
    1. The Parent Record Id in the Master Data block’s sheet should be null.
    2. The Parent Record Id in Non-Master Blocks should not be null.
    3. All data needs to be input into the sheet as String only. I.e., for Date and Number fields, they need to be input with an apostrophe before the value. E.g. 2010/02/02 or 9087 etc
    4. Excel sheet should be 2003 version (File extension name should be .xls)

      Note:

      For proper display of excel sheet in the browser, user needs to ensure the following In Windows explorer Folder Options, and then File Types.

      Figure 8-3 Folder Options


      Description of Figure 8-3 follows
      Description of "Figure 8-3 Folder Options"

    5. To browse in same window, select the extension, click on Advanced and select the Browse In same window checkbox.
      Edit File Type window is displayed.

      Figure 8-4 Edit File Type


      Description of Figure 8-4 follows
      Description of "Figure 8-4 Edit File Type"

    6. Click OK.
      Edit File Type window is closed.
    7. Click OK on the Folder Options window.
  6. On the Test Case Upload screen, to save the test case upload details, click on Save. (Add icon)
    If multiple columns are there in the Excel sheet, TCM will create multiple Test Cases.
For Example:

TEST CASE: COUNTRY_CODES

If the user uploads data with two columns for INDIA & USA, The system creates two test cases as:
  • COUNTRY_CODES_01 (this TC to create country - INDIA)
  • COUNTRY_CODES-02 (this TC to create country - USA)