Exported Data Format

When exporting data from SMART-TRIAL you have to choose which additional columns and rows you want in your export. This can be done by selecting the appropriate Export Headers, Export Attributes, and Possibility Coding.  

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 following attributes can be selected: Site name, Archived, and all Subject attributes selected during study setup. The presented subject attributes also depend on your permissions, as personal identifiable attributes will be hidden unless you have "View identifiable" for all sites.

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.

  • 5 level smiley scale - The choices will be denoted from Level 1-5, depending on the chosen answer.
  • Yes/No - Yes in the system becomes Yes in the export, while No becomes No in the export.
  • Multiple choice - Multiple choice question types only have one answer. The answer seen in the data input view will be the full text possibility in the export.
  • 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 the text possibilities seen in the data input view. Here .ns means the answer was not selected and the name of text possibility means the answer was selected.

    Example: A multiple response question (Q1) had 5 possible answers, 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
    .ns .ns Head Stomach .ns

Not answered questions:

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.

  • .b - Not answered
  • .c - Not answered due to cancellation of data event
  • .d - Not answered due to discontinuing 
  • .e - Not answered due to exclusion from the study
  • .h - Not answered due to question being hidden
  • .n - Marked as 'Answer not Available' 
  • .ns - Not selected

Questions hidden by show rules and thus not answered will be denoted as .h.

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:

NAME FORMAT
ISO YYYY-MM-DD HH:mm
SAS DDMMMYYYY:HH:mm
EU DD-MM-YYYY HH:mm
US MM-DD-YYYY HH:mm

 

 

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

When opening .xlsx files or opening .csv files in SMART-TRIAL, the exported data has the following format in Excel:  

anotherexportimgTo 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.

In this example, E1_F1_Q1 should be read as Event1_Form1_Questing1 and is assigned the attributes for the giving answer. If Export Labels have been chosen for a specific question, the output will be E1_F1_XX, depending on your Label.

Exported Data Example using Custom export labels and text possibilities

When opening .xlsx files or exporting .csv files in SMART-TRIAL, the exported data has the following format in Excel:  

exportimg

 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. 

In this example Export Labels have been chosen for the specific Data Event, Form and questions, therefor ScreeningVisit_Pain_Affected should be read as Data Event = ScreeningVisit, Form = Pain, and Question = Affected.