Import / Export Wizard (Rich Client)

Import / Export Wizard (Rich Client)

In aqua, you have the option to import and export aqua items from and into Excel and CSV documents. You should use an aqua Administrator in order to have the full rights on the project, requirements, test cases, test scenarios, and defects.
 

Export

In order to export your aqua project items (requirements, test cases, test scenarios and defects) to an Excel or CSV document, you have to open aqua and be an aqua Administrator with full rights.
 
Select your project and click on Export.
 
 
A new dialog appears, where you can select which items should be executed.
 
 
In Export Settings, you can choose existing pre-configured export settings. The Setting name defines which name the setting should have, in case you would like to reuse it. In File type you can choose Excel 2003 or CSV, which are supported now. In the next step, the export language is chosen defining the language of the exported file. You can define which item types should be exported now. You need to activate them in order to export them. If you want to export all information stored in word files, for example, activate the checkbox Export RTF data. Otherwise, all fields will be exported as text fields, which can be readable out of the box. The export header contains optional export information and can also be used when importing the file to automatically recognize the language information.
 
 
If you activated some item types, you can define which fields should be exported by clicking on Field Selector.
 
 
To include all fields in the export check Include all fields or else specify individual fields in Available fields by clicking on Add.
 
Once everything is configured, you can click on the Save button to save the configuration.
Click on Export to start exporting your aqua project into a file.
 

Import Assistant

For beginners, working with the Import Assistant can sometimes prove difficult. Find out if your existing mapping works for your business before importing all data. Start the Import Assistant and click on Next.
 
 
Select a file for import, this can be an Excel or CSV Document, and click on Next.
 
 
If the file does not contain a header with language information (these can be added to the export by checking the box "Include header in the exported file"), a message will be displayed that the file does not contain any culture info and ask you whether you want continue anyway. Here you simply click on Yes.

 
In the next window you can create a new setting or select an existing import setting which was previously saved during an export. In this example, we are creating a New setting.
 
 
Define which items you want to import. In our example, we will merely import test cases.
 
 
If there is no header with language information in the file, select a language and click Next. If the header with language information is present, the language is automatically selected. In this case, however, you must also select the 4th row under "Start on row" so that it starts after the header.

In the next window there are options to map your data in a source file with the configuration of an aqua project.
 
 
To specify your test steps in Test cases, import Name (test step), Instructions (test step), and Expected result (test step).
 
To organize multiple steps in one test case, optimize your test steps as in the following example:
 
ID
Name
Name (test step)
Instructions (test step)
Expected results (test step)
Type (test step)
128065
Testcase1
First Step
Do
 
Condition
128065
 
Second Step
Do it
Check it
Step
128066
Testcase2
First Step
Do
 
Condition
128066
 
Second Step
Do it
Check it
Step
 
The test case ID with all its column information is unique. The additional steps are listed with the same ID in the subsequent rows. Following successful mapping, click on Next. The export settings can be saved here.
 
 
Click on Finish to start the import. All your files are imported to the selected project.

    • Related Articles

    • Export

      Using the context menu of a project or a folder, you can export all items of the selected project or folder as Excel file. In the same way, you can also use the context menu of one or more selected items to export the selected items. A zip file is ...

    • Import

      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 dialog you can first download a sample file in the appropriate format for the selected project. There ...

    • Import Project Configuration

      Project configurations can also be exported and re-imported in other projects. Thus all configurations of fields, workflows, notification templates, field rules, etc. can be transferred. Cross-project information, such as users or roles, are not ...

    • Web Client vs Rich Client

      Feature Additional Info WebClient Rich Client Homescreen   x x   Configurable Only on premise x User administration   x x   Roles x x   Creation x x   Project x x   Usage statistics   x   SAML 2.0 x   Project configuration   x x   Fields x x   ...

    • Rich Client

      System Requirements – aqua Rich Client   Minimum software and hardware requirements are: Intel Core Duo 2x2Ghz, AMD Duo Core Processor 2x2Ghz or more 4 GB RAM or more 1 GB free hard disk space Windows 10, Windows 8.1, Windows 8, Windows 7 Microsoft ...