{"id":268,"date":"2016-09-21T15:49:43","date_gmt":"2016-09-21T03:49:43","guid":{"rendered":"http:\/\/help.psoda.com\/?page_id=268"},"modified":"2023-08-23T23:38:35","modified_gmt":"2023-08-23T23:38:35","slug":"a125","status":"publish","type":"page","link":"https:\/\/www.psoda.com\/help\/a125\/","title":{"rendered":"Import test cases form"},"content":{"rendered":"
This popup<\/a> form can be accessed via the \"CSV<\/a>import icon at the bottom of the Test cases<\/strong> tab at the \"Project<\/a>project or \"Subproject<\/a>sub-project view pages, as shown in Figure 1.\r\n\r\n\"import<\/a>\r\n

Figure 1 – Access via test cases tab<\/strong><\/p>\r\nThe import popup is shown in conjunction with each phase below, and can be used to import a number of test cases from a Comma Separated Values (CSV) file into the selected parent asset.\r\n\r\nCompleting the test cases \"CSV<\/a>import consists of a number of phases:\r\n

Phase 1 – Import file<\/h4>\r\n

\"import<\/a><\/h4>\r\n

Figure 2 – Import test cases form (1)<\/strong><\/p>\r\nThe first phase is to select file you want to import and some details about the file, using the browse option of the import file<\/strong> field. You can also set the delimiter<\/strong> used in the file, if the file includes a header row<\/strong> and test s<\/strong>teps <\/strong>and whether you want Psoda to match the entries in the file with existing test cases and update those<\/strong>.\r\n\r\nClick the Next<\/strong> button to move to the next step.\r\n

Phase 2 – Mapping<\/h4>\r\n

\"import<\/a><\/h4>\r\n

Figure 3 – Import test cases form (2)<\/strong><\/p>\r\nPhase 2 allows you to map<\/strong> or specify which columns from the import file should go into which fields of the new test cases. For example the Reference field allows you to select which column to import into the reference field. The Title field allows you to select the title column, and so on. If the column headers already match the field names then Psoda will automatically select those.\r\n\r\nIf you do not want to import a particular column from the file the just select the “Do not import<\/strong>” option from the list. You will be given an opportunity in the next step to specify default values for any fields you do not want to import.\r\n\r\nNOTE: The reference field must be unique for every test case in your asset so you cannot choose not to import the reference.\r\n\r\nSelect the Next<\/strong> button to move to the next step. If you have selected columns for all the fields then you will skip over the next phase (default values) and go straight to the last phase (results).\r\n

Phase 3 – Default values<\/h4>\r\nPhase 3 allows you to set default values for any fields you chose not to import from the file.\r\n\r\nThe fields may be the same as for creating a new test case<\/a>, but the fields present in this phase are very much dependent on which options you selected in phase 2.\r\n\r\nIf you have selected in phase 2 that the CSV file includes test steps, this phase will also include the test step fields such as the test step description <\/strong>and expected outcome<\/strong>.\r\n\r\nClick the Import test cases<\/strong> button to start importing the test cases.\r\n

Phase 4 – Results<\/h4>\r\nOnce the import is completed, click on the Next<\/strong> button to see the results.\r\n\r\nIf there were any failures while importing a table will by shown listing all of the failures including the line where the failure occurred, descriptions of the failures and the first 20 characters of the line to make it easier to identify.\r\n\r\nIf any test cases were successfully imported they will be listed in a table with links allowing you to easily view the new lessons.\r\n\r\nThe Import test cases<\/strong> form will remember the options that you selected for next time that you want to import more test cases.<\/div>\r\n

Related topics<\/h4>\r\n