EdInsight Export
Overview
This task exports data for EdInsight. It will create up to 18 csv files and 1 zip file containing jpeg images: Students.csv, Contacts.csv, StudentSchools.csv, Staff.csv, Courses.csv, MasterSchedules.csv, MasterScheduleCycles.csv, SchoolCycles.csv, SchoolTerms.csv, StudentSchedules.csv, StudentGrades.csv, StudentMisconduct.csv, StudentMisconductOffense.csv, StudentMisconductDiscipline.csv, Attendance.csv, AttendanceClass.csv, Calendar.csv, Users.csv, Photos.zip.
Options
The export can be configured to save locally, be sent in an email, or have the files sent to another machine using (S)FTP.
Individual schools can be selected to be included.
Output
Students |
Column |
InternalStudentId |
LocalStudentId |
FirstName |
MiddleName |
LastName |
Gender |
| EthnicityCode |
| EthnicityDescription |
| IsHispanic |
| DateOfBirth |
| InitialEnrollDate |
| Email1 |
| Email2 |
| StateStudentId |
| IEP |
| Gifted |
| EconomicallyDisadvantaged |
| Title1 |
| Title3 |
| ELL |
| Section504 |
| Migrant |
| Medical Issue |
| SchoolYear |
Contacts |
Column |
StudentId |
ContactId |
DisplayOrder |
FirstName |
MiddleName |
LastName |
| AddressLine1 |
| AddressLine2 |
| City |
| State |
| Zip |
| Phone1 |
| Phone2 |
| EmergencyPhone1 |
| EmergencyPhone2 |
| Email1 |
| Relationship |
| Email2 |
| SchoolYear |
Student Schools |
Column |
StudentId |
SchoolCode |
SchoolName |
CurrentGrade |
CurrentHomeroom |
EnrollDate |
| SchoolYear |
Staff |
Column |
StaffId |
SchoolCode |
FirstName |
MiddleName |
LastName |
Gender |
| DateOfBirth |
| AddressLine1 |
| AddressLine2 |
| AddressCityStateZip |
| Phone1 |
| Phone2 |
| EmergencyPhone1 |
| EmergencyPhone2 |
| Email1 |
| Email2 |
| Username |
| HiringDate |
| SchoolYear |
Courses |
Column |
CourseCode |
LongCourseName |
ShortCourseName |
NumberOfCredits |
SchoolCode |
SchoolYear |
Master Schedules |
Column |
SchoolCode |
CourseCode |
SectionCode |
StaffId |
RoomNumber |
SchoolYear |
Master Schedule Cycles |
Column |
SchoolCode |
CourseCode |
SectionCode |
TermCode |
CycleCode |
PeriodCode |
| SchoolYear |
School Cycles |
Column |
SchoolCode |
CycleCode |
CycleDate |
SchoolYear |
School Terms |
Column |
SchoolCode |
TermCode |
StartDate |
EndDate |
SchoolYear |
Student Schedules |
Column |
SchoolCode |
StudentId |
CourseCode |
SectionCode |
SchoolYear |
Student Grades |
Column |
StudentId |
SchoolCode |
CourseCode |
SectionCode |
MarkingPeriodType |
Grade |
| SchoolYear |
Student Misconduct |
Column |
SchoolCode |
IncidentId |
MisconductIncidentDate |
MisconductIncidentTime |
IncidentLocation |
IncidentReportedBy |
| IncidentReportedToPolice |
| SchoolYear |
Student Misconduct Offense |
Column |
StudentId |
SchoolCode |
IncidentId |
OffenseTypeCode |
OffenseTypeDescription |
DisciplineTypeCode |
| SchoolYear |
Student Misconduct Discipline |
Column |
StudentId |
SchoolCode |
IncidentId |
OffenseTypeCode |
DisciplineTypeCode |
DisciplineTypeDesc |
| SuspensionTypeCode |
| DisciplineDurationType |
| DisciplineDurationLength |
| DisciplineActionStartDate |
| DisciplineActionEndDate |
| SchoolYear |
Attendance |
Column |
StudentId |
SchoolCode |
AbsenceDate |
AbsenceReasonCode |
AbsenceReasonDescription |
AbsenceCategoryCode |
| SchoolYear |
Attendance Class |
Column |
StudentId |
SchoolCode |
CourseCode |
SectionCode |
AbsenceDate |
AbsenceReasonCode |
| AbsenceReasonDescription |
| AbsenceCategoryCode |
| SchoolYear |
Calendar |
Column |
SchoolCode |
CalendarDate |
InstructionalDay |
InstructionalWeek |
DayNotes |
NonInstructionalDayType |
| SchoolYear |
Users |
Column |
SIS Staff ID |
Name |
Username |
Email Address |
SIS Building Codes |
EdInsight Level Access Number |
| SchoolYear |
Photos.zip |
Zip file containing JPEG images. Image names will be the Student's ID.jpg |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article