Data Management

4 minutes to read Download PDF Edit


This workspace is the heart of ATS, since it allows to create and manage folders, test suites, test cases and actions. The folder in the ATS is equivalent to a directory in your file browser. You can create folders within other folders, and in each folder, you can store test suites, test cases and actions.

Repository of the ATS


ATS allows to export data (folders, test suites, test cases and keywords) to an XML file, and import that data into another ATS instance. This makes it possible to move data between different environments without having to handle database dumps.

Data Import

There are two use cases when importing data: create data and update data. Create data means that you will be importing new data for the first time into your target database. Update data means that you will be importing data that will overwrite existing data, thus updating actions, test cases, test suites or folders.

When importing data, all data conflicts will be resolved by overwriting the existing properties by the imported ones.

To import data in ATS do the following:

  • Click Import in order to open the data import form.
  • On the data import form, click the New Import button to open the import data dialog.

ATS Import Page

  • In the data import dialog select the .xml file containing your import and press Upload

Data Import Dialog

The system will check the import for data inconsistencies and shows error details in a list if there are any. Click the import button in the bottom of the screen to complete the import.

Data Export

There are different scenarios on how to export data from ATS:

  • Exporting single action
  • Exporting multiple actions
  • Exporting test cases
  • Exporting test suites
  • Exporting folders containing:
    • Actions
    • Actions and test cases
    • Actions, test cases and testsuites
    • Folders, actions, test cases and test suites

In order to start an export, you can either mark the export items listed in the current list view in the Repository and then click Export in the top menu, or you can export the item you are currently editing by clicking the Export button in the top right.

Exporting a test Case

Exporting in the repository:

Exporting items in the Repository

Test Data

Creating Data Sets

In the ATS repository under the Test Data tab you can create data sets by clicking the New Data Set button. You can name the data set and give a description.

A data set is defined by one or more fields and records. Fields are the columns of your table, records are the lines in your table containing the field values. Fields can have the data types integer or string. After you have created a data set you can add Fields and Records to the set.


A column of the table for specific data, for example username


Line in the data table containing an integer or string value of the data

Importing/Exporting data sets

When creating/editing a data set you can choose to Create/Update fields from file option to provide a template Excel file to create or update fields and records of your data set. The first row of your sheet will be considered the header and will be used to determine the field names. All additional rows will be considered records and will be used to determine the fields data type.

You can also only import data records into you data set by clicking the ‘Import from Excel’ button. The first row of your Excel sheet must contain the the field names of the data set into which you want to import the records.

You can simply export a data set by clicking the Export to Excel button.