When exporting data from Greenlight Guru Clinical 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 Greenlight Guru Clinical 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 Greenlight Guru Clinical 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_0E1_F1_Q1_1E1_F1_Q1_2E1_F1_Q1_3E1_F1_Q1_40 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_0E1_F1_Q1_1E1_F1_Q1_2E1_F1_Q1_3E1_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 Greenlight Guru Clinical export labels and coded possibilities
When opening .xlsx files or opening .csv files from Greenlight Guru Clinical, the exported data has the following format in Excel, for a process based export:
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.
Generating a ‘Data Code’ PDF file will give you an overview of the questions and the possible answers.
In this example, SCR_IC_Sign is inserted as there has been added export labels in this study. If export labels had not been added, the third row would show E1_F1_Q1 which should be read as Event1_Form1_Question1 and is assigned the attributes for the given 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
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 SCR_IC_Sign should be read as Data Event = ScreeningVisit, Form = Informed Consent, and Question = Signed.