Important: Due to the current method for calculating full and differential data sets, all data sets may contain duplicate rows that share identical values. D2L recommends that the tool or automated process that reads your data sets is designed to manage or strip duplicate rows.
How to export a Brightspace Data Set
- From the navbar, click Data Hub.
- In the Data Sets tab, click the name of a Brightspace Data Set to export.
- Choose a full or differential data set (if available) and click Download.
- Unzip the ZIP file.
- Open the CSV file in a CSV-compatible tool such as Microsoft Excel.
Note: Only complete data sets are available for export. If a data set fails to generate, it does not overwrite the last successfully completed data set. For example, if Tuesday's daily (full) data set fails, Monday's data set remains available. Similarly, if the 2 PM hourly (differential) data set fails, the 3 PM data set includes data targeted for 2 and 3 PM.
How to export an Advanced Data Set
- From the navbar, click Data Hub.
- In the Data Sets tab, click the name of an Advanced Data Set to export.
- Adjust the filters to capture the data that you want and click Export.
- In the Job Status tab, locate the report that you just generated and click Complete.
- Unzip the ZIP file.
- Open the CSV file in a CSV-compatible tool such as Microsoft Excel.
Important: For Advanced Data Sets with an OrgUnit filter, all descendants of the Org Unit ID you select are included in the report. Avoid selecting an Org Unit ID at the top of your organization, as this can cause very long running reports or even time out errors.
Note: The link to download an ADS export is available on the Job Status tab for 30 days after it was generated.