Execute Offline

AIO Tests allows users to bulk update step results and other artifacts of execution results through Excel to enhance the cycle execution usability for users. By executing Cycles offline, you can not only add another view to the cycle execution results but also help users transition 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.

In this documentation, you’ll understand:

Steps to Export Cycle Run Data

Step 1: To export cycle run data, simply click on the Cycles option in the top bar menu.

Step 2: On the Cycles page, right-click on the cycle that you want to execute offline and hit the Execute Offline option from the drop-down menu.

Users can also export cycles offline from the Cycle detail page.

image-20241029-113527.png

Step 3: Once you click on the Execute Offline option, the Execute Offline modal window will appear on the screen. Tick the Export Cycle Run Data radio button and hit the Confirm button. 

Once you click on the Confirm button, an Excel file will be downloaded. Below is a sample Cycle Export Excel file 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

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 the Run row would be added as a single comment to run

 

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

Run Defects/Step Defects

Comma-separated values of defect keys from Jira

 

Existing defects, if removed, will be removed from the 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 to import

Actual Result

The actual result specified would be added to the actual result of the 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 the file being imported, the case will not be removed from the cycle.

 

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

Steps to Import Offline Execution Results

Step 1: To import offline execution results, all you need to do is click on the Cycles option in the top bar menu.

Step 2: On the Cycles page, right-click on the cycle that you want to import offline and hit the Execute Offline option from the drop-down menu.

Users can also import offline execution from the Cycle detail page.

Step 3: Once you click on the Export Offline option, the Execute Offline modal window will appear on the screen. Tick the Import offline execution results radio button. Click on the Browse to Upload File option to attach the updated Excel file and hit the Confirm button. 

If you want to record the results from Excel as a new run, click the checkbox Create new run for results in the modal. If the new run checkbox is selected, all the updates from Excel will be recorded for the newly created run.

Once you click on the Confirm button, a success modal will appear on the screen.

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

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

Case key was changed from the imported Excel

No change is 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 is 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 the 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 the cycle. Please export the 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>. The 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 the positive value for effort

Actual effort provided is a negative value

Fix the value and reimport to the same run

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

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

Fix the value and reimport to the same run

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

Defect ID provided is incorrect

Fix the value and reimport to the same run

For further queries and suggestions, feel free to reach out to our customer support service via help@aiotests.com