Course 4: How to Import Test Cases

Learn how to import test cases into the Applause platform.

To follow along with the lesson, click here to open the platform.

How to Import Test Cases

In addition to creating new test cases as we described in the previous course, you can also create test cases offline in Excel and then import them into the Applause platform.

How to Create an Import File

First, let’s begin by downloading and opening the CSV template and we will describe each of the columns in the test case file.

Note: There are nine labeled columns, do not change the header of these columns. But sometimes due to your computer regional settings, when you open a CSV file, all data might appear in one single column. Follow these instructions to fix it.





Type

Valid values are “Header” or “Step”.

  • Header label in column A will create a new test case

  • Subsequent rows should contain the Step label, it will create steps within the test case




Test Case Name

Should be used only in Header rows. Type the name you want for the test case.




Description

Should be used only in Header rows. Type the description you want for the test case.




Estimated Hours

Should be used only in Header rows. Type the estimated time (in hours) it will take to execute the test case. It could be either a floating number or an integer but must be greater than zero.




Step Number

Should be used only in Step rows. Successive steps within a single test case should be numbered sequentially.




Step Name

Should be used only in Step rows. Give each step a name.




Actions

Should be used only in Step rows. Input a single small step the tester should perform. Make it as clear and concise as possible.




Expected Result

Should be used only in Step rows. Input what the tester should see or experience when the instruction is performed. If the tester correctly encounters the expected result, then the test case step will pass. On the other hand, if the tester encounters an error or some other outcome, they’ll report this step as having failed.




Min Attachment Per Step

Should be used only in Step rows. Input an integer of how many required attachments the tester has to upload to the step.

Each step should appear on its own row. Your test case can have as many steps as it needs to completely describe the process you want to be tested.

Once you’ve completed writing your cases, save the file as .CSV.

How to Import Test Cases into the Platform

Contact your Applause management team if you need help with writing or importing test cases.




Steps to Import Test Cases into the Platform
  1. Select “Test Cases” from the left-hand navigation.

  2. Select “Import”.

  3. Product - Select the product for which you want to import test cases.

  4. Test Suite - Select a test suite if appropriate.

  5. Select a CSV File to Import - Upload the .CSV file you already created from the last section.

  6. Select “Import” and the test cases will be imported.