Generate an automated extract using a Custom Report using our scheduled extract tool. As long as meta-data is available for the data in our system, we can generate the extract files.
Important Considerations:
- The Custom Report will determine the data generated by the job.
- Any changes will be captured by the job when the file is scheduled to generate.
- Do not forget to rollover and update filters for your Custom Report(s) at the start of each new session.
Required Permissions: Data Extracts Access
Where to Start

If you have an existing report, go to:
- Go to Reports.
- Select View Reports.
- Select the report title, then skip to step 2.
If you do not have an existing report, you will need to first build a custom report.
1. Build a Custom Report
Reference the manual on Custom Reports and manual for Custom Reports: Advanced for in-depth assistance. The following documents might be especially useful:
- Create a Custom Report
- Custom Report Quick Guide
- Add Columns or Data to a Custom Report
- Use Filters on a Custom Report
- Edit a Custom Report
- Manage Columns on a Custom Report
- Removing Duplicates from a Custom Report
Please note the following considerations for the Custom Report:
- The columns (from left to right) will match how the file is generate from left to right.
- The sorting will be matched (i.e. if you sort alphabetically, the extract will sort alphabetically).
- Headers will always be included.
- The headers name set in Manage Columns will determine the name and format of the column headers.
2. Verify your Data in the Custom Report
Please take time to verify your data. Data is sent as is, meaning any duplicates or blank values will be sent as well. Talk to your vendor regarding the behavior of the data import to see if this will cause issues.
3. Make Custom Extract
- If the data looks accurate, select the Advanced menu.
- Select Make Custom Extract.
- This will "save" the Custom Report as an extract for future use and redirects to the Scheduled Extracts page. A banner at the top of the page confirms the custom extract was created. To manually return to this page, go to the Admin Cog Wheel > Data Extracts.
- Any existing extracts appear in a table.
- Users can Edit, Run, or Delete the extract at any time after it is created.
- From the menu, select the report title to create the extract for.
- Select Create.
4. Schedule an Automated Job

Before continuing with this step, you will want to make sure you have the following information:
- The name of each extract that will be tied to a Custom Report. Please include your extension otherwise it will be omitted.
- For example, if you have two extracts, one Custom Report for classes and another for students information, request the class file to be named "classes.csv" and the student file to be named "students.csv"
- SFTP Server information. We currently only support Secure File Transfer Protocol (SFTP). The server information needed includes:
- Hostname
- Port (if not 22)
- Username
- Password
- Directory to pass files
- Scheduled time to create files (we support multiple times a day)
Return to the Data Extract page by navigating to Admin Cog > Data Extracts . Scroll down to the bottom of the page, click the "Extract" dropdown and select your Custom Report made Extract. Read more about using the Scheduled Extract tool here.
4.5. Getting the File to your Vendor
Note that on Step 4, it is highly recommended you send the file directly to the vendor via SFTP. If they do not have a server that supports SFTP, we may not be able to assist.
5. Verify your Extract Job
Verify the job pushes out your extract files as expected. If you see any formatting issues or unexpected problems with the file, please submit a request to the Support Team.
6. Work with your Vendor
Reach out to your vendor and follow up. If there are problems with the data, update your Custom Report. If there are problems with the file generation, contact us by submitting a request.
Please note if you ask us to speak with your vendor and/or explicitly provide data for your vendor, we will require your Director of Technology and your vendor to fill out a permission application.