If you are Acadience (AOL) is integrated with the datahub, click HERE for instructions:

Acadience Import Instructions - ALO - With Datahub

The following are instructions on how to create the files needed for Acadience. There are a total of 7 files that need to be created. Those files are then put into a zip folder and sent to them via SFTP.

File 1 - Manifest.csv

This file is simply a way to identify the district and the school year. Template is here: Just download and add your district number where the XXXX is. The file is already set as a .csv

File 2 - Schools.csv

This is also a simple file that has the school number(s) and school name(s). Template is here: Just download and fill out. This is also a .csv file.

File 3 - Classes.csv

This file is a listing of sections from PowerSchool and it needs to be exported from PowerSchool directly. First navigate to DDE (Direct Database Export. Data and Reporting > Export > Direct Database Export (DDE)

Open

and select the Sections (3) table

Open

You will want to do a search for term ID that is greater than or equal to the current year (3300):

Once you have your selection, click on the export records button. Fill in the export box with these fields:

ID
SchoolID
[2]Course_Name

This will give us the section ID, the school ID, and the course name. Set the field delimiter to “Comma” and export the file.

The file will export as “Sections.export.text” you will need to rename the file to “Classes.csv”

Students.csv

This file is a listing of students from PowerSchool and it needs to be exported from PowerSchool directly. First navigate to DDE (Direct Database Export. Data and Reporting > Export > Direct Database Export (DDE) and this time select the Students (1) table. Do a search for all active students, enroll status = 0.

This will return all active students. Select the export button and export the following fields:

ID
Student_Number
State_StudentNumber
Last_Name
First_Name
DOB
Grade_Level
Gender

Make sure you select “Comma”

And you will need to rename the file to Students.csv, PS exports it as Students.export.text

Staff.csv

This file is a listing of staff from PowerSchool and it needs to be exported from PowerSchool directly. First navigate to DDE (Direct Database Export. Data and Reporting > Export > Direct Database Export (DDE) and this time select the Teachers (5) table. Do a search for all active teachers, StaffStatus = 1 will return all active staff.

Then export these fields:

ID
TeacherNumber
Last_Name
First_Name
Email_Addr

Make sure you select “Comma”, and hit the “Submit” button.

You will then need to rename the file “Staff.csv”

StudentEnrollments.csv

This file is a listing of student enrollments from PowerSchool and it needs to be exported from PowerSchool directly. First navigate to DDE (Direct Database Export. Data and Reporting > Export > Direct Database Export (DDE) and this time select the CC (4) table. Do a search for all records for the 23-24 school year. TermID >= 3300

Once you have that selection, do an export and use the following fields:

ID
StudentID
SectionID

Remember to select “Comma”

Export the file and remember to rename it to StudentEnrollments.csv

StaffEnrollments.csv

This file is a listing of staff enrollments from PowerSchool and it needs to be exported from PowerSchool directly. First navigate to DDE (Direct Database Export. Data and Reporting > Export > Direct Database Export (DDE) and this time select the CC (4) table. Do a search for all records for the 23-24 school year. TermID >= 3300

Then go to export the following fields:

ID
TeacherID

Don’t forget to select “Comma”

Export the file and rename it to StaffEnrollments.csv

You will also need to add one more column to this file manually.

Open the file in Excel and add a “Role” column and populate it with “teacher” and save it.

Prep the ZIP File

You should now have seven files, in this example I placed them into a folder named ALO-District, you will want to name them with your own district name in place of “District”

Navigate one folder level up and right click on the folder “ALO-District” and select “Compress to ZIP File”

That file can then be sent out and uploaded via SFTP to ALO.