Documentation - aqua cloud
🇬🇧 English
🇬🇧 English
  • 💻Web client
    • Getting started
    • General
      • Home page
      • App language
      • User account
      • Change password
      • Shortcuts & Accessibility
    • How to Contact Our Support
  • 👩‍🔧Administration
  • User administration
    • Adding and editing user profile
    • Roles and permissions
    • Assign, unassign or change licenses
      • Comparison of Licenses
    • Assign/unassign projects and roles
    • Licenses statistics
    • Statistics
  • Project configuration
    • [NEW] Project template configuration (fields)
      • Shared value sets
    • [OLD] Project template configuration (fields)
      • Shared value sets
      • Creating field groups
    • Field rules
    • [NEW] Workflow configuration
      • Global rules
      • Status and transitions
    • [OLD] Workflow configuration
    • Additional project settings
    • Project integrations
    • System log
    • Email notifications
      • Project default notifications
      • My notifications
      • Configuration of the project notification templates
      • Troubleshooting
  • Projects and folders
    • Project wizard
    • Projects
      • Export project
      • Import project
        • Migration from Testrail
      • Archive project
    • Folders
      • Export project folder
      • Import project folder
  • 🧩Modules
  • Navigation page
    • Project tree
    • Items grid
    • Filtering and grouping
    • Views
    • Search
    • Preview item details
  • Items
    • Requirements management
      • Requirements
      • Subrequirements
      • Requirements coverage
    • Test cases management
      • Test cases
      • Nested test cases (shared test cases/steps)
      • Manual testing
      • Test data or Variables manager
      • Test environment tracking with labels (tags)
      • Test execution results
      • Test automation
      • Capture: Test recorder/bug reporter
      • Test it: easy way to start run
      • Quick run: test execution of multiple test cases at once
    • Test scenarios management
      • Test scenarios
      • Adding test cases to a test scenario
      • Executing test scenarios
    • Defects management
      • Defects
      • Creating a defect from a test execution
      • Review found or linked defects to the test execution
      • Creating a defect with Capture
    • General item capabilities
      • Creating and Editing Items
      • Copy item to a target project or duplicate within a project
      • Taking over field values between items
      • Item template (defaults)
      • Dependencies
      • Add links to a description
      • Take screenshots
      • Watch item and notify other users
      • Attachments (files)
      • History of changes
      • Discussions (comments)
      • Print item data
  • Reporting
    • Creating a new report template
    • Basic report elements
    • Element tree structure
    • Element properties
    • Diagrams
    • Pivot table
    • 'Sum' function
    • Creating custom report script
    • Parametrization of reports
    • Exclude empty items from a report
    • Adding table of contents to a report
    • How to filter executions based on custom added fields?
  • Dashboards
    • Creating a dashbord
    • Publishing the dashboard
    • Creating a chart
    • KPI alerts
    • Drilldown to details from a chart
    • Burndown chart template
  • Agile
    • Backlog
    • Sprint board
    • Preview
  • 🖥️Desktop client
    • Getting started
      • Important notice: Deprecation of the desktop client in June 2025 [updated]
      • FAQ: Transitioning from the desktop client to the web Client
      • Desktop installation
      • Home screen configuration
      • Views
      • Grid
    • Agile board
      • Burn Down Chart
    • Dashboard
    • User Administration
      • Adding and managing users
      • Roles and permissions
      • Assigning licenses projects and roles
      • Statistics
    • Project configuration
      • Configuration of Fields and Workflows
      • Email Notification
      • Change company logo in printout
      • Import Project Configuration
    • Import / Export Wizard
    • Project Planner
      • Creating and editing a new project plan
      • Adding and syncing items to project plan
      • Resource planning
      • Gates and Stages
    • Requirements Management
      • Dependency
      • Subrequirements
      • Mind map
      • Comments
      • Documents
    • Test Management
      • Step Designer
      • Test Execution
        • Autosave of a test execution
      • Variable Manager
      • Nested Testcases
      • Disable manual test execution time
    • Test Scenarios
      • Test Scenarios
      • Scheduled Executions of Test Scenarios
      • Run Dependency
    • Defect Management
    • Reporting
      • Creating a Report
      • Creating a new report template
      • The Report Wizard
      • Basic Report Elements
      • Element tree structure
      • Element Properties
      • Diagrams
      • Pivot Table
      • Sum Function
      • Script Development
      • Parametrization
      • Performance Improvements for Report Creation
      • Remove empty elements
      • Table of Contents
      • Invalid References
    • Agile Board
      • Configuring the Agile Component
      • Planning board
      • Scrum board
      • Burn Down Chart
    • Versioning
  • 💿Installation for on premise
    • System Requirements
      • Server
      • Desktop Client
      • Web Client
      • Agents
    • Server Installation
    • Server parameters
    • Web Client Installation
    • Getting Agents
    • Connection to MSSQL Database
    • Connection to Oracle Database 12.2c
    • Licenses
    • Monitoring
    • SSL-Configuration
    • Content Security Policy (CSP) Settings
  • 🪄AI Copilot
    • Transform your testing and project management with aqua's AI Copilot
    • Enable and manage AI Copilot options
    • Create documents with ease with AI Copilot
    • AI Copilot: generate a comprehensive description for the test cases in just one click
    • AI Copilot - create test cases out of requirements or based on context in seconds
      • Create test cases from the navigation page
      • Create test cases from a requirement
      • Create a test case from a test case page
    • Generate test data with AI Copilot
    • Generate test case based on a file
    • Generate test cases in BDD format
    • Generate test cases with AI Copilot using test design techniques
    • Create user stories, BDDs, or PRDs based on a file
    • Create multiple user stories or BDDs with AI Copilot
    • Split or convert requirements
    • AI Copilot chat
  • 🔗Integrations
    • Jira sync: synchronize items between aqua and Jira projects
      • Before you begin: key steps for synchronization
      • Sync configurator set up
        • Sync Configurator options
      • Log in to the Sync Configurator
      • Sync of the projects between aqua and Jira
      • Fields mapping
        • Supported default Jira fields
        • General aqua and Jira fields compatibility
        • Special compatibility for aqua and Jira fields
      • Additional settings
        • Allow mapping of only selected values and ignore other field values for the sync
        • Automatic creation and mapping of field values
      • Troubleshooting
      • Synchronisaton of subtasks with aqua
      • Formatting support
    • Azure Devops sync
    • Jira link: create and/or link Jira issues to aqua tickets
    • aqua4Jira plugin: Cover Jira issue with aqua test cases
      • Installation of the plugin
        • aqua4Jira Plugin - Now Compatible with Jira Data Center!
      • Configuration in Jira
      • Configuration in aqua
    • Automatic display of test cases or test scenarios in Jira tickets
    • Confluence integration
    • Capture: record tests or create comprehensive bug reports
    • Testlink: importer tool for migrating test cases to aqua
    • SSO
      • LDAP
      • SAML Configuration
        • Installation
        • Sample
  • 🌀Automation
    • Desktop Client
      • Creating an Automation Agent
      • Configure Automation
      • Ranorex
      • UFT
      • JMeter
      • SoapUI
      • Database
      • UnixShell
      • PowerShell
      • Automation Library
    • Web Client
      • Automation Agent
        • Creation & Configuration
        • Agent pools
        • Running task
      • Powershell
      • Unix Shell
      • Jenkins integration
      • Selenium
    • REST API
    • Automation: CI/CD tools and aqua REST API
      • Gitlab CI/CD: JAVA/Playwright
      • Gitlab CI/CD: TypeScript/Cypress
      • Gitlab CI/CD: TypeScript/Playwright
      • Gitlab CI/CD: TypeScript/Cypress/Cucumber
  • 🚀Product updates for on premise customers
    • Product updates
      • 25.56.0 - On Premise
      • 25.52.0 - On Premise
      • 25.47.0 - On Premise
      • 25.36.0 - On Premise
      • 25.31.0 - On Premise
      • 25.18.0 - On premise
      • 25.10.0 - On Premise
      • 24.135.0 - On Premise
      • 24.130.0 - On Premise
      • 24.126.0 - On Premise
      • 24.108.0 - On Premise
      • 24.101.0 - On Premise
      • 24.93.0 - On Premise
      • 24.83.0 - On Premise
      • 24.71.0 - On Premise
      • 24.53.0 - On Premise
      • 24.8.0 - On Premise
      • 23.140 - On Premise
      • 23.126.0 - On Premise
      • 23.102.0 - On Premise
      • 23.70.0 - On Premise
      • 23.22.0 - On Premise
      • 22.132.0 - On Premise
      • 22.123.0 - On Premise
    • Release Notes
      • 25.56.0 - On premise
      • 25.52.0 - On premise
      • 25.47.0 - On Premise
      • 25.36.0 - On Premise
      • 25.31.0 and 25.33.0 - On Premise
      • 25.26.0 - On Premise
      • 25.18.0 - On Premise
      • 25.10.0 - On Premise
      • 24.135.0 - On Premise
      • 24.130.0 - On Premise
      • 24.126.0 - On Premise
      • 24.114.0 - On Premise
      • 24.108.0 - On Premise
      • 24.101.0 - On Premise
      • 24.93.0 - On Premise
      • 24.83.0 - On Premise
      • 24.71.0 - On Premise
      • 24.53.0 - On Premise
      • 24.8.0 - On Premise
      • 23.140.0 - On Premise
      • 23.126.0 - On Premise
      • 23.102.0 - On Premise
      • 23.70.0 - On Premise
      • 23.22.0 - On Premise
      • 22.132.0 - On Premise
      • 22.123.0 - On Premise
  • 🚀Product updates for public and private clouds customers
    • Product updates
      • 25.56.0 - public and private cloud
      • 25.52.0 - public and private cloud
      • 25.47.0 - public and private cloud
      • 25.36.0 - public and private cloud
      • 25.33.0 - public and private cloud
      • 25.18.0 - public and private cloud
      • 25.10.0 - public and private cloud
      • 24.135 - public and private clouds
      • 24.130 - public and private clouds
      • 24.126.0 - public and private clouds
      • 24.108.0 - public and private clouds
      • 24.101.0 - public and private clouds
      • 24.93.0 - public and private clouds
      • 24.88.0 - public and private clouds
      • 24.83.0 - public and private clouds
      • 24.71.0 - public and private clouds
      • 24.63.0 - public and private clouds
      • 24.50.0 - public and private clouds
      • 24.33.0 - public and private clouds
      • 24.8.0 - public and private clouds
      • 23.140 - public and private clouds
      • 23.126.0 - public and private clouds
      • 23.107.0 - public and private clouds
      • 23.92.0 - public and private clouds
      • 23.70.0 - public and private clouds
      • 23.46.0 - public and private clouds 1/3
      • 23.46.0 - public and private clouds 2/3
      • 23.46.0 - public and private clouds 3/3
      • 23.22.0 - public and private clouds
      • 22.132.0 - public and private clouds
    • Release notes
      • 25.56.0 - public and private cloud
      • 25.52.0 - public and private cloud
      • 25.47.0 - public and private cloud
      • 25.36.0 - public and private cloud
      • 25.33.0 - public and private cloud
      • 25.31.0 - public and private cloud
      • 25.24.0 - public and private cloud
      • 25.18.0 - public and private cloud
      • 25.10.0 - public and private cloud
      • 24.135.0 - public and private clouds
      • 24.130 - public and private clouds
      • 24.126.0 - public and private clouds
      • 24.114.0 - public and private clouds
      • 24.108.0 - public and private clouds
      • 24.101.0 - public and private clouds
      • 24.93.0 - public and private clouds
      • 24.88.0 - public and private clouds
      • 24.83.0 - public and private clouds
      • 24.71.0 - public and private clouds
      • 24.63.0 - public and private clouds
      • 24.50.0 - public and private clouds
      • 24.33.0 - public and private clouds
      • 24.8.0 - public and private clouds
      • 23.140.0 - public and private clouds
      • 23.126.0 - public and private clouds
      • 23.107.0 - public and private clouds
      • 23.92.0 - public and private clouds
      • 23.70.0 - public and private clouds
      • 23.46.0 - public and private clouds
      • 23.22.0 - public and private clouds
      • 22.132.0 - public and private clouds
      • 22.123.0 - public and private clouds
    • 📢AQUA NEWS
      • Upcoming new storage options for On-premise deployments
      • 🔒 Rate Limits for Public Cloud Users
      • Preview of aqua's public API
      • aqua is now ISO 27001 certified and DORA Compliant
      • Upcoming changes to aqua API
      • AI Copilot launching for All public clouds users on January 27th!
  • 📹Capture
    • What is Capture?
    • Chrome extension installation
    • Capturing in Incognito mode
    • Using Capture with Edge
    • Capturing with video
      • Option to enable mic when capturing a screen and adding voice notes
      • Option to pause/resume while capturing the video
        • Masking sensitive information while capturing
    • Capturing with screenshot
    • Running a test execution
    • Last minute session replay
    • Masked inputs while creating captures
