Course 4: How to Import Test Cases

Learn how to import test cases into the Applause platform.

How to Import Test Cases

In addition to creating new test cases in the platform as we described in the previous course, test cases can also be created offline in Excel and imported into the Applause platform. Alternatively, test cases from the TestRail system can be exported; more on that in the next courses.

How to Create an Import File

First, begin by downloading and opening the Excel/CSV template, and each of the columns in the test case file will be described below.

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 for the test case.




Description

Should be used only in Header rows. Type the description 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. The test case can have as many steps as it needs to completely describe the desired process.

After completing the test case writing, save the file as .CSV.

How to Import Test Cases into the Platform

Contact the Applause management team if assistance is needed with writing or importing test cases.




Steps to Import Test Cases into the Platform
  1. Open the Test Suites & Cases tab and choose the relevant product.

  2. From the All Test Cases tab click the import button on the top right corner.

  3. Select “Import from CSV”.

  4. In the popup dialog, upload the .CSV file you already created from the last section.

  5. Target Product - Select the product for the test cases.

  6. Test Suite - Select a test suite if needed.

  7. Click “Import Test Cases” and the test cases will be imported.

TC Import