0
Acadience Learning Online Acadience Data Management Log In to Mentors' Network
  • Acadience Reading
    • Pre-K: PELI
    • K–6
    • 7–8
    • Español
    • Français
    • Survey
    • Diagnostic
    • RAN
    • Spelling
  • Acadience Math
    • K–6
  • Training
    • Live Training
    • Online Training
  • Resources
    • Help Center
    • Blogs & Webinars
    • Data Services
    • Mentors’ Network
    • Parent
    • Pathways of Progress
    • Presentations and Publications
    • Research and Projects
    • Store
  • About Us
    • About Us
    • Careers
    • News
Select Page
  • Acadience Assessments
    • Acadience Math K-6
    • Acadience Reading K-6
  • Acadience Learning Online (ALO)
    • Access and Permissions
    • Data Views and Reports
    • Digital Assessment Administration and Scoring
    • Getting Started in the System
    • Manual Entry of Scores
    • Navigation and Features
  • Frequently Asked Questions
  • Professional Learning
  • Acadience Assessments
  • Acadience Learning Online (ALO)
    • Access and Permissions
    • Data Views and Reports
    • Digital Assessment Administration and Scoring
    • Getting Started in the System
    • Manual Entry of Scores
    • Navigation and Features
  • Frequently Asked Questions
  • Professional Learning

SFTP Imports - Helpful Tips

Preparing for a Successful Import

 

SFTP imports into ALO require that you submit 7 files with all of your school, class, student, staff and enrollment information included. The import will overwrite current year information in your account, and must be complete (you cannot run a partial import to add some records, you must include all records). 

Each import is processed through an SFTP server and involves submitting the following 7 files:

  • Manifest.csv
  • Schools.csv
  • Classes.csv
  • Students.csv
  • Staff.csv
  • StudentEnrollments.csv
  • StaffEnrollments.csv

 

You can download templates for the 7 SFTP import files, including the specific Manifest.csv file needed for your account, from the “Apps” section in ALO. To get to the “Apps” tab, log into ALO and select the “My District” button, then select “Apps.”

Please note that once you begin submitting files, your import status will display under the Download section.  If there are errors, click 'view logs' to analyze the errors that need to be remedied in the files. 

Detailed instructions for setting up your import files can be found in the ALO Import Setup Guide. 

 

Data mapping

When setting up your import files it is important to make sure that the file headers match what is listed in the Import Setup Guide. It is also important to ensure that certain data fields are consistent across the files. The fields that need to match across files are as follows:

  • “ID” in Schools.csv = “School ID” in Classes.csv
  • “ID” in Classes.csv = “Class ID” in StaffEnrollments.csv and StudentEnrollments.csv
  • “ID” in Students.csv = “Student ID” in StudentEnrollments.csv
  • “ID” in Staff.csv = “Teacher ID” in Students.csv
  • “ID” in Staff.csv = “Staff ID” in StaffEnrollments.csv


Here are some additional notes about data fields that may be helpful:

  • In the Students.csv file, you can use the same ID number for the “ID” field and the “Student Number” field.
  • In the Staff.csv file, you can use the same ID number for the “ID” field and the “Primary ID” field.
  • In StudentEnrollments.csv and StaffEnrollments.csv the “ID” field is an enrollment ID and doesn’t need to map to other data. The numbers have to be unique across all rows of data and can just be ascending numbers (e.g. 1-500). 
  • Students and staff can only be listed once in the Students.csv and Staff.csv files respectively, but there can be multiple enrollments for one student or one staff member in the enrollment files.
  • To add school-level staff, leave the “Class ID” field blank in the StaffEnrollments.csv file.
  • To add district-level staff, leave both the “Class ID” and “School ID” fields blank in the StaffEnrollments.csv file.

 

Submitting Import Files

When preparing to submit your import files, you will need to make sure that you have the 7 required files, and that the files are all named exactly as listed in the Import Setup Guide (i.e. Manifest.csv, Schools.csv, Classes.csv, Students.csv, Staff.csv, StudentEnrollments.csv, StaffEnrollments.csv). 