Powered by GitBook
On this page

Was this helpful?

  1. Projects and folders
  2. Projects

Import project

PreviousExport projectNextMigration from Testrail

Last updated 18 hours ago

Was this helpful?

From the context menu of a project or folder, you can import items from an Excel file directly into the selected project or folder.

In the Import dialogue box, you can first download a sample file in the appropriate format for the selected project. You can then specify which items you wish to import. A worksheet is then created in Excel for each item type, into which you can insert the data you wish to import.

Note: If you select Test Scenarios only, a Test Cases worksheet will be added to the sample file because importing test scenarios always requires importing the corresponding test cases at the same time. You can then replace the sample data in all worksheets in the sample file with the data you want to import.

Attention: please replace/delete all sample data in all tabs of the Excel file before import, otherwise this data will be imported as well. The items from the sample data will always have the name "string", which allows you to filter and delete them in the navigation item browser if they have been imported by mistake.

You can then simply drag the customised sample file into the grey area of the Import dialogue box, or browse and select it by clicking on the area. Using the 'Ignore invalid rows' checkbox will specify that all valid items in your file should be imported and invalid ones ignored. If the checkbox is not selected, the import will stop without importing anything if any of the content is incorrect.

Important import notes:

All item types:

  • The ID column must always be present and must have a unique value for each item in the import file

  • Please note that the ID is not imported into aqua and is only used to uniquely identify the items in the Excel file. Each item in aqua will be given a unique aqua ID in the usual format.

  • The format of the ID does not necessarily have to be the same as the ID format in aqua (e.g. TC000123), it can be simply incremented across all items in the import file.

  • Dependencies can be entered in the Dependencies column and always refer only to the IDs of items from the import file

  • If there is more than one dependency, the IDs must be separated by semicolons

  • For multi-select fields, the following format must be used: "Value1; Value2; Value3" (Important: always insert a space before the next value after the semicolon)

  • For user fields, such as "Assigned to", you must use the following format: "Last name, first name" or "email-address". If there is more than one user with the same first and last name, either add the username in parentheses ("Last name, first name (username)") or use the email address.

