FinalSite Web Export
Overview
This task exports data for FinalSite. It will create up to five csv files: Faculty.csv, Parents.csv, Relationships.csv, Students.csv, Attendance.csv.
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
Faculty |
Column |
ImportID |
FirstName |
LastName |
NamePrefix |
MiddleName |
NameSuffix |
| Username |
| Location |
| Location |
| Location |
| Department |
| Department |
| Department |
| Title1 |
| Title2 |
| Title3 |
| Title4 |
| Title5 |
| Email_School |
| Email_Home |
| Email_Personal |
| Phone_School |
| Phone_Ext_School |
| Biography |
| ClassOf |
| EmployedSince |
| ImageSmall |
| ImageLarge |
| degree1 |
| degreeYear1 |
| degreeSchool1 |
| degree2 |
| degreeYear2 |
| degreeSchool2 |
| degree3 |
| degreeYear3 |
| degreeSchool3 |
| degree4 |
| degreeYear4 |
| degreeSchool4 |
| degree5 |
| degreeYear5 |
| degreeSchool5 |
Parents |
Column |
ImportID |
FirstName |
| LastName |
| Username |
| NamePrefix |
| MiddleName |
| NameSuffix |
| NickName |
| MaidenName |
| Gender |
| Phone_Home |
| Phone_Mobile |
| Phone_Work |
| LanguageID |
| Email_Primary |
| Email_Home |
| Email_Work |
| Email_Personal |
Students |
Column |
ImportID |
FirstName |
| LastName |
| CurrentGrade |
| ClassOf |
| MiddleName |
| NameSuffix |
| NickName |
| Gender |
| Ethnicity |
| BirthDate |
| Phone_Mobile |
| Phone_Home |
| Email_Primary |
| SchoolID |
Relationships |
Column |
ImportID |
Parent1_ImportID |
| Parent1_Relation |
| Parent1_SP_Relationship |
| Parent2_ImportID |
| Parent2_Relation |
| Parent2_SP_Relationship |
| Parent3_ImportID |
| Parent3_Relation |
| GenderParent3_SP_Relationship |
Attendance |
Column |
schoolid |
studentid |
| date |
| category |
| note |
| Parent2_Relation |
| Parent2_SP_Relationship |
| Parent3_ImportID |
| Parent3_Relation |
| GenderParent3_SP_Relationship |
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