The 7 files will need to be placed in a folder, and the folder will need to be compressed so it has a .zip extension. The zip folder (containing the 7 files) is what will be submitted to the SFTP server.  

The zip folder will need to be submitted to the SFTP server by someone with SFTP credentials set up in ALO. This person can use their SFTP login credentials (SFTP specific username and ALO password) to connect to the ALO SFTP server through a command line interface, or through use of software such as WinSCP. Detailed instructions on how to connect to the SFTP server are provided via email to the SFTP contact and are listed in the ALO Import Setup Guide.

After import files are submitted, the SFTP contact that submitted the files will receive an email with information about the status of the import. If the import fails, there will be information in the email about why the import failed. If the import was successful or successful with some errors, the email will provide confirmation of this and direct the user to the Apps tab in ALO for details. 



Troubleshooting

If an import fails, meaning there were major issues that prevented any data from uploading, here are some items to check:

  • The file submitted must be a .zip folder containing all 7 files
  • The Manifest.csv file must match the sample from your account and include the correct district ID
  • Each file in the zip folder must be named exactly as listed (see above)
  • Column headers in the file must be named exactly as listed (see import guide)
  • Required fields must be included (optional fields can be omitted)
  • School IDs and School Names must be unique
  • Class IDs and Class Names must be unique
  • Students can only be listed once in the Students.csv file
  • Staff can only be listed once in the Staff.csv file
  • Make sure IDs map across files (see above)

 

If the import processes, but there are errors, the error logs in the Apps tab of your ALO account will provide more details about the issues in the import files. If there are no major issues, the import will process but data with errors will be omitted. Errors can be corrected in files and the complete files can be re-imported to fix errors.

  • Assessments
  • Professional Learning
  • FAQs
  • About Us
  • LinkedIn
  • Facebook
  • X
  • Acadience Policies & Terms of Service
  • Professional Learning Terms of Service
  • Digital Products Terms of Service
Acadience® and PELI® are registered trademarks of Acadience Learning Inc. Pathways of Progress™ is a trademark of Acadience Learning Inc. © Acadience Learning Inc.

Name:

Type:

View

Crop Image

  1. The Training Materials may not be altered or incorporated into or compiled with other materials, either in whole or in part, by any means, electronic, print, or otherwise, without the prior written permission of Acadience Learning Inc. Alteration includes, but is not limited to, changes to font, sequence, content, or the removal of the words “Acadience” or “Acadience Learning Inc.” No part of the Training Materials may be used to make other works based, in whole or in part, on the Training Materials.
  2. The Training Materials may not be copied, distributed, displayed, or reproduced in any format or media (e.g., print, DVD, web pages, learning management platforms) without the prior written permission of Acadience Learning Inc.
  3. The provisions of the preceding paragraph to the contrary notwithstanding, Mentor may:
    1. print a paper copy of the Training Materials for Mentor’s own use in preparing for and providing training within
      the scope of use authorized above in Section 1;
    2. download the Training Materials onto the computer that Mentor uses to conduct training within the scope of use authorized above in Section 1, and
    3. display the PowerPoint slides contained within the Training Materials in the course of training within the scope of use authorized above in Section 1.
  1. Mentor will take all necessary and appropriate action to safeguard the Training Materials from any use that is not permitted by this Use Agreement (including but not limited to the sale and/or commercial distribution) and will immediately notify Acadience Learning Inc. if the Mentor becomes aware that the Training Materials have been sold or commercially distributed or otherwise used in a manner that is not authorized by this Use Agreement.
  2. Mentor may use the Training Materials pursuant to the Use Agreement so long as the Mentor completes the Annual Mentor Renewal process including the completion of the required Mentor Renewal Workshop and associated survey. If the Mentor fails to complete the required renewal process, all rights of the Mentor in the Mentors’ Network and to the Training Materials will terminate.