Requirements:

  • In the Hierarchy column, you can specify the hierarchy between requirements and sub-requirements by specifying the IDs of the parent requirements from the import file in the following structure: "Requirement/Subrequirement/Subrequirement" (for example, RQ1/RQ2 in the Hierarchy column of the requirement with ID RQ2 and RQ1/RQ2/RQ3 in the Hierarchy column of the requirement with ID RQ3)

Defects:

  • Defects can contain multiple description fields, notes, solutions etc., which are called enclosures. These must each be in a separate row in the import file and are assigned to the correct defect via the ID (i.e. all enclosures for the same defect must have the same value in the ID column)

  • In the column "Type (enclosure)" the type of enclosure must be entered. The following can be entered here: "Description" (for a description), "Note" (for a note), "ReplicationProcedure" (for a replication procedure) and "Resolution" (for a resolution)

  • In the column "Create date (enclosure)" you should enter the creation date of the enclosure

  • In the "Editor (enclosure)" column you should enter the creator of the enclosure as follows: "Last name, first name" or "email-address". If there is more than one user with the same first and last name, either add the user's name in brackets ("Last name, first name (user name)") or use the email address.

  • In the "Text (enclosure)" column, enter the content of the attachment.

Test Cases:

  • For test cases, each test step must be in a separate row in the import file and must be assigned to the correct test case by its ID (i.e. all test steps for the same test case must have the same value in the ID column).

  • In the column Name "(test step)" the name of the test step can be entered

  • In the column "Instructions (test step)" the instruction of the test step can be entered

  • In the column "Expected Results (test step)" the expected result of the test step can be entered

  • In the column "Type (test step)" the test step type can be specified. "Condition" for a condition and "Step" for a step

