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)

and select the Sections (3) table

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