Import/Export of data

The VTS provides import and export functionality for both personal data and test results data, enabling efficient data management and bulk processing. This allows users to easily transfer data into the system or extract existing data for further use or documentation.

Test persons

Import

In addition to creating individual test persons, test persons can also be imported via .csv file import. This option also allows multiple test persons to be imported at once.

Procedure:

1. Open the Persons tab.

2. Click Import to open the import dialog window.

3. Review the Instructions displayed in the dialog window, which describe the column names, allowed values, and required formats for the .csv file.

   1. The described fields correspond to the information that can be specified when creating a test person in the VTS.

   2. As with creating a test person in the VTS, only mandatory fields must be filled in.

4. (Optional) Click Download example to obtain a .csv file with predefined column names.

5. Create or edit the .csv file according to the specified format.

   1. All person data specified in the .csv file will be imported.

6. Configure the Import settings in the dialog window:

   1. Specify whether persons already stored in the database should also be imported.

   2. Select the required date format.

   3. Define the column delimiter used in the .csv file.

7. Click Select file to open the file explorer.

8. In the file explorer, select one or multiple .csv files for import.

9. Click Verify and import to validate the selected files before importing and to verify which test persons will be imported.

10. Click Import to start the import process.

11. After completion, the imported test persons, including all imported personal data, are displayed in the Persons tab.

Export:

Test persons can also be exported in .csv file format. It is also possible to export multiple test persons at the same time. During export, test persons are exported with all associated personal data.

Procedure:

1. Open the Persons tab.

2. Select the test persons you want to export.

3. Click Export to open the export dialog window.

4. In the dialog window, click Export to start the export process.

5. The selected test persons are exported with all associated person data, corresponding to the information stored for test persons in the system.

6. A new browser tab opens automatically.

7. In the new tab, click Download to download the .csv file.

8. Save the file to the desired folder. The file may be automatically saved in the default Downloads folder. You can then move it to any location you choose.

9. (Optional) Click Task Monitor in the export dialog window or click the user icon and select Task Monitor.

   1. In the Task Monitor, locate the export task, which is available for up to 14 days.

   2. Click View details to open the download page.

   3. On the download page, download the person export .csv file.

   4. Save the file to the desired folder or move it from the Downloads folder if necessary.

Test results

Export

Test results can be exported in two formats: a VTS-compatible format (.xstp) and a .csv format.

Procedure

Test results can be exported via the Results tab.

1. Select the dataset you wish to export.

2. Click the Export button located at the top of the page. A pop-up window will appear.

3. Choose your preferred file format.

   • For CSV exports the desired comparison norm can be selected.

4. If needed, activate the checkbox to anonymize the data before export.

5. Confirm the export via clicking Export.

6. A new browser tab opens automatically.

7. In the new tab, click Download to download the file.

8. Save the file to the desired folder. The file may be automatically saved in the default Downloads folder. You can then move it to any location you choose.