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.