Exported Data Format

Export Headers

Determines which headers and labels will be used to identify the Data Events, Forms, and Questions in the Export file.

When creating your export you can choose to use SMART-TRIAL export labels (E1_F3 _Q1) or your own labels (ScreeningVisit_Demographics _Weight) or both!
The use of Custom export labels requires that Export labels are filled in for Data Events, Forms and Questions, if some are missing the SMART-TRIAL export label format will be used as default. To see how you can read the article about Export Labels.

Here you also have to select whether Data legends shall be included or omitted in the export.

Export Attributes

The Export Attributes drop down allows you to select which subject attributes or subject related attributes should be included in the export as columns coming before the study data. The presented subject attributes depend on the subject attributes selected under "Subject Attributes" in the study builder. The presented subject attributes also depend on your permissions, as personal identifiable attributes will be hidden unless you have "View identifiable" for all sites. Without "View identifiable" the following attributes can be selected:

• Subject Id - The unique subject identifier for the subject.
• Language - The language of the subject.
• Archived - Subjects can be archived at any time throughout the study. This will mark the subject as "archived" in the export.
• Site Name - The name of the site in which the subject is enrolled.
• Form Version - The current version of the forms used in the study. Is displayed as one column per form.
• Form Answers Created Time - The time when the forms were saved the first time. Is displayed as one column per form.
• Form Answers Last Update Time - The time when the forms were last updated. If no updates have been made, the time will be the same as for the "Form Answers Created Time". Is displayed as one column per form.
• Sign-off Time - The date and time of when the enrollment was signed off using the "Sign Off Enrollment" feature.
• Sign-off By - The email address of the person signing off the enrollment using the "Sign Off Enrollment" feature.
• Data Event Activation Time - The date and time of when the data event was activated. Is displayed as one column per data event.

Possibility Coding

Export allows for coded and uncoded (text answers) possibility data. Therefore, when creating an export you can now select whether you want Coded possibilities or you want Text possibilities.

Coded Possibilities

• 5 level smiley scale - The choices will be denoted from 0-4, depending on the chosen answer.
• Checkbox - Will be denoted as ‘true’ if checked, or ‘false’ if not checked.
• Date - Date format can be specified on an export level, if nothing is chosen the answer will by default be presented as the study date format.
• Date and time - The question will be divided into two separate questions, one for the date and one for the time. The date will be displayed as the study date format (unless another date format is chosen at data export level), and the time will be denoted as XX:XX.
• Duration - The duration will be denoted as a time in HH.MM format.
• Free text and Free text single sentence - Both will be displayed as text written in the answer.
• Image as Answer - Images are currently not exportable.
• File as Answer - The file name will be displayed in the export file.
• Multiple choice - Multiple choice question type only has one answer. The choices are denoted from 0-N, N being the last choice. So, there is a 4 in the export, it equates to the fifth choice available.

• Multiple response - Multiple response question type can have multiple answers, this is done by listing all the possible answers to the question and then they are marked with either a 0 or 1. Here 0 means the answer was not selected and 1 means the answer was selected.

  Example: A multiple response question (Q1) had 5 possible answers (0-4), and the subject selected the 3rd and 4th possibility.
  Read E1_F1_Q1_0 as Event1_Form1_Question1_possibility0 and so forth.

  E1_F1_Q1_0	E1_F1_Q1_1	E1_F1_Q1_2	E1_F1_Q1_3	E1_F1_Q1_4
  0	0	1	1	0

• Number - The number typed in the answer will be directly exported.
• Slider/VAS Scale - The slider/VAS scale is a visual representation of a slider where the subject chose a location depending on the question, the location represents a number, and the answer will be exported as a number.
• Specific Time - The time will be exported in the HH:MM format.
• Yes/No - Treated as a Boolean with 0 denoting No and 1 denoting yes.
• Calculated question - The calculated value will be directly exported. 
• Information text - Information text serves as information for the subject displayed during the fill out process, and is therefore not exported.

Using score forms
The score value of answers in a score form is included in the export with their own "SCORE" field, right next to the question answer.

Text Possibilities

Using Text Possibilities most question types appear similar as when Coded Possibilities are selected for the Export, but 4 question types differ.

In cases where not all questions are answered, one of the following answers is provided in the export file in order to specify the reason for the missing answer.

Date time format:

For each export you get to choose the format of your date and timestamps in your export file. 

It will default to the datetime format you have chosen to use in the study, but you can select a different one using the dropdown.

Often the datetime format easily readable by humans is different from the datetime format useful for data analysis.

Select the datetime format most appropriate for your statistical tool. Some examples are:

Exported Data Example using SMART-TRIAL export labels and coded possibilities

When opening .xlsx files or opening .csv files from SMART-TRIAL, the exported data has the following format in Excel, for a process based export:  

To see the image in large format, please click on the image.

The Exported Data comes with Question Text and Answer Type/Possibilities Labels, together with the study data and attributes. This gives you a better overview of the answers the respondents have made. 

Generated ‘Data Code’ PDF file will give you an overview of the questions and the possible answers.