...
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:
| View file | ||
|---|---|---|
|
File 2 - Schools.csv
This is also a simple file that has the school number(s) and school name(s). Template is here:
| View 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)
...
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.
...