Test Scenarios:

  • Test scenarios must always be imported together with the test cases that you want to include in the scenarios

  • For each test case within a test scenario, a row with the same value in the ID column must be added to the test scenario tab in order to assign them to the same test scenario. In the column "Test case ID (test case)" the ID matching the desired test case from the test case tab should be entered

  • In the column "Tested version (test case)" the tested version within the test scenario can optionally be entered

  • In the column "Tester (test case)" you can optionally enter the tester within the scenario as follows: "Last name, first name" or "Email address". If there is more than one user with the same first and last name, either the username must be entered in parentheses ("Last name, First name (username)") or the email address must be used.

  • All other columns which refer to the scenario, e.g. the scenario name, are only allowed in the first row for each scenario and must be empty for all other entries (i.e. the other test cases in the scenario)

Limitations:

  • Value sets for test cases cannot be imported

  • Embedded test cases cannot be imported

  • Discussions cannot be imported

Import of Zip Files

If you also want to import attachments or formatted description texts that contain for example pictures, you can do this by importing a zip file. Please note the following when importing a Zip file: All item types:

  • For each item in the Excel file for which you want to import an attachment and/or formatted text, the zip file must contain a folder with the item's ID as the folder name,

  • The attachments must be saved in the folder for that item, and in the Excel file, all attachments must be listed in a column called "Attachments", separated by a semicolon, including the file extensions (e.g, ExampleExcelAttachment.xls;ExampleTextAttachment.txt;ExamplePictureAttachment.png"),

  • The formatted descriptions must be saved in rich text format in the same folder as the item,

  • The filename of the formatted description must have the format "ItemID.Description.rtf", where ItemID must be replaced with the ID of the item for which the description is to be imported.

Test Cases:

  • The formatted descriptions and expected results of the test steps must be stored in the folder for the respective test case in rich text format

  • The file name of the formatted text for the step description must have the format "TestCaseID.TestStep.001.Description.rtf", where TestCaseID must be replaced by the respective ID of the test case and TestCaseID must contain the correct step number

  • The file name of the formatted text for the expected result must have the format "TestCaseID.TestStep.001.ExpectedResult.rtf", where TestCaseID must be replaced by the respective test-case ID and TestStep.001 must contain the correct step number

  • For conditions only the step description is needed, i.e. "TestCaseID.TestStep.001.Description.rtf

Defects:

  • The formatted text of the enclosures (descriptions, notes, solutions etc.) must be saved in rich text format in the folder for the relevant defect.

  • The file name of the formatted text for the enclosures must have the format "DefectID.Enclosure.001.rtf", where DefectID must be replaced by the respective ID of the defect and Enclosure001 must be incremented over all enclosures

It is recommended that a sample is made first to better understand the exact format of the zip file to be imported. Exports can also be customised, re-zipped and re-imported into the same project or into other projects or environments. However, the import process always creates new items and does not update the previous items. When importing a zip file from another project, you should ensure that all fields to be imported are also present in the new project and have the same name or contain the same selection values. It is recommended that you use the same to avoid incompatibilities.

export
project configuration
How to navigate to the Import module within the context menu