Open Category List

Importing Test Cases Using .CSV File

3 minutesread

In addition to creating test cases using the Applause Platform user interface, you can also create test cases by uploading a .csv file. This option may be preferred when importing a large number of test cases from your Test Case Management (TCM) system. This method is also commended for initial platform setup when traditionally a large number of test cases are to be created in the Platform prior to testing can begin.

For your convenience, a template for the .csv file is available for download in the Platform.

Note: Test Case import allows only for creation of new test cases (and not updating existing ones). The .csv file must not contain test cases already set in the Applause Platform. 

Downloading Test Case Import Template 

To download the Test Case Import Template:

1. Log in to the Applause Platform and navigate to Test Cases.

2. The Test Case Management page will be displayed, by default on the Test Cases tab. Under the Test Cases tab, click on Import.

3. The Import Test Cases page opens. In the note at the top of the page, click on CSV Template.

 

Alternatively, you can download the template from here

Adding Test Cases and Steps to the Template

The template includes data to allow creating both test cases (columns B-D) and steps (columns E-I). Column A – Type – defines the type of data included in each row.

To prepare the .csv file:

  1. In the template file, add the test case and step data according to these columns
    1. Type: Set the type of data in row:
      1. “Header”: Row contains test case data
      2. “Step”: Row contains step data
    2. Test Case Name: Name of the test case. Used in “Header” rows only.
    3. Description:  Description of the test case. Used in “Header” rows only.
    4. Estimated Hours: Estimated time to complete the test case, in hours. Value may be a positive integer or floating number (not zero). Used in “Header” rows only. 
    5. Step Number: The ordinal number of the test case step. Successive steps within a single test case should be numbered sequentially. Used in “Step” rows only. 
    6. Step Name: Name of the test case step. Used in “Step” rows only. 
    7. Actions: Action the tester is required to perform as part of the test case step. Make it as short, clear and concise as possible. Used in “Step” rows only. 
    8. Expected Result: Result the tester is expected to get once performed the Actions. If the tester will indeed get the expected result, then the test case step will “pass”. Otherwise, it will “fail”. Used in “Step rows only.
    9. Min Attachment Per Step: Set a minimum number of attachment files required for the test case step. Enter “0” when attachments are not mandatory. Used in “Step rows only.

Note: Do not change any column headers.

  1. Save the .csv file.

 

Importing the .CSV File

To import the .csv file with your test cases and steps data:

  1. In the Test Cases tab under the Test Case Management page, click Import.
  2. The Import Test Cases page opens. Select the Product and Test Suites the test cases will be associated with (Note that the product list might take few seconds to load).
  3. Click Choose File and select the file to upload, or simply drag & drop it to the designated location.

  1. Click Import.
0
0
1485
3 minutesread

Related Knowledge Base Posts