Use Exporter to export specific domains from a study or to export an entire study. Exports can be done manually, or you can create an export definition which allows you to save the selections and schedule the export as part of a task.
You can export to one of the following formats, depending on your privileges:
- Excel
- CSV
- SAS
- SAS XPORT
- Delimited
The Exporter window is divided into two halves. The top half of the window is where you select the Snapshot you want to use for the export, if available (the default is the current version of the data), the Data Store where your data resides, the domains you want to export, and the export format.
The bottom half of the window displays the results from your most recent export, as well as any exports completed during the active session. When you log back in for another elluminate session, only the very last export you ran displays.
You can also see any existing Export Definitions by clicking on the Export Definitions tab in the lower section of the window.
Create an Export Definition
You can create export definitions that can be saved and run at any time, or scheduled to run through the Tasks feature.
- From a study home page, select Exporter from the Details drop-down. The Exporter window displays.
- Click the + New Definition button.
The Export Definition window opens. - In the Name field, enter a name for the Export Definition.
- In the Study Snapshot field, click the drop-down and select the study snapshot you would like to use for the export from the Study Snapshot drop-down. The default is Current.
- To select the domains that will be included, select either Data Store or Tags in the "Group By" selection area.
- If Data Store is selected, select the Data Store from where you would like to export. Only the data stores with data display.
- If Tags is selected, select the Tag that has been used for the data stores or domains that you want to export.
- In the Available Domains list, the domains in the selected data store, or that have been tagged with the selected tag will display.
- Select the domain(s) you want to include in the export; you can select more than one domain by holding down either the Shift key (when selecting consecutive domains) or the Ctrl key (when selecting domains that are not next to each other). The selected domains are highlighted.
- Select Include All to include all domains that exist in the collected data store or have the selected Tag. This will include all domains, including ones that are added after the Export Definition is created.
- Click Select all to select all of the current domains based on the Data Store of Tag selected. Note: This will NOT automatically include domains that are added after the Export Definition is created.
- In the Filename Format field, edit the field to enter the details for the naming scheme. Enter a [ to see available options for naming scheme. The results for the name, based on the given fields, will appear below. The default filename includes the study name, user name, and date and time.
- In the Domain file naming field, click the drop-down to select whether you want to change the case of the filename.
- In the Format field, click the drop-down and select the export format to use. The default is Excel, the first item in the list. Options include Excel, CSV, SAS, SAS XPORT, and Delimited. Depending on your selection, the additional checkbox options may change. See the table below for details.
- Select Add CheckSum when you want to ensure the data you are exporting has not been altered when opening it. When you check this, an .md5 file will be created with your export. Be sure to save the .md5 file with your exported file(s). The consumer of the file must have the appropriate software to match the checksum file to the Excel file and prove that it has not been altered. This is available for any type of export.
Tip: CheckSum: The outcome of running an algorithm, or a cryptographic hash function, on a piece of data, usually a single file. Comparing the checksum generated from your export with the one provided by the source of the file, helps to ensure that the copy of the file has not been altered. A checksum may also be referred to as a hash sum.
Depending on your selected format, you may make additional selections as shown in the following table:
FORMAT OPTIONS Excel
Output Type
Workbook Per Domain: Select this if you want each domain you export to be its own Excel workbook or file.
Sheet Per Domain: Select this if you want all exported domains to be in one workbook, but separate tabs.
Field Headers
Names: Select this when you want the name of the variables in the domain to display as the header in the Excel file. For example, if you chose to export Adverse Events with Names selected, the Variable headers would display as STUDYID, USUBJID, AETERM, AESTDTC, etc.
Labels: Select this when you want the labels for the variables in the domain to display as the header in the Excel file. For example, if you chose to export Adverse Events with Labels selected, the Variable headers would display as Study Identifier, Unique Subject Identifier, Reported Term for the Adverse Event, Start Date / Time of Adverse Event, etc.
CSV
There are no specific selections for the CSV format.
SAS
Auto Trim and Auto Split options enable exports to meet FDA study submission requirements by resizing and splitting columns.
Auto Trim: Select to have the Exporter scan each column, determine the actual maximum column length, and adjust the column to that length.
Auto Split: Select to have the Exporter scan each column and automatically split columns exceeding 200 characters into multiple columns, each no longer than 200 characters.
The new columns will be inserted immediately following the original column and will be named by appending sequential numbers to the original column's name.
For example, if the AETERM column in the AE table contains more than 200 characters, the AETERM content will be trimmed (truncated) to the first 200 characters, and a new column, AETERM1, will be added to store the next portion, followed by AETERM2, AETERM3, and so on, as needed.
Note: For readability, the text will not be split mid-word. The split will occur at the last whitespace before the 200-characters limit; therefore each column may be slightly shorter than 200 characters, depending on whitespace placement.
UTF-8 Encoding: Select to enable a broader text encoding schema, including more special characters than the default SAS option.
SAS XPORT
Auto Trim and Auto Split options enable exports to meet FDA study submission requirements by resizing and splitting columns.
Auto Trim: Select to have the Exporter scan each column, determine the actual maximum column length, and adjust the column to that length.
Auto Split: Select to have the Exporter scan each column and automatically split columns exceeding 200 characters into multiple columns, each no longer than 200 characters.
The new columns will be inserted immediately following the original column and will be named by appending sequential numbers to the original column's name.
For example, if the AETERM column in the AE table contains more than 200 characters, the AETERM content will be trimmed (truncated) to the first 200 characters, and a new column, AETERM1, will be added to store the next portion, followed by AETERM2, AETERM3, and so on, as needed.
Note: For readability, the text will not be split mid-word. The split will occur at the last whitespace before the 200-characters limit; therefore each column may be slightly shorter than 200 characters, depending on whitespace placement.
Delimited
Delimiter
Choose between Tilde (~) or Vertical Bar (|).
- Select Export to if you want to export the data to a specified outbound data source. If you have a defined data source, the first one will display by default. Use the drop-down to select the appropriate Outbound data source. If you do not have one, you will see a grayed out box.
- The default is that exported domains will be in a .zip file. Select Extract Files to also extract the files in the Outbound data source destination.
- Click Save. The definition will appear on the Exporter home page, Export Definitions tab.
Manually Export Data
- From a study home page, select Exporter from the Details drop-down. The Exporter window displays.
- Follow steps from the Create an Export Definition example above to enter and make selections in the Exporter window.
- Click Export. The export processes at the bottom half of the window. When it is complete, it will display a status of Completed.
Run an Existing Export Definition
- From a study home page, select Exporter from the Details drop-down. The Exporter window displays.
- Click on the Export Definitions tab at the bottom half of the window.
- Click the Run icon next to the export definition. The export processes at the bottom half of the window. When it is complete, it will display a status of Completed in the Recent Exports tab.
Access the Data from an Export
When an export is complete, you can click on the arrow at the left of the name to see the details for the different variables that were exported.
To download the exported files, click the Download button at the right of the export row.
When the download has completed, open the folder.
Note: Remember that based on your export selections, your export will either include each domain as its own file, or there will be one file with the domains included on separate tabs.
When the export has finished, it will also display on Exports from the study's Home Page. This is where you can find a history of all your exports. Any scheduled exports can be accessed here.
If you export to an outbound data source, you will still get a file to view from Exports on the bottom half of the study page.