Import/Export of data | help.schuhfried.com

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:

Open the Persons tab.
Click Import to open the import dialog window.
Follow the Instructions displayed in the dialog window
1. As with creating a test person in the VTS, only mandatory fields must be filled in.

Detailed instruction

(Optional) Click Download example to obtain a .csv file with predefined column names.
Create or edit the .csv file according to the specified format.
1. All person data specified in the .csv file will be imported.
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.
It is now possible to import custom person fields via CSV. You can find instructions on how to create these fields here.
1. For the import, the column name in the .csv file must exactly match the field name you assigned.
2. For Picklist columns, you must enter the selectable values as text.
3. For Yes/No columns, you must enter “True” for “Yes” and “False” for “No”.
Click Select file to open the file explorer.
In the file explorer, select one or multiple .csv files for import.
Click Verify and import to validate the selected files before importing and to verify which test persons will be imported.
Click Import to start the import process.
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:

Open the Persons tab.
Select the test persons you want to export.
Click Export to open the export dialog window.
In the dialog window, click Export to start the export process.
The selected test persons are exported with all associated person data, corresponding to the information stored for test persons in the system.
A new browser tab opens automatically.
In the new tab, click Download to download the .csv file.
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.
(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.

VTS-format	CSV-format	SPSS-Format
Can be imported into any VTS	Cannot be imported into the VTS	Cannot be imported into the VTS
Can only be viewed within the VTS	Can be opened in any text editor or spreadsheet program (e.g. Excel)	Can be opened in SPSS.
Contains all information related to the testing session	Contains all primary and secondary variables of tests. Desired comparison norm can be selected. Enables the export of results at the item level (raw scores and data for each test item).	Contains all primary and secondary variables as well as additional information about the tests. When exporting the results of an individual test, the desired comparison norm can be selected. Enables the export of results at the item level (raw scores and data for each test item).
Contains mandatory personal data of each test person	Contains mandatory personal data of each test person	Contains the following mandatory personal data: last name, gender, education level, age, age in months.

For information on the variables included in the exports, please see: Variable description.

Procedure

Test results can be exported via the Results tab.

Select the dataset you wish to export.
Click the Export button located at the top of the page. A pop-up window will appear.
Choose your preferred file format.
- For CSV exports the desired comparison norm can be selected and you can choose to export data on the item level.
- For SPSS exports, you can select which data should be exported: main variables; secondary variables and additional information; results at the item level. However, these options only apply to newer tests; for some older tests, all data is always exported.
If needed, activate the checkbox to anonymize the data before export.
Confirm the export via clicking Export.
A new browser tab opens automatically.
In the new tab, click Download to download the file.
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.

Finalizing the SPSS Export

For each test form, two SPSS files are exported: a data file (.asc) and an SPSS syntax file (.sps). Open the SPSS syntax file (.sps) by double-clicking it.
ATTENTION: The SPSS syntax file (.sps) contains a file path to the data file (.asc). If the exported files were moved to another folder after the SPSS export, the file path in the SPSS syntax file (.sps) must be adjusted as follows:
1. Copy the new file path to the data file (.asc) → Right mouse click on the data file (.asc) → Release the SHIFT key → Click Copy as path.
2. Delete the old file path in the SPSS syntax file (.sps).
3. Insert the new file path at this location in the syntax using CTRL+V or using the paste icon at the point of the syntax shown below
4. If necessary, add an apostrophe (keyboard shortcut SHIFT + #) at the beginning and end of the path.
Select everything via the Edit tab and the Select All button (or by pressing CTRL+A).
Click Run Selection (or press CTRL+R) to execute the syntax.
SPSS opens the corresponding data document (.sav).