User Manual Studio Export CSV

The CSV export of the results contains all result data available.

#Configuration

The Schema lets you choose from three different options:

• One file per form: Generates one CSV file for each form with the results from all candidates.
• One file per candidate: Generates multiple CSV files, one for each candidate with the results of all forms.
• One file per form: Generates one CSV file with all results.

The option Use Numeric Values will show selections as states as text instead of id.
E.g. the id of an answer option will be used instead of the label of the option.

Detailed Selection Information will also provide a column for each option containing the selection state.
This is helpful if you want to create a statistic of each answer and their option regarding the option’s usage.

#Structure

#General Information

The resulting structure follows always the same pattern. A record starts with the details about the device, exam, form, examiner, and candidate.

assessment_id	device	exam	form_id	form_name	case_no	examiner_id	examiner_last_name	examiner_first_name	candidate_id	candidate_last_name	candidate_first_name
B459cQst...	iPad 83	Clinical Exam	C38 PL	Pain in leg	38	4	Maillard	Thierry	9	Adams	Jonathan

The adjacent columns contain information about the assessment:

date_created	date_modified	date_finalized	finalized	progress	maximum_score	passing_score	achieved_score	passed	comment
12.24.24 13:07	12.24.24 13:14	12.24.24 13:18	1	100%	35	22	16.5	0	The general comment

#Result Details

For each question, the selected option value and selection (or label) is listed for each answer (if multiple answers exist).

A_1	A_1_MS	A_1_MS_selection	A_1_SS	A_1_SS_selection	A_1_T	A_2...
1	2	option-id-1, option-id-3	1	option-id-yes	Comment for this answer

The first result column (A_1) is the variable name defined in a question element.

As it is possible to add multiple answer elements, a column for each answer is generated.
These columns have the suffix

• _MS for a multi-select answer
• _SS for a single-select answer
• _T for a text answer.

Note: In this example, the single-select answer is configured to be the value giving (primary) answer type.

Because it is possible to change the variable prefix defined in a section, the result A_1 could also be MyVar_1.
This also works with nested section elements, for example A_1_a_2 could be defined as A_1_MyVar_2.