Course 4: How to Import Test Cases
Learn how to import test cases into the Applause platform.
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.
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.
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 you want for the test case.
Should be used only in Header rows. Type the description you want 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. 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.
Contact your Applause management team if you need help with writing or importing test cases.
Select “Test Cases” from the left-hand navigation.
Product - Select the product for which you want to import test cases.
Test Suite - Select a test suite if appropriate.
Select a CSV File to Import - Upload the .CSV file you already created from the last section.
Select “Import” and the test cases will be imported.