Test Cases Scenario for Uploading Csv Files by User

TestRail - Import TestCases CSV

---

User can create multiple test-cases at a time using CSV or XML file. CSV files are comma separated text files. In that location are 2 steps processes require to import the data from excel.

• Rules for CSV file
• Import the file into organisation

Rules for CSV file

While creating CSV file following point must be considered

• CSV file should have data in the first sheet but.

• 1^st row should accept headers name in different columns and next onwards data should represent each column.

• Please annotation, 1^st row will exist mapped with dissimilar fields of Test Case Forms while importing.

• 1 cavalcade in excel file tin exist mapped with only 1 field in test case class.

• Required fields must be mapped with column of CSV sheet and it shouldn't be blank. Otherwise, system will generate error message of unsuccessful import.

• Non-Required fields tin be left without mapping or data tin exist blank. While importing either these fields volition exist bare or default values as defined in project's settings.

Import CSV file

• Get to Test Cases tab.

• Click at import test cases icon at right side and select Import from CSV selection. Following screenshot shows Import test cases icon and CSV selection

• Import from CSV Magician opens. Information technology has 4 steps process.

• In the 1^st step, scan the CSV file and upload. After successful upload, filename displays in magician.

• In the Format & Mapping section, select Configure new mapping for the ane^st file. User tin use the aforementioned configuration from next time after downloading configuration file. To apply this option select Load mapping from configuration file.

• Following choice should be made in Advanced Option section

  • Import − to Select the section where test cases should be imported

  • File Encoding − It is used t select the encoding rules of file so that TestRail can decode file properly. The file encoding of the CSV file, Excel/Windows uses Windows-1252 (Latin) for CSV files whereas most other tools (including Google Spreadsheets) prefer the Unicode-compatible UTF-8 encoding.

  • CSV Delimiter − User can define , or ; or \t to separate fields.

  • Offset Row − User tin can separate header row and data row from where starts. And, IS header row or not can be decided using checkbox.

  • Template − User can choose whether information technology is consummate examination case or steps or exploratory session.

• After these choice, click on Next button. Following screenshot shows ane^st step of import test cases procedure

• User tin can but map CSV columns to TestRail's test case fields. TestRail likewise supports importing split examination steps and expected results if user uses multiple rows for a unmarried test example. This is called as column mapping and can be configured on pace two of the CSV import wizard.

• TestRail differentiates single and multi-row case layouts for CSV files. In a unmarried-row layout, every examination instance is represented by a single row or record in the CSV file. This is the standard layout for most CSV files.

• TestRail supports multi-row layout. User selects the cavalcade which detects the start of a new test instance in this example (for example, an ID or Name/Title column which is unique per exam instance). This layout is normally used for test cases with multiple steps and expected results.

• At the final there is a checkbox whether TestRail should ignore CSV rows/records without a valid, not-empty title column. It is recommended to cheque the checkbox to filter empty rows at the first/between test cases/finish of the CSV file.

• Now, click on Next push button. Post-obit screenshot displays 2^nd step of Import test case process

• This step is to map the CSV values to TestRail. For example, if user has a priority value of Medium in CSV file, this footstep allows to map this to a priority of Depression or Normal in TestRail. In this step, user tin can check the checkbox to avoid whatever HTML tags as imported data.

• After that click on Next button. Following screenshot displays three^rd step of Import test cases process

• In the 4^thursday step, user can review the examination cases that TestRail establish in the CSV file. User can review the file options also as column & value mappings those are configured on the previous steps. User can go back and forth with the Previous and Next buttons to make changes to the file options, column or value mappings. Once user is satisfied with the preview, click the Import button.

• The last wizard step shows number of imported sections & exam cases. It allows to download a configuration file. This file tin can be loaded on the beginning sorcerer step and automatically pre-configures all wizard steps and import options. This is useful when multiple CSV files would exist imported with a aforementioned layout. User can share this configuration file with other squad members as well.

upchurchmagas2000.blogspot.com

Source: https://www.tutorialspoint.com/testrail/testrail_import_testcases_csv.htm

Share this post