Our documentation site has been updated to AIO Tests Knowledge Base

Execute Cycle Offline

In order to further enhance the cycle execution usability for users, AIO Tests now offers bulk update step results and other artifacts of execution results through Excel. This not only adds another view to the cycle execution results but will also help users transitioning from Excel to quickly report results. This feature can also be helpful in distributing cases for execution to testers who do not have access to Jira. This article shows how to use Execute Offline feature in AIO Tests.

Offline execution for a cycle can be initiated from the Cycle Details page as shown below and it is a 2-step process (export and then import). The sections below discuss the 2 step process in detail.

 

 

Click ‘Execute Offline’ from the top-right ellipsis of the Cycle details page.

 

Export Cycle Run Data

The first step is to export the existing cases and runs data from AIO Tests as an excel by selecting the ‘Export Cycle Run Data’ option.

Once you click on Confirm, an Excel Download begins. Below is a sample Cycle export excel from AIO Tests.

 

The export has 18 columns along with an instruction sheet. The below table describes each of them along with possible actions on each column

Column

Details

Column

Details

Key, Title, Preconditions

Case details for the exported cases

 

Users should not delete or edit the key else it will error out on import. Edits done to title and preconditions will not carry over on import

Run Status/Step Status

Choose from available status options - Not Run, In Progress, Blocked, Passed, Failed

Existing Run Comment/Step comment

Already added comments are visible. It’s a read-only value

Run Comment/Step comment

Comment to be added to run/step

 

Text in Run row would be added as single comment to run

 

Text in Step row would be added as single comment to step

Run Defects/Step Defects

Comma separated values of defect keys from Jira

 

Existing defects, if removed, will be removed from run/step

Actual Effort

Actual effort to be logged in minutes

Order/Steps/Data/Expected Result

Case steps and related details

 

Any changes to details will not carry over on import

Actual Result

Actual result specified would be added to actual result of step

Run ID

Run id of each run from AIO Tests

 

Do not change

Step ID

Step id of each step from AIO Tests

 

Do not change 

General

If a case is removed from file being imported, case will not be removed from cycle.

 

If a step is removed from a case run in file being imported, no changes will be made to step in the run on import.

Import Offline Execution Results

Once you are done updating the excel, the next step is to import the excel into AIO Tests. Go to the cycle from which export was taken and click on Execute Offline again.

This time choose ‘Import Offline execution results’ radio button to get the screen shown below.

Attach the updated excel using “browse to upload file” option. If you want to record the results from excel as a new run, click the checkbox in the modal and then click Confirm. If new run check-box is selected, all the updates from Excel will be recorded for the newly created run. Users will get a success modal like the one shown below.

 

Key points

  • While importing actual effort, the decimals are ignored if specified. e.g. 57.6 minutes will be imported as 57 minutes

  • The status is captured at level it is specified. It doesn’t percolate down or up. e.g. all steps are marked as Passed in Step Status column and no update is made in the Run Status column, then Run Status will stay as in (marking steps as passed won’t automatically percolate up to run being marked as Passed)

Troubleshooting Errors

There are some standard errors that can be seen for particular situations. The explanation and remedies are listed below

Displayed Error/Warning

Description

Fix

Displayed Error/Warning

Description

Fix

Warning: Case key was not found (reported against Run ID)

Case key was changed from the imported Excel

No change required as all other data will be updated

Warning: Case key was not found (reported against Row ID)

Case key was deleted/removed from the imported Excel

No change required as all other data will be updated

Error: Invalid format for run id

Run ID provided is incorrect

From AIO Tests, filter the case which failed and export the case run data and reimport

Error: Step ID(s) not found: <step ID>. Please export latest run data

Step ID provided is incorrect

From AIO Tests, filter the case which failed and export the case run data and reimport

Error: New run with a new version of the case has been added to cycle. Please export latest run data

After exporting, another user created a new run in AIO Tests using a newer version of the case

From AIO Tests, filter the case which failed and export the case run data and reimport

Error: Step id not found in case: <step ID>. Referenced case may have changed

After exporting, one of the linked cases has changed

From AIO Tests, filter the case which failed. Add a new run. Then, export the case run data and reimport

Warning: Actual effort not updated. Please specify positive value for effort

Actual effort provided is a negative value

Fix the value and reimport to same run

Warning: Actual effort not updated. Please specify effort in minutes

Actual effort is not in correct format (needs to be specified in minutes)

Fix the value and reimport to same run

Warning: Run/Step defects not found : <not found ids>

Defect ID provided is incorrect

Fix the value and reimport to same run