Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

AIO Tests allows you to import existing manual test cases from your system where you have created and saved the Excel Excel or CSV file with the click of a button. Once you import the test case files, all data from the uploaded file will get copied over to AIO fields, including traceability (requirements) mapping. By importing XLS/CSVyour existing cases, you can start working on AIO Tests readily without having to manually create a case on the test management toolre-create your current cases.

Info

The uploaded file size should not be more than 100 MB.

In this documentation, you’ll understand:

Table of Contents

Steps to Import

...

Excel/CSV

Step 1: To import XLSa Excel/CSV file, simply click on the Cases option in the top bar menu.

...

Step 2: On the Cases tab, click on the Import Cases button.

...

Step 3: On the import cases page, you will get 3 tabs on the Import Cases view- File, Other Projects, and Jobs. On the File page, click on the “Browse to upload file” button under the Classic & BDD box to import a .csv/Excel file.

Sample .xlsx

View file
nameAIO Tests Sample Excel.xlsx

Info
  • The first row in the user’s .csv or Excel file is considered as a header row by the system.

  • The Existing Case ID and Title are mandatory fields that need to be mapped.

  • The sample .csv and Excel files provided are for ease of use and not a mandatory format. User can map their own fields to AIO Tests fields.

...

Step 4: Once you upload a file, the Field Mapping section will appear on the screen. Click on the Select Data Mapping buttonUsers can map the fields in the input file to the fields available in AIO Tests

Info
  • The Field Mapping section takes the headers from the uploaded file and maps it to the AIO Tests fields automatically, if similar field names are found

  • Users have the option to update the mappings as per their requirements. 

  • Users can map the field manually by clicking on the “Reset Mapping” option located at the bottom of the page.

  • If users changed a few mappings and would like to see what AIO Tests auto-mapped, they can click on “Re-Initialize Mapping”. 

...

Info

To use a parameter in a step, it needs to be enclosed within angular brackets as shown below:

...

Once you click Step 5: Click on the Select Data Mapping button , to see the Data Mapping screen will be displayed. It maps data provided in the file to values available in AIO Tests and Jira. 

The Source Field Values in data mapping are unique values available in the source file and the AIO Tests Target Field values are the values for the respective fields available in AIO Tests. E.g. The source file can have priorities defined as Highest, High, Medium and Low. AIO Tests however offers Critical, High, Medium, Low and Lowest. Users have the option to map their source field values with AIO Tests field values. 

The below screenshot shows the Highest from the source file mapped to Critical in AIO Tests. If a value (for status, types, priorities and custom fields) isn’t mapped, but the same name value is found in the project being imported to, in AIO Tests, it will automatically be assigned once the import process finishes.

...

  • Default Status: Select the Default Status for newly created cases from the Status drop-down menu.

...

Step 56: Once data mapping is finalized, click on the Start Import button. 

...

Once you click on the Start Import button, you will be redirected to the Jobs section and a success message will be displayed on the screen stating “Batch <batch #> created successfully”.

...

Upon clicking the down-carat icon next to the Created Date, the result of the batch processing will be displayed on the screen, whether the import actually succeeded or not.

...

How to Import Custom Fields 

AIO Tests allows the users to import more fields as per their requirements other than the fields available in AIO Tests by letting them create custom fields on AIO Tests. To know the steps to create custom fields in AIO Tests, click here

...

Info
  • For Single-select lists and Multi-select lists type of custom fields, users can import a maximum of 50 list options.

  • For importing date fields, users will need to ensure they follow the supported date formats (see below for the list).

  • User type fields (single-user and multi-user) will not be imported. Users will need to use the Bulk edit of case details feature to update such fields.

Supported Date Formats for Custom Fields

8-Jun-20

8-Jun-2020

Jun 8, 2020

Jun 8, 20

Jun-8, 20

Jun-8, 2020

8-Jun, 20

8-Jun, 2020

8 Jun 2020

8 Jun 20

8/Jun/2020

8/Jun/20

2020-Jun-8

2020 Jun 8

2020/Jun/8

Jun 8 2020

Jun 8 20

June 8, 2020

June 8, 20

8-June-2020

8-June-20

8 June 2020

8 June 20

June-8, 2020

June-8, 20

8-June, 20

8-June, 2020

2020/June/8

2020-June-8

8/June/2020

8/June/20

2020 June 8

Jun-8-2020

Jun-8-20

June-8-20

June-8-2020

Missing Data Impact

If some data is found missing or empty while importing/mapping the file, the file will fail to import with an error. Below is a list of a few common errors.

...