All Collections
Academic Integrations
Manually Uploading Academic Data via SFTP Client
Manually Uploading Academic Data via SFTP Client

Some student information systems require a unique setup to import grades into DragonFly. You can do this with an SFTP client like Filezilla

Jelsey Juric avatar
Written by Jelsey Juric
Updated over a week ago

DragonFly has a simple way for your school to generate a file report from your current student information system and then manually upload this to our software platform via SFTP (Secure File Transfer Protocol). Here's how to get that setup and import your athlete's grades.

Step 1 - Setup Academic Integration in DragonFly: Before you can perform the SFTP upload, you will need to set up your academic integration within your DragonFly school page. Setting up the integration will provide you with the login credentials needed for the file transfer. Click here for step-by-step instructions.

Step 2 - Save Your Academic Integration Credentials: Follow steps 1 - 5 from the instructions in the link above and be sure to copy and save your unique username, password, URL, and Port. Then continue to set up your SFTP connection with the instructions below.

Step 3 - Set up SFTP Connection in Filezilla: Generate a grade report through your student information system. Click the button below to download a sample file of what grade data needs to be included in your report and how it needs to be organized.

If you need further tips on how to format the CSV file, see the CSV Troubleshooting guidelines found here.

4. Open Filezilla on your computer (You can download this program for free.) At the top of your screen, go to "File," then select "Site Manager" from the drop-down menu.

   5. Click "New Site" to setup your integration and set the following fields:

  • Protocol: SFTP - SSH File Transfer Protocol

  • Host: URL provided by DragonFly that you saved in step 2 above.

  • Port: 22

  • Logon Type: Normal

  • User: Username provided by DragonFly that you saved in step 2 above.

  • Password: Password provided by DragonFly that you copied in step 2 above.

 6. Set Remote Directory to a Single Forward Slash - Click on the "Advanced" Tab > Set the "Default Remote Directory" to "/".

Step 7 - Connect to DragonFly Max Server: Click "Connect". You should now see the connection being established in the message log at the top of the Filezilla window.  When you see "Status: Directory listing of "/" successful", then you will know that you are connected correctly to the DragonFly site.

Note: You can also utilize other software clients that are capable of SFTP, including using your computer's command-line tools, to complete this upload.

Step 8 - Upload the Academic Data CSV file: Using Filezilla, look under the "Local site: /" menu, and find the spreadsheet file of your student's grades that you generated in step 3 above. Drag and drop this file to the right onto the DragonFly remote directory. When your file has been transferred correctly, you will see "Status: File Transfer Successful" in the message log at the top of the screen. 

Step 9 - Connect Athlete Transcripts: DragonFly processes academic data on a nightly basis. Once you transfer your grade file, it’s best to return to DragonFly MAX about 24 hours later. After the initial waiting period, the “Academic Integration” column should now be visible on your “People” Checklist, as seen below.

To connect a student, click “Connect Transcript” and select them from the menu. You can also search for the student by name or ID, as highlighted below. 

You should only have to connect the transcript once per student and from that point forward, any changes to grade information in the CSV file will be automatically updated the night the new file is uploaded.

Did this answer your question?