Course 4: How to Import Test Cases
Learn how to import test cases into the Applause platform.
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.
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.
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
Should be used only in Header rows. Type the name for the test case.
Should be used only in Header rows. Type the description for the test case.
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.
Should be used only in Step rows. Successive steps within a single test case should be numbered sequentially.
Should be used only in Step rows. Give each step a name.
Should be used only in Step rows. Input a single small step the tester should perform. Make it as clear and concise as possible.
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.
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.
Contact the Applause management team if assistance is needed with writing or importing test cases.
Open the Test Suites & Cases tab and choose the relevant product.
From the All Test Cases tab click the import button on the top right corner.
Select “Import from CSV”.
In the popup dialog, upload the .CSV file you already created from the last section.
Target Product - Select the product for the test cases.
Test Suite - Select a test suite if needed.
Click “Import Test Cases” and the test cases will be